Based on multiple user requests, we created 2 examples covering the excel spreadsheet iteration (row by row or cell by cell).
Currently, when you use the Get Cell Value (Cell below) or Get Row (Next) in a While loop, the active cell stays the same and does not jump to next cell/row in each iteration.
This is because the Get action does not make the target cell active. To overcome this inconvenience, you need to use an additional Set Cell Value (Cell below) or Delete Cell (Cell below) actions.
Below you can find two examples showing how to iterate trough Excel file:
excel_examples.zip (19.4 KB)
Example 1 - reading excel column to a List variable
Example 2 - reading excel spreadsheet to a Table variable
In the 1.1.4 release, we will introduce 2 new actions that will allow to do this more efficiently:
- Set Active Cell
- Get Range