Automate reading and writing excel files

[Anonymous]

Hi guys,

The right subjob is writing a writing a csv file for each tPivotToColumnsDelimited. 

And after they are all written, i wanna join them all in an unique excel file in different sheets.

So what i'm doing actually is that i read each csv file and copy it in the final excel file.

I would like to automate this process. Instead of writing the path of each file and the schema.

Maybe something with a tFileList ?

Thank you in advance,

Martin

[Anonymous]

Hi,

   If your requirement is to write each output to specific sheets of same excel file, why don't you specify the sheet name in a tFileOutputExcel so that you can do it in one shot. You do not have to write to separate csv and consolidate them later.

For each output flow, change the sheet name according to the source. You can even parameterize it but I would suggest to first try it with static values so that you will get confidence with the flow.

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 🙂

[Anonymous]

Because i'm using tPivotToColumnsDelimited and in this component you can't select the sheet where you'r writing.

So if you write in the same file it will just overwrite the previous datas.

And the ouput flow of this component is not the same as what's written in the csv file.

I haven't found others way to do what a tPivotToColumnsDelimited is doing.

Thank you anyway !