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

excel
activities

#1

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.


#2

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


How to auto increment the alphabet in Excel sheet
#3

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?


#4

Yes.