topic Re: Extracting Each Sheet of Workbook as a Seperate CSV File in Talend Studio

Extracting Each Sheet of Workbook as a Seperate CSV File

Anonymous — Tue, 15 Nov 2016 11:01:41 GMT

Hi,
I am new to Talend and am stuck in this for almost two days now. I am trying to create separate csv files out of the sheets present in a workbook. The Excel has different sheets with a different schema for each sheet. If i select the schema of a particular sheet, i am able to generate the csv files but i am running into problems when i am trying to do it for all the sheets . I am not able to figure out a work around to define the schema of each sheet. Please advice.
Currently my job is tFileExcelWorkbookOpen ---> tFileExcelSheetList --> tFlowIterate --> tFileExcelSheetInput --> tFileOutputDelimited.
Thanks,
Sri Ram

Re: Extracting Each Sheet of Workbook as a Seperate CSV File

Anonymous — Wed, 16 Nov 2016 06:00:12 GMT

Hi,
How many sheets do you have in your excel file?
With talend component tfileinputexcel, you have to select the schema of a particular sheet and generate the csv files one by one.
tFileExcelWorkbookOpen is a custom component written by talend community user and shared on talend exchange portal.

Best regards
Sabrina

Re: Extracting Each Sheet of Workbook as a Seperate CSV File

Anonymous — Wed, 16 Nov 2016 06:23:58 GMT

Hi Sabrina,
Thanks for the reply.
I have 8 sheets in my Excel workbook. I am trying to figure out a way where i can dynamically select the Schema based on the sheet name instead of using 8 different sub jobs to create 8 csv files. Please advise if this is possible. Or please advise an alternative approach which i can use.
Thanks,
Sri Ram

Re: Extracting Each Sheet of Workbook as a Seperate CSV File

Anonymous — Wed, 16 Nov 2016 08:24:22 GMT

Hi,

The Excel has different sheets with a different schema for each sheet.

So far, talend don't support for "Dynamic schema" feature in tfileinputexcle component.
Best regards
Sabrina