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
26 Jan 2023Works with
Studio: 2020.10+
Certification
Silver Certified
Tags
excel
datatable
Application
Microsoft Excel
Support
UiPath Community Support
Resources
Similar Listings
