Writing to Excel file row by row during runtime

Product Forums Katalon Studio
,
1

My automation scenario is:

  1. User signs in.
  2. Registers for an Event.

My script reads data from an excel file, each row is a unique user and has registration details.
The script launches browsers > Signs in > Registers > Closes the browser.

After executing a row, I would like to update the ‘Status’ column with Pass or Fail. The update has to happen for each row and update ‘Status’ column in each iteration.

Katalon Studio is not having in-built feature to update to the Excel file. How to update the excel file for each test iteration? Kindly help.

2
3

This works fine for single iteration. I would like to update each row in each iteration. How to pass row number dynamically for each iteration?

4

How to pass row number dynamically for each iteration?

I do not see how the Excel sheet would look like.

How do like to identify each iteration?

5

One idea could be — use the timestamp of each Test Suite execution.