Excel Table recognition with template file
I'm trying to generate a excel report with Xlsx recipe and a excel template file, but i can't get make the table range works.
I'm basing in this example https://playground.jsreport.net/w/anon/rJftqRaQ-10 that expand table area as you put more data.
On my test i created a excel template file and inserted a new table with a only row, and when i try generate the report with many rows, only first row is included as table part, the other rows are inserted like simple data out of the table.
There's any trick to make this works?
I was seeing that the above example don't use formulas to get the right range as the range data is incremented.
Maybe this example can help.
You can see how the xlsxMerge is used to expand the table
Thanks for reponse. But why the example that i mentioned above works without xlsxMerge. What is the diference?