Append ID Column to Existing Excel File

Help Activities
, , , , ,
1

Hi,

I have this Excel file and I need to append a column named “ID” which is just the row number -1 as shown below:

image
image1073×396 14.3 KB

image
image1215×381 31.9 KB

The amount of data is undetermined so the numbering of ID should be dynamic.

Can anyone help please?

Thanks!

UIPath_Excel_Scratch (6).xlsx (25.2 KB)

2

Hi @Yudhisteer_Chintaram1

Please use my package,there is an activity called add Sno column by default it will be added at 1st column after that you can change the column name and column order as you want.

Change column name

In Assign activity left side give dtTable.Columns(“OldCoumnname”).ColumnName and in right side five your new column name

Change Column Order