Topics created by AnejBradacVranc

Thank you. I compared the speed and the 3.13.0 is really slower on Pure_XLSX.
However, this was already addressed and will be part of the next release coming this week.
Here are the details.
https://forum.jsreport.net/topic/2853/nested-each-slow-performing

Yes, you can use script to change the xlsx asset

async function beforeRender (req, res) { if (req.data.someCondition) { req.template.xlsx = { templateAssetShortid: '5Y5DP7j' } } else { req.template.xlsx = { templateAssetShortid: 'V1qhZuH' } } }

https://playground.jsreport.net/w/anon/WFKZuw9S

You can use it through jsreport scripts(hooks)
https://jsreport.net/learn/scripts

Something like this in pseudocode. You just overwrite the result of the template with your own produced with a library.

const xlsxjs = require('xlsjs') async function afterRender(req, res) { const xlsxBuffer = await xlsjs.createSomeStuff() res.content = xlsxBuffer res.meta.contentType = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' }

Thank you for your fast replies and troubleshooting!

Thanks!