Accelerators
Partner Solutions
Professional Services
Collections
Sign In
Accelerators
Partner Solutions
Professional Services
Collections
Get Column Letter
by Internal Labs
3
Activity
4.5k
Summary
Summary
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
Code Language
C#, Visual Basic
Runtime
Windows (.Net 5.0 or higher)
Technical
Version
1.0.8Updated
Jan 26, 2023Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Tags
excel
datatable
Application
Microsoft Excel
Support
UiPath Community Support
Resources
Similar Listings
