topic Re: Append row to the existing excel file in Talend Studio

Append row to the existing excel file

Anonymous — Sat, 16 Nov 2024 07:34:18 GMT

Hi,

I want to append row to the existing excel file. When I enable "Append existing file" option in tFileExcelOutput component. It is overwriting the existing data with the current data. Can I get solution?

Thanks in advance,

Meghana.

Re: Append row to the existing excel file

manodwhb — Thu, 27 Sep 2018 07:28:56 GMT

@MeghanaKottala,have you ticked Append existing sheet?

can you show the component setting?

Re: Append row to the existing excel file

Anonymous — Thu, 27 Sep 2018 07:43:14 GMT

Oh sorry,

I thought appending sheet option has to be enabled only when you want to append another sheet to existing file.I just enabled now. It's working.

Thanks,

Meghana.