MarketplaceStudioActivityGet Column Letter

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

Get Column Letter

Get Column Letter

by Internal Labs

3

Activity

Downloads

4.7k

back button
back button
carouselImage0
next button
next button

Summary

Summary

Pass the DataTable and Column Name or Column Index and get the Column Letter within an Excel Worksheet.

Overview

Overview

This activity receives a DataTable and either a Column Name or a Column Index, and then produces the Column Letter that is associated with that Column Name or Column Index (e.g. the first column returns A, while the 27th column returns AA).  

The Column Lettter can then be used with other Excel activities to read/write data to the correct column.  Other Spreadsheet applications that are similar to Excel may work as well (e.g. Google Sheets).

Features

Features

This component allows users to find column letter by column name or column index (e.g. A or AB or ZZZ) without using an Invoke Code Activity.

Additional Information

Additional Information

Dependencies

n/a

Code Language

C#, Visual Basic

Runtime

Windows (.Net 5.0 or higher)

Publisher

Internal Labs

Visit publisher's page

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.0.8

Updated

January 26, 2023

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Application

Microsoft Excel

Support

UiPath Community Support

Resources

Similar Listings