Auto iterate through each column

How to Auto iterate through each column in Excel from A to B and C to D it should be dynamic

Hi @Pravin_S

If you want to iuse cell index and want the column to be iterated then use chr(65+loopcounter) this gives you the excel column

While loop for how many ever columns you need…
(In arguments you have index use it as loop counter

And inside you get each column for each iteration



Hope the following sample helps you.
We can use UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex method etc. (2.5 KB)

Please note that it might be necessary to add UiPath.Excel.Helpers to Import tab.


Thanks @Anil_G & @Yoichi

1 Like

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