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

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 :slight_smile:

Hi @Povilas_Jonikas ,

Refer the following thread:


1 Like

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!!

1 Like

Thanks guys!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.