Create your first automation in just a few minutes.Try Studio Web →
by Internal Labs
3
Activity
4.7k
Summary
Summary
Pass the DataTable and Column Name or Column Index and get the Column Letter within an Excel Worksheet.
Overview
Overview
This activity receives a DataTable and either a Column Name or a Column Index, and then produces the Column Letter that is associated with that Column Name or Column Index (e.g. the first column returns A, while the 27th column returns AA).
The Column Lettter can then be used with other Excel activities to read/write data to the correct column. Other Spreadsheet applications that are similar to Excel may work as well (e.g. Google Sheets).
Features
Features
This component allows users to find column letter by column name or column index (e.g. A or AB or ZZZ) without using an Invoke Code Activity.
Additional Information
Additional Information
Dependencies
n/a
Code Language
C#, Visual Basic
Runtime
Windows (.Net 5.0 or higher)
Technical
Version
1.0.8Updated
January 26, 2023Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Support
UiPath Community Support
Resources