Hi, I'm doing a report for excel (xlsx), but when it was executed with json, I get the following error:

Error while executing templating engine. Cannot read property 'xl/worksheets/sheet7.xml' of undefined. Error on line 199:42.

  197 | 
  198 |   function add (filePath, xmlPath) {
> 199 |     var obj = this.ctx.root.$xlsxTemplate[filePath]
      |                                          ^
  200 |     var collection = safeGet(obj, xmlPath)
  201 | 
  202 |     var xml = escape(this.tagCtx.render(this.ctx.data).trim(), this.ctx.root)


TypeError: Cannot read property 'xl/worksheets/sheet7.xml' of undefined
    at Object.add (evaluate-template-engine-helpers.js:199:42)
    at Object.<anonymous> (evaluate-template-engine-helpers.js:429:17)
    at eval (eval at createFunctionContext (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/compiler/javascript-compiler.js:257:23), <anonymous>:6:91)
    at prog (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/runtime.js:221:12)
    at execIteration (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/helpers/each.js:51:19)
    at Object.<anonymous> (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/helpers/each.js:61:13)
    at Object.eval [as main] (eval at createFunctionContext (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/compiler/javascript-compiler.js:257:23), <anonymous>:5:34)
    at main (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/runtime.js:175:32)
    at ret (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/runtime.js:178:12)
    at ret (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/compiler/compiler.js:526:21)

My code is this:

{{#each informe}}

{{#xlsxAdd "xl/worksheets/sheet7.xml" "worksheet.sheetData[0].row"}}  
<row >  
    <c t="inlineStr"><is><t>{{empaque}}</t></is></c>  
    <c t="inlineStr"><is><t>{{zona}}</t></is></c>  
  
</row>  
{{/xlsxAdd}}  
{{/each}}
{{{xlsxPrint}}}

I uploaded a jsreport template

Thank you very much, you saved me, that was the problem. Thank you

if it works, and send mail
when I open this file I get the message "excel can not open the file because the format or extension of this are not valid"

Do you have an example of sending mail with an excel file?

Do you have an example of sending mail with an excel file?

Puedes ayudarme

a mi me sale "excel no puede abrir el archivo porque el formato o la extension no son validos"

Hi guys, can you help me?
I want to send a file excel (.xlsx) by mail (nodemailer), but I see this error.

function beforeRender(req, res, done) {
    require('request')({ 
      url:"http://#######/detalle.js", 
      json:true 
    }, function(err, response, body){
        console.log(JSON.stringify(body))
       req.data = { detalle: body };
        done();
    });
    return;
}

function afterRender(req, res, done) {
    var mailer = require("nodemailer");

    var smtpTransport = mailer.createTransport('smtps://Joseantonio%40gmail.com:###@smtp.gmail.com');

    var mail = {
        from: "Jose <@gmail.com>",
        to: "josesito@gmail.com",
        subject: "Enviado desde Jsreport",
        text: "Reporte ",
        html: "<b>Reporte excel</b>",
        attachments: [
        {  
            filename: 'Reporte.xlsx',
            content: new Buffer(res.content)
        }],
    }

    smtpTransport.sendMail(mail, function(error, response){
        smtpTransport.close();
        if(error){
            return done(error);
        }

        return done();
    });
}

---------This error appears

Error while executing templating engine. Cannot read property 'xl/worksheets/sheet2.xml' of undefined. Error on line 199:42.

  197 | 
  198 |   function add (filePath, xmlPath) {
> 199 |     var obj = this.ctx.root.$xlsxTemplate[filePath]
      |                                          ^
  200 |     var collection = safeGet(obj, xmlPath)
  201 | 
  202 |     var xml = escape(this.tagCtx.render(this.ctx.data).trim(), this.ctx.root)


TypeError: Cannot read property 'xl/worksheets/sheet2.xml' of undefined
    at Array.add (evaluate-template-engine-helpers.js:199:42)
    at Array.<anonymous> (evaluate-template-engine-helpers.js:429:17)
    at eval (eval at createFunctionContext (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/compiler/javascript-compiler.js:257:23), <anonymous>:5:94)
    at prog (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/runtime.js:221:12)
    at execIteration (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/helpers/each.js:51:19)
    at Object.<anonymous> (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/helpers/each.js:80:11)
    at Object.eval [as main] (eval at createFunctionContext (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/compiler/javascript-compiler.js:257:23), <anonymous>:5:34)
    at main (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/runtime.js:175:32)
    at ret (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/runtime.js:178:12)
    at ret (/home/marlon/jsreportapp/node_modules/handlebars/dist/cjs/handlebars/compiler/compiler.js:526:21)

I installed it like this, is it okay?

sistemas@noroil-s02:~$ npm install nodemailer
▀ ╢░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░╟
WARN engine nodemailer@6.1.0: wanted: {"node":">=6.0.0"} (current: {"node":"4.2.6","npm":"3.5.2"})
WARN engine nodemailer@6.1.0: wanted: {"node":">=6.0.0"} (current: {"node":"4.2./home/sistemas
└── nodemailer@6.1.0

npm WARN enoent ENOENT: no such file or directory, open '/home/sistemas/package.json'
npm WARN sistemas No description
npm WARN sistemas No repository field.
npm WARN sistemas No README data
npm WARN sistemas No license field.

• the result of the command npm ls nodemailer

sistemas@noroil-s02:~$ npm ls nodemailer
/home/sistemas
└── nodemailer@6.1.0

the same error keeps coming, or maybe install badly nodemailer. I can not solve it, help me

Error while executing user script. Unable to find module nodemailer
Searched paths:
nodemailer
/app/nodemailer
.

77 |
78 | function afterRender(req, res, done) {

79 | var mailer = require('nodemailer');
| ^
80 |
81 | var smtpTransport = nodemailer.createTransport('smtps://malca.kike.9%40gmail.com:6XK1x&7Z@smtp.gmail.com');
82 |

Error: Unable to find module nodemailer
Searched paths:
nodemailer
/app/nodemailer

at doRequire (/app/node_modules/jsreport-core/lib/render/safeSandbox.js:232:11)
at _require (/app/node_modules/jsreport-core/lib/render/safeSandbox.js:72:14)
at Object.apply (/app/node_modules/vm2/lib/contextify.js:288:34)
at Object.afterRender (evaluate-user-script.js:79:18)
at __runAfter (/app/node_modules/jsreport-scripts/lib/scriptEvalChild.js:120:26)
at Object.apply (/app/node_modules/vm2/lib/contextify.js:288:34)
at evaluate-user-script.js:110:1
at ContextifyScript.Script.runInContext (vm.js:59:29)
at VM.run (/app/node_modules/vm2/lib/main.js:212:72)
at run (/app/node_modules/jsreport-core/lib/render/safeSandbox.js:183:19)