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.
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.
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!
