Hello,

I apologize. The first demo that I provided you with was the wrong one. I wanted to provide you with a xlsx recipe that is written with combination of xlsx helpers. The second sample i gave you was correct (XLSX recipe made with a templating engine implemented directly in the xlsx template.
I will rephrase our problem:
After the update the xls recipes have drastically slower rendering times. An Identical XLSX recipe on version 2.10.0 renders faster than on 3.13.0. XLS recipes with a templating engine implemented directly in the xlsx template are additionally two times slower than the normal XLS recipes made with xlsx helpers on 3.13.0.

Here is the correct demo of the XLS recipe written with the help of XLS helpers that is causing us problems:
It's under the name Pure_XLSX
https://playground.jsreport.net/w/AnejBradacVranc/0RJEPt1Q

Hello,

would it be possible for us to make a custom localize method ?. When we call it many times in a report it affects performace drastically.
So instead of:
{{localize "name" "/loc"}}
It would be:
{{myLocalize "name"}}

Hello. We recently updated from 2.10.0 to 3.13.0. We had some reports written in XLSX. Rendering times got severely worse after the update. Here are some measurements:
The tables have around 206000 rows when everything is rendered.
XLS 2.10.0 - 19 sec
XLS 3.13.0 - 1 min
XLS template 3.13.0 - 2min
I am sending you some sample code on the playgrounds:
The written XLSX is under the EXCEL_sample on this playground: https://playground.jsreport.net/w/AnejBradacVranc/0RJEPt1Q
The XLSX template is under DelovneUre on this playground: https://playground.jsreport.net/w/AnejBradacVranc/iUly8ySv

Am I missing something? We updated to 3.13.0 for preformance reasons and now the XLSX preforms worse. We were hoping we could replace the hand written XLSX reports with XLSX templates.

I have seperate XLSX template files. I am wondering if I can have only one xlsx template and change its xlsx asset through code, based on a setting in the data. Because now i have one template for each xlsx asset..

Thank you for your fast replies and troubleshooting!

Thanks!

Thanks, and here is the demo for the html-xls. The main problem we have is preformance. On the server It works, but here, on the playground it crashes.
https://playground.jsreport.net/w/AnejBradacVranc/0RJEPt1Q
It's the EXCEL_sample file.

Here is the demo. It's the one with the PDF_sample:

https://playground.jsreport.net/w/AnejBradacVranc/0RJEPt1Q

Hello, how can I setup the exceljs library in jsreport to generate Excel reports?

Thank you for the Excel template advice! Would it be also possible to set the cell format? So let's say we have a global time format setting that can be decimal (HH.mm) or normal (HH:mm). I would need to change the cell formats according to the global setting so Excel can recognize the values correctly.

We also have a requirement to conditionally hide rows.