I’m working on a process where I retrieve information from a line in an Excel. The information from the line is then stopped into different information boxes in a business system, which in turn generates a report that is saved.
I have managed to get this if the document has a row (uses Excel Application Scope), but as soon as I add information one by one but not succeed in getting it work if the Excel file has multiple rows of information.
What I would like is that after the information from row 1 has been retrieved and a report has been created, the process should be looped and continue with the information from the row below instead; This should be looped until there are no lines left.
Any idea how I can handle this?