Hello friends,
I wanted to grab information from excel during the playback for use in the next step. To do this, I wrote a script to read data from an .xlsx spreadsheet which loops through each row and grabs the information I need. However, after it reads the last row of data, it does not recognize the next row, which is blank and the execution stops.
The execution report shows a failure…I checked the log file and it says: “Execution stopped because of an error: No more lines in Excel”. Has anyone ever seen this error before?
@amit_singh What are your scenario steps?
@70stephanie
Here is the screenshot of the section:
It checks if the row is empty, and if not, will read it.
The awplayer log says:
Execution stopped because of an error: error = No more lines in Excel => Exit Scenario type = resource type error: must be fixed by the user scenario
hey @amit_singh,
I guess it is easier if you use “ForEach Line” action instead of Loop. It repeats the execution of child actions for each line of the Excel. Something like this:
6 Likes
@Paul That was the trick! Thanks 