Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I`m trying to append the existing MS Excel via tFileOutputExcel function, but this function overwrites this file (all sheets are deleted, and only new sheet left)
Append existing file is checked.
What I am doing wrong?
Thanks
Val
Hello,
"Append existing file / Append existing sheet" options mean you want to write at the end of the file / sheet if it exists.
Carefully, if you try to push data to the same xlsx file to 2 different sheets in the same subjob, you'll lost the 1st one.
You could write into multiple sheets without having to use multiple subjobs.
Better to write to a tHash and then write the results to the Excel file in subsequent sub jobs.
Best regards
Sabrina