One Star

writing data to multiple sheets of a single excel file

Hi,
As per my requirements i need to write data into different sheets of a same excel file. I used multiple tFileOutputExcel components in a single job by passing different sheet names as context variables. But I realised that in a single job if multiple tFileOutputExcel components are used data is being written only to the last sheet.
Is there a way to handle this in a single job?
Thanks in advance.
Abhineet
2 REPLIES
One Star

Re: writing data to multiple sheets of a single excel file

Hi,
As per my requirements i need to write data into different sheets of a same excel file. I used multiple tFileOutputExcel components in a single job by passing different sheet names as context variables. But I realised that in a single job if multiple tFileOutputExcel components are used data is being written only to the last sheet.
Is there a way to handle this in a single job?
Thanks in advance.
Abhineet

looking for some help??
Community Manager

Re: writing data to multiple sheets of a single excel file

Hi
You can find a solution in 18579.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business