How to add new column and write back to excel without having to re-write entire file

How to add new column and write back to excel without having to re-write entire file. Right now it is writing back the entire file and messing up the numerical format from the original excel file.

How about this way?
Excel_NewCol.xaml (11.0 KB)

1 Like

If Iā€™m reading this correctly, this should search for the last column and then adds a new column onto the excel sheets and ignores the rest of the data on the sheet?

Yes.