MarketplaceStudioActivityUbiquity - Convert Index to Excel Column Letter

Create your first automation in just a few minutes.Try Studio Web

Ubiquity - Convert Index to Excel Column Letter

Ubiquity - Convert Index to Excel Column Letter

by Ubiquity Technology

3

Activity

Downloads

5.8k

back button
back button
carouselImage0
next button
next button

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)

Publisher

Ubiquity Technology

Visit publisher's page

Trusted Source

License & Privacy

Apache

Privacy Terms

Technical

Version

1.0.2

Updated

June 3, 2023

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Similar Listings