Merging Dynamic Cells in xlsx report.
-
Hai,
I am trying to generate report in excel format. I am trying to merge the cells dynamically (i.e) inside {{#each}}. Unfortunately I am not succeeded and getting the following error "We're sorry, we couldn't open your workbook. It's possibly corrupt or using a file format that's not supported."I am not sure what I am missing.
Please help me get this resolved.
-
Here is the demo for cells merging.
https://playground.jsreport.net/w/anon/rkX89bHD-2To troubleshoot the errors it is recommended to download the xlsx. Unzip it and compare the xml files with a working xlsx created directly in excel.
It is tedious but the closest you can get when analyzing the error.