MarketplaceListingsCustom ActivityAppend Row Number in DataTable

Append Row Number in DataTable

Bronze Certified

Custom Activity

0 reviews

169

Append Row Number in DataTable

Bronze Certified

Custom Activity

0 reviews

169


Summary

This activity is useful for scenarios where you need to know the corresponding Excel row number of each row in a DataTable.

carouselImage0

Overview

Input
  1. Starting row number (Integer) - e.g. if the table in Excel starts at row 3, then the starting row number is equal to 3, the second item will = 4 and so on.
  2. Name of the column (String) - This is how you will refer to the column e.g. if name = "Row Number" , then you refer by row ("Row Number").

Input/Output
  1. DataTable - input DataTable which will be outputted with row number column appended.

Example
  1. Highlight rows in Excel where condition is met (see image / user manual for how this is done with this activity).
  2. Delete specific rows that meet condition.

Benefits


Published: 05 May 2021 | Updated: 05 May 2021

Jack Chan
RPA Developer

License

MIT


Code Language

Visual Basic


Runtime

Windows Legacy (.Net Framework 4.6.1)


Tags

AddRowNumberColumn
Append Row Number
datatable
Dt
RowNumber

Compatibility

UiPath Studio 20.10.0


Dependencies

UiPath.System.Activities 20.10.4



Similar Listings