topic Re: Automate reading and writing excel files in Talend Studio

Automate reading and writing excel files

Anonymous — Sat, 16 Nov 2024 05:36:04 GMT

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

Re: Automate reading and writing excel files

Anonymous — Thu, 13 Jun 2019 14:12:44 GMT

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 🙂

Re: Automate reading and writing excel files

Anonymous — Thu, 13 Jun 2019 14:32:09 GMT

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 !