As a followup for anyone finding this via google, etc., this was mainly an issue with my template being entirely too complex. In order to remedy the situation, I created an excel macro to re-create the more complex portions of the template after the data has been generated and added via jsreports. However, I have run into another issue, of which I'm not sure if it would be more appropriate for me to create a new forum topic or append to this one, but since it's from the root of the same issue I opted for the latter.

I created a button on the template in order to run the macro, but it seems like that button specifically is causing issues. After generating the file and attempting to open it, I get a message saying there is a problem with some content and asking "Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

After clicking Yes, the entire sheet with the button on it is blanked out. I was unable to find any forum posts or information regarding an issue like this and figured I would see if it was a known issue or if there was some method I was missing to resolve this. Thanks so much.

Alright, you've been added as a collaborator. I've got the instructions to replicate the issue in the readme.

Apologies for the late response, had other issues that needed tending to. I've created a repo on my personal github with the minimal necessary code to replicate this issue, but would prefer to keep it private if at all possible. I found what I believe to be your github account, but figured it would be rude to just invite you as a collaborator without first asking about it here.

Of course! I'll start setting that up now and respond when I have it all running as expected, just wanted to check and make sure there wasn't some standard fix for issues like this that I had missed in my research before doing all the work of setting all that up.

Hello, I've been having some issues since upgrading jsreport (using jsreport-core) from v2 with some of the more complex reports that our applications generate. There are multiple sheets generated within these templates, but the only sheets that we are interacting with are blank tables being filled with data. The portion that makes the reports more complex are the other sheets within the template with a handful of macros and a large amount of rows, etc. I have dumbed down the template as much as I can while still maintaining the functionality required, but am still having problems with the heap running out of memory.

I can include more information if it's necessary, but I have tried a multitude of approaches to this issue with no luck on my end so figured I would ask in case anyone else has seen something like this. I tried removing all custom functions referenced within the handlebars file, only calling the xlsxPrint function, but it still fails. These same reports would take a decent amount of time to generate in v2, but it would go through just fine.

And I have already tried increasing max-old-space-size, as well as the timeout, to no avail. Increasing the size just causes it to timeout, and increasing both the timeout and size just makes it run for ridiculously long times, like 10+ minutes.

Thanks so much for the quick response! The fix you recommended worked beautifully, and thanks for explaining the differences between v2 and v3 and how it handles the helpers.

I'm having some issues after upgrading from v2 to v3 involving the xlsx recipe. I am using a setup involving jsreport-core, jsreport-handlebars, and jsreport-assets. The error I'm getting:

Error: Missing helper: "xlsxTableSheet"
at Object.<anonymous> (C:\Projects2\cmd_api\node_modules\handlebars\dist\cjs\handlebars\helpers\helper-missing.js:19:13)
at Object.wrapper (C:\Projects2\cmd_api\node_modules\handlebars\dist\cjs\handlebars\internal\wrapHelper.js:15:19)
at eval (eval at compile (C:\Projects2\cmd_api\node_modules@jsreport\jsreport-handlebars\lib\handlebarsEngine.js:35:30), <anonymous>:11:133)
at Object.main (eval at compile (C:\Projects2\cmd_api\node_modules@jsreport\jsreport-handlebars\lib\handlebarsEngine.js:35:30), <anonymous>:19:4)
at C:\Projects2\cmd_api\node_modules@jsreport\jsreport-handlebars\async-helpers\index.js:61:22
at ret (C:\Projects2\cmd_api\node_modules\handlebars\dist\cjs\handlebars\runtime.js:212:12)
at Object.execute (C:\Projects2\cmd_api\node_modules@jsreport\jsreport-handlebars\lib\handlebarsEngine.js:80:14)
at Object.execute (C:\Projects2\cmd_api\node_modules@jsreport\jsreport-handlebars\lib\worker.js:27:43)
at executionFn (C:\Projects2\cmd_api\node_modules@jsreport\jsreport-core\lib\worker\render\executeEngine.js:216:40)
at sandbox.js:16:18

I've looked around on the forums/github/stackoverflow and have run out of potential solutions, but have garnered a better understanding of what may be causing the issue. Before rendering the template object with jsreport, it looks like this:

{
engine: 'handlebars',
recipe: 'xlsx',
content: '{{!-- Resize and fill table --}}\r\n' +
'{{xlsxTableSheet "Data" headers rows}}\r\n' +
'{{xlsxWrapText}}\r\n' +
'\r\n' +
'{{!-- Enforces recalculation of formula cells when file is opened --}}\r\n' +
'{{xlsxCalcOnLoad 1}}\r\n' +
'\r\n' +
'{{!-- Generates the spreadsheet --}}\r\n' +
'{{{xlsxPrint}}}\r\n',
helpers: ';(function (global) {\r\n' +
'\r\n' +
" const path = require('path');\r\n" +
' require(path.resolve(__rootDirectory, "reports/helpers/xlsx"))(global);\r\n' +
' require(path.resolve(__rootDirectory, "reports/helpers/math"))(global);\r\n' +
' require(path.resolve(__rootDirectory, "reports/helpers/util"))(global);\r\n' +
'\r\n' +
' // additional functions\r\n' +
'\r\n' +
' Object.assign(global, {\r\n' +
' // additional functions\r\n' +
' });\r\n' +
' \r\n' +
'})(this);',
xlsx: { templateAsset: [Object] }
}

When I tried hard coding the helpers instead of requiring them as I am above it worked correctly, leading me to believe that the render function is having trouble parsing the 'require' statements within the imported file. The helper files listed have a rough structure as follows:

module.exports = function (global) {
....functions listed here

Object.assign(global, {
functions aliased here
}

This worked previously with v2, I have already verified that handlebars versions are synced correctly between packages, I am using the newer packages with @jsreport/jsreport-core, and I've run out of ideas on how to move forward with this issue. Thanks for any help.