topic Re: tfileInputExcel export data - to specific sheet columns in Talend Studio

tfileInputExcel export data - to specific sheet columns

hgromek — Sat, 16 Nov 2024 06:33:57 GMT

I need to replace data from A:R on Sheet1 in an excel file I have excel formulas in S,T,U,V. is this possible?

Re: tfileInputExcel export data - to specific sheet columns

akumar2301 — Mon, 18 Feb 2019 19:41:58 GMT

Yes , you can update an existing excel file using tfileexceloutput

use properties ' Append existing file' , 'Apeend existing sheet' , 'Is absolutr Y pos.' define the position from where update should start in your case A0.

Re: tfileInputExcel export data - to specific sheet columns

hgromek — Fri, 10 May 2019 13:57:45 GMT

Hi - following up on this, I have 2 issues -I have the columns loading the correct information however

1st - the number of rows is fluctuating. So sometimes it can be 1500 rows, next update is 1000 rows. How (without replacing the sheet, since there are formulas attached to data) can I remove the data at the end. It loads but leaves old data.

2nd - the excel formulas don't auto-calculate, I need to resend them to trigger them.

Can anyone help with either of these? I would appreciate it!