Create your first automation in just a few minutes.Try Studio Web →
by Ubiquity Technology
3
Activity
5.7k
Summary
Summary
This activity 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. 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
None
Code Language
C#, Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License & Privacy
Apache
Privacy Terms
Technical
Version
1.0.2Updated
June 3, 2023Works with
Studio: 21.10 - 22.10
Certification
Silver Certified
Collections
Support
UiPath Community Support