Extracting Each Sheet of Workbook as a Seperate CSV File
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
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.
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
