Exporting to Excel - Table (keep formatting in place)

B. Or use loop
1 copy template.xlsx
2 run transformation which updates copy of template.xlsx
3 rename template.xlsx = > customerN.xlsx
4 repeat 

Can I request for  an example of this ?

HI,

1. It's working when there is only 1 table to be written to the excel file. Hidden or otherwise , YAY on that.

2. Here is an example when in same output I am writing to TWO tables in same excel file and it fails AND my template is deleted again.   LOOM

3. Also (for me) it's detecting extra fields in table when table is in the middle. 

RE: Creating Multiple Excel Files using template.

I have created a working example for you.





Please see attached zip file

Re: Here is an example when in same output I am writing to TWO tables in same excel file and it fails AND my template is deleted again.

That was corrected in the latest release.

Peter.Jonson wrote:

Re: Here is an example when in same output I am writing to TWO tables in same excel file and it fails AND my template is deleted again.

That was corrected in the latest release.

Thanks , I have discovered another bug. SEE LOOM VIDEO

We will have a look at it for you,

Please start another thread if you find something else.