How to convert the column alphabets to column index

Hi There,

How do i identify the column index value by its column alphabet.
For example, If it is column A then index is 1 and if the column is D 4… like wise if it is 27 then it is AA.

TIA

@ramya_anbazhagan,

Use this thread.

Thanks,
Ashok :slight_smile:

Hi @ramya_anbazhagan

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("A")

Hi Ashok, Thanks for your reply.

But this utility is missing in my packages :frowning:

Hi Lakshman,

Thanks for your reply. But i dont find this helper.excel utility in my package. Should i upgrade the package?

TIA

@ramya_anbazhagan

Install UiPath.Excel.Activities Package then you can able to find it.

Cheers!!

@ramya_anbazhagan
Package UiPath.Excel.Activities contains this utility. Install it

Hey @ramya_anbazhagan

As answered by @lrtetala
Use below mentioned Query to Find Column Index:

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex("A")

And Use below mentioned Query to Find Column Letter:

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(1)

Screenshot for your reference:

Just Import below mentioned Namespace in the project:

UiPath.Excel.Helpers

Note: Go to Import Panel Add.

Screenshot for your reference:

You will be good to go!

Regards,
Ajay Mishra

HI Ajay,

Thanks for the detailed steps.

I can already see the UiPath.Excel.Helpers Namespace in my imports panel, but still it is not available when i try to used the code as “UiPath.Excel.Helpers” in the project.

Kindly help! TIA

@ramya_anbazhagan okay,

I think studio is not giving you the suggestion from intensenes. But are you getting the required solution, that you asked earlier in the post!?

Regards,
Ajay Mishra

Hi Ajay,

Yes it worked! :slight_smile:

Thanks!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.