xlsxAddImage error when run under local server

symphony2014

I just run jsreport under my local server, and try to add an image to existed xslx template. error happened,but online version(https://playground.jsreport.net/studio/workspace/Hk2B9bcif/3) is OK, anyone can help me?:

Error occured - Error during rendering report: Cannot read property 'r:id' of undefined
Stak - evalmachine.<anonymous>:249
      var rid = this.ctx.root.$xlsxTemplate['xl/worksheets/' + sheetFullName].worksheet.drawing.$['r:id']
                                                                                                 ^

TypeError: Cannot read property 'r:id' of undefined
    at Object.ensureDrawingOnSheet (evalmachine.<anonymous>:249:98)
    at Object.addImage (evalmachine.<anonymous>:324:48)
    at Object.<anonymous> (evalmachine.<anonymous>:408:17)
    at Object.eval [as main] (eval at createFunctionContext (C:\Users\user\Desktop\xiaolin.niu\doc-generater\node_modules\handlebars\dist\cjs\handlebars\compiler\javascript-compiler.js:255:23), <anonymous>:5:89)
    at main (C:\Users\user\Desktop\xiaolin.niu\doc-generater\node_modules\handlebars\dist\cjs\handlebars\runtime.js:173:32)
    at ret (C:\Users\user\Desktop\xiaolin.niu\doc-generater\node_modules\handlebars\dist\cjs\handlebars\runtime.js:176:12)
    at ret (C:\Users\user\Desktop\xiaolin.niu\doc-generater\node_modules\handlebars\dist\cjs\handlebars\compiler\compiler.js:525:21)
    at C:\Users\user\Desktop\xiaolin.niu\doc-generater\node_modules\jsreport-handlebars\lib\handlebarsEngine.js:25:14
    at evalmachine.<anonymous>:1:41
    at ContextifyScript.Script.runInContext (vm.js:59:29)

jan_blaha

The line where the it crashes is here
https://github.com/jsreport/jsreport-xlsx/blob/master/static/helpers.js#L247

It seems that your xlsx template has unexpected xml node drawing in the xl/worksheets/sheet1.xml.
What jsreport version do you use? I would try to replicate it.
Is the xlsx template uploaded to the playground really the same?

symphony2014

I just used jsreport 1.10.0 version. And I fixed that by add this line code in file: jsreport-xlsx /helper.js :247 :
this.ctx.root.$xlsxTemplate['xl/worksheets/' + sheetFullName].worksheet.drawing=this.ctx.root.$xlsxTemplate['xl/worksheets/' + sheetFullName].worksheet.drawing[0];

symphony2014

It seems like the drawing is Array, but the program try to regard as Object.

jan_blaha

Thank you.
I've add to the back log task to make it working also when the drawing is an array.

jan_blaha

https://github.com/jsreport/jsreport-xlsx/issues/34