Convert Excel Sheets as a Seperate CSV File

[Sirasit_Mahawanitwong]

Hi all

Right now, I'm stuck on how to convert excel sheets as a seperate CSV files.

For example:

A.xlsx has sheet1,sheet2,sheet3

B.xlsx has sheet2,sheet3

C.xlsx has only sheet1

Noted that every sheet has same metadata and column.

The expected output should be:

A_sheet1.csv

A_sheet2.csv

A_sheet3.csv

B_sheet2.csv

B_sheet3.csv

C_sheet1.csv

Currently I created the workflow like this:

tFileList ----> tFileInputExcel ---->tFileOutputDelimited

the result I got:

A_sheet3.csv

B_sheet3.csv

C_sheet1.csv

Any help is appreciated.

Thank you

[fdenis]

are you on the open version?
if yes you have to extract each sheet and save data on delimited file.
if not you may use dynamic type to build a generic job. then call it using the right context.
good luck

[Sirasit_Mahawanitwong]

I believe it's not Open studio since It said Talend Big Data Platform.

I'm quite new to Telend, so apology for my inexperience

I'll look into dynamic type when I get back to work

Thank you

[Anonymous]

@splinter406 

Please use the below documentation for quick reference.

https://help.talend.com/reader/9NRa~CylzTWZ8bFvUjlang/yJ3uVEzDciOxdy9B9G1tBw

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Sirasit_Mahawanitwong · Accepted solution]

After digging around, I found the solution in this link: 

https://community.talend.com/t5/Design-and-Development/converting-one-xlsx-file-into-multiple-csv-fi...

willm's solution works like a charm!

Anyway, thank you everyone for helping me out.