Accelerators
Partner Solutions
Professional Services
Collections
Sign In
Accelerators
Partner Solutions
Professional Services
Collections
Excel Index to Column
by Internal Labs
5
Snippet
306
Summary
Summary
Overview
Overview
Using a simple Convert.ToChar can help until the column name reaches value Z. This snippet will get you further and it is able to add the second character as well, e.g. QZ.
Arguments:
- in_index(int): This input argument is the index to be calculated.
- out_columnName(String): This output argument is a string containing the calculated column name.
Features
Features
It can be used on iterations for writing into Excel more easily than writing each column's name (e.g. AB, AC...).
Additional Information
Additional Information
Dependencies
Code Language
Visual Basic
Technical
Version
1.1.0Updated
Apr 5, 2023Works with
Studio: 21.10 - 23.4
Certification
Silver Certified
Tags
excel
columns
Application
Microsoft Excel
Support
UiPath Community Support
Similar Listings
