Conversion of Excel File to CSV File

[Anonymous]

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.

[Anonymous · Accepted solution]

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.

[Anonymous]

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!!