Next to each row in datatable, write number (1 , 2 , 3 and etc.)

[Povilas_Jonikas]

Hello guys. I would love to get help on a job that im trying to do. I have a data table that I take scrape from google. I need to figure out how to number the first collumn rows. Example:

This is how I get data now:

This is how I would love to get it:

Thanks in advance

[vishal.kp (vishal)]

Hi @Povilas_Jonikas ,

Refer the following thread:

Add Serial Number to an already existing Datatable

Hi Devs, pls I will like to add S/N alues to a datatable e.g 1,2,3,4,5,6,7,8,9 10 etc but the challenge is I am using the code below and the resulting S/N output is not in the right sequential order.Pls assist.Regards For Each row as Datarow in dtTest.rows If (ColumnAmount = ColumnItemAmountInReasons ) Then DT.rows.Add(New Object(){dtTest.rows.indexOf(row), Name, MobileNumber}) End If Next

Regards,

[mkankatala (Mahesh Kankatala)]

Hi @Povilas_Jonikas

Read the Excel file and store it in a datatable variable. Use Build datatable activity to create a new datatable. Map the columns in the new datatable in build datatable activity. Use for each row in datatable activity to iterate the extracted datatable. Use the add data row activity to add the data in to the new datatable. For slno column take a counter variable and give that counter variable in the add data row activity. After add data row activity increment the counter value.

Finally, use write range workbook activity to write the new datatable data in to the excel file.

Hope it helps!!

[Povilas_Jonikas]

Thanks guys!