Extracting Data from Excel using Column Alphabet instead

Help Studio
2

Hi,

But I just need help if there is a way to extract the data by typing in the column alphabet for example column B from excel to be “B” into the input dialog instead of keying in “2”.

Can you try to use the following expression?

UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex(ColumnLetter)

ConvertColumnLetterToColumnIndex method returns index number of the column like R1C1 style.
For example, if you set "B" in the above expression, it returns "2".

Regards,

2 Likes