Auto iterate through each column

[Pravin_S]

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

[Anil_G (Anil Gorthi)]

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

Cheers

[Yoichi]

Hi,

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

Sample20221210-1aL.zip (2.5 KB)

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

Regards,

[Pravin_S]

Thanks @Anil_G & @Yoichi