• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » writing data to multiple sheets of a single excel file

#1 2011-11-03 14:23:27

abhineet singh
Guest

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 2011-11-04 05:34:28

abhineet singh
Guest

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

abhineet singh wrote:

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??

#3 2011-11-04 06:53:53

shong
Talend team
Registered: 2007-08-29
Posts: 10297
Website

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

Hi
You can find a solution in [Forum, topic 18579] Want to create multiple sheet in tFileOutputExcel.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » writing data to multiple sheets of a single excel file

Board footer

Powered by FluxBB