MarketplaceStudioSnippetConvert Numbers to Excel Column Name

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

Convert Numbers to Excel Column Name

Convert Numbers to Excel Column Name

by Parthasarthi Pathinathan

2

Snippet

Downloads

249

QBOT003 AIHS
Posted 4 years ago

Hello, why am I getting the "previous" column? For instance, in a DT the index starts with 0, 0 would be A in Excel, 1 B, etc, but if I put in 1, the returned column name says A instead of B

Parthasarthi Pathinathan
Posted 4 years ago ago

Hi, Yes, as you said datatable index starts with 0. But for excel it starts with 1. If you need to the index of the datatable column, you have to subtract the excel cell index with 1.

Publisher

Parthasarthi Pathinathan

Visit publisher's page

License & Privacy

MIT

Privacy Terms

Technical

Version

1.0.1

Updated

February 18, 2020

Works with

Studio: 18.4.1 - 22.10

Certification

Silver Certified

Tags

Application

Microsoft Excel

Support

UiPath Community Support

Resources