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
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
Hi Ashok, Thanks for your reply.
But this utility is missing in my packages
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
Package UiPath.Excel.Activities
contains this utility. Install it
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!
Thanks!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.