Populate an excel file

citrods — Mon, 01 Feb 2021 18:27:12 GMT

Hello

I have an excel files with several worksheets.

For each excel file, I was able to extract information I needed in the different worksheet and I coul make some operations .

In each excel file, there is a worksheet called "recap" which needs to be populated based on the information I extracted.

I'd like to populate this worksheet but the format is a bit tricky because I have 3 different sections

see screenshot below

Is it possible to populate such a worksheet with a tmap for example?

If not, how I can I create a worksheet called "recap" with the informations required?

The information I extracted are stored in temporarty excel files which can be used to populalte my excel file.

thank you.

Re: Populate an excel file

David_Beaty — Thu, 04 Feb 2021 08:47:01 GMT

Hi,

You can do this, but its quite fiddly. Use the tFileOutputExcel and enable "is Absolute Y pos", which allows you select the first column and row to populate.

So, in your example you'd need to do it in 3 sets of output for the total, year and quarter.

Thanks

David

topic Populate an excel file in Talend Studio

Populate an excel file

Re: Populate an excel file