topic Re: Convert Excel Sheets as a Seperate CSV File in Talend Studio

Convert Excel Sheets as a Seperate CSV File

Sirasit_Mahawanitwong — Sat, 16 Nov 2024 04:35:19 GMT

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

Re: Convert Excel Sheets as a Seperate CSV File

fdenis — Tue, 24 Sep 2019 13:15:53 GMT

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

Re: Convert Excel Sheets as a Seperate CSV File

Sirasit_Mahawanitwong — Tue, 24 Sep 2019 14:22:25 GMT

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

Re: Convert Excel Sheets as a Seperate CSV File

Anonymous — Tue, 24 Sep 2019 21:42:09 GMT

@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

Re: Convert Excel Sheets as a Seperate CSV File

Sirasit_Mahawanitwong — Wed, 25 Sep 2019 06:29:57 GMT

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-file/td-p/91786

willm's solution works like a charm!

Anyway, thank you everyone for helping me out.