Sign In
Create your first automation in just a few minutes.Try Studio Web →
Ubiquity - Convert Index to Excel Column Letter
by YouTube
1
Activity
<100
Summary
Summary
Receives as input the column number index and converts it to column letter (uppercase).
Overview
Overview
This component is based on the ASCII table, if the number received is 2 it will return B.
Use case:
Imagine this scenario: you have a large Excel file and you know that one of the fields that you need in your datatable is in the index 208 that you need to write in the Excel file with the activity WriteCell and you need the correct coordinate. You just need to include this activity, pass the index and you will get HA as your Excel coordinate to write in the correct cell.
As an option, you can use column number instead, just remember that the index is zero based.
Features
Features
Easly convert Excel column number to Excel header letters
Additional Information
Additional Information
Dependencies
No dependencies
Code Language
Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License & Privacy
Apache
Privacy Terms
Technical
Version
1.0.2Updated
February 18, 2020Works with
UiPath Studio >= 2018.3
Certification
Silver Certified
Application
Support
UiPath Community Support
Similar Listings