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)
How to auto increment the alphabet in Excel sheet
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?