How to add prefix to all column name in excel, how to rename all columns

Help Activities
, , , , , , ,
2

Hi @Nidhi_Gupta1
1.Read Excel file and stored in datatable dt_input.
2.Use For each activity Pass variable as dt.columns
inside for each take one assign activity
column.ColumnName = “Data1_” + col.ColumnName
3. Use the Write Range activity to write the updated DataTable back to Excel.

Happy Automation

1 Like