Accelerators
Partner Solutions
Professional Services
Collections
Sign In
Accelerators
Partner Solutions
Professional Services
Collections
Append Row Number in DataTable
by Jack Chan
0
Activity
2.3k
Summary
Summary
Overview
Overview
This activity is useful for scenarios where you need to know the corresponding Excel row number of each row in a DataTable.
Input
- 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.
- 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
- DataTable - input DataTable which will be outputted with row number column appended.
Example
- Highlight rows in Excel where condition is met (see image / user manual for how this is done with this activity).
- Delete specific rows that meet condition.
Features
Features
Additional Information
Additional Information
Dependencies
Code Language
Visual Basic
Runtime
Windows (.Net 5.0 or higher)
License & Privacy
MIT
Privacy Terms
Technical
Version
1.0.1Updated
Oct 10, 2022Works with
Studio: 22.4.6 - 22.10
Certification
Silver Certified
Tags
AddRowNumberColumn
Append Row Number
datatable
Dt
RowNumber
Application
Microsoft Excel
Support
UiPath Community Support
Resources
Similar Listings
