Loop Dataset using Excel Actions
Use the appropriate 'Excel' actions to populate a dataset with the grabbed data
This sample task will use the appropriate 'Excel' actions in Automate to grab data from the first few rows and columns of an Excel Document (rows 1 to 5 and columns A to C) and populate a dataset with the grabbed data. It will then loop through the rows of the dataset and show the data within each column of the current row in a message box. With each successive loop the current row of the dataset is incremented.
Note: The task will prompt you to select an Excel document from which to grab the data from. Make sure that the selected document includes at least some data in the first 5 rows/ columns.