Excel Writer with dynamic Sheet Name

More
7 years 2 months ago - 7 years 2 months ago #15367 by daniel.fung@xerox.com
HI I am using v5.9.2.3 and trying to create an excel file with dynamically named sheets using a variable i set before in a loop , called <SheetName>

instead of say 50 sheets of data, i get 1 sheet named <SheetName>. Does ETL excel writer support variables in the writer config as shown below

if not, can you provide/support this feature or tell me how to arrange this. I have the requirement to generate a report of about 100 sheets. Each sheet name is a number that means something.

Attachments:
Last edit: 7 years 2 months ago by daniel.fung@xerox.com.

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #15368 by admin
Looking at it now

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #15369 by admin
Here is an example of how it can be done based on the example in the default repository





Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #15370 by daniel.fung@xerox.com
Thanks , it works, i was close, seems that i needed the {GetVariable('<MySheetName>')} syntax for sheet name:

i am not sure what SourceChanged; in the calculation does however.

Please Log in or Create an account to join the conversation.