How to achieve the fuction of for each excel "column"

Good morning. I am making a process of excel. And i met a problem. I need not only row can set up a variable, but also “column” can set up a variable. But the position of cell is like “A1” ""B2"“C3”.So i can set up a variable of row, because it is ‘1’ ‘2’ ‘3’. But about the column, due to it’s A B C D AA AB AC. So what can i do for this , how to set up a variable of column?

Hi,

How about using UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter method as the following. for example?

Sample
Sample20240606-2.zip (9.8 KB)

Regards,

1 Like

Thank you very much !! :smiley_cat:

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