I have a XLSX file with two sheets in it and I want to use each sheet as a template for two different sheet in two XLSX writers but the same XLSX destination file.
I tried to do so and it is not working. My first sheet (writer) gets empty after the data is written into the second sheet (writer). It looks like the "Template Sheet" parameter isn't working. I chose my Template File but if I let the Template Sheet empty for the two writers, nothing changes.
I've read in the doc : When you specify a Template File, you can select one of the sheets as the template sheet. Click the browse button to view the list.
Where is that list?? I don't see any sheet list, I have to write it down by my own...
Cheers!