How to Auto iterate through each column in Excel from A to B and C to D it should be dynamic
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.
Sample20221210-1aL.zip (2.5 KB)
Please note that it might be necessary to add UiPath.Excel.Helpers to Import tab.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.