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…
How do you do that?
So this is added inside the excel application scope activity?
Sorry I am new to rpa.
Not necessary to be in excel application scope buddy