Write values to specific cells in excel,
I am getting test data from an excel file (looping through project variables) and wish to write the result for a particular test into a specific column on the same row (in the same excel file) is it p...
Forum Discussion
I plan to use these values to check against what's inserted in the DB for that row in excel.
for instance:
i have 3 columns in excel named Amount,cardNumber,orderId
** Orderid column is blank since its generated by the app under test
the DB table has the same columns as in Excel this time the orderId is inserted by the APP under test
my goal was to insert the generated orderId and later use the OrderId field in a select statement to test if Amount and cardNumber from excel matches same fields in the Db table
for instance:
i have 3 columns in excel named Amount,cardNumber,orderId
** Orderid column is blank since its generated by the app under test
the DB table has the same columns as in Excel this time the orderId is inserted by the APP under test
my goal was to insert the generated orderId and later use the OrderId field in a select statement to test if Amount and cardNumber from excel matches same fields in the Db table
