I need to give column name for a column that I recently added to excel sheet ? Any guidance ?
to rename directly in excel sheet, you can use
write cell activity
To rename column name in a datatable, you can use
Dt.Columns(0).ColumnName = “newColumnName”
Where 0 is the index of the column to be renamed.
While adding new column to datatable itself you can provide name…