MarketplaceStudioSnippetExcel Index to Column

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

Excel Index to Column

Excel Index to Column

by Internal Labs

5

Snippet

Downloads

326

back button
back button
carouselImage0
next button
next button

Summary

Summary

This snippet translates a numeric into the corresponding Excel Column name.

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

None

Code Language

Visual Basic

Publisher

Internal Labs

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.1.0

Updated

April 5, 2023

Works with

Studio: 21.10 - 23.4

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Similar Listings