topic Re: Conversion of Excel File to CSV File in Talend Studio

Conversion of Excel File to CSV File

Anonymous — Tue, 28 May 2019 15:00:13 GMT

Hello everyone,

I have a requirement of converting excel files into a Comma separated files. Also, while converting excel files is there a possibility of inserting additional rows to the generated files.

Please help.

Thanks.

Re: Conversion of Excel File to CSV File

Anonymous — Tue, 28 May 2019 15:04:07 GMT

Hi,

It is a basic and simple task and the flow is as follows.

tFileInputExcel --->tMap---> tFileOutputDelimited

In tMap you can add additional column as per your requirement.

Re: Conversion of Excel File to CSV File

Anonymous — Tue, 28 May 2019 22:41:57 GMT

Thanks.

I was able to generate a file with an empty column as per my requirement, but i am not able to add a footer with empty values.

i.e, i need an extra row at the end of file with empty values.

Any suggestions!!