Convert Excel Sheets as a Seperate CSV File

Highlighted
Five Stars

Convert Excel Sheets as a Seperate CSV File

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

 


Accepted Solutions
Five Stars

Re: Convert Excel Sheets as a Seperate CSV File

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.


All Replies
Twelve Stars

Re: Convert Excel Sheets as a Seperate CSV File

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Five Stars

Re: Convert Excel Sheets as a Seperate CSV File

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 Smiley Happy

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

Thank you

Employee

Re: Convert Excel Sheets as a Seperate CSV File

@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

Five Stars

Re: Convert Excel Sheets as a Seperate CSV File

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now