Write to excel getText

Product Forums Katalon Studio
,
1

Hi,

I am looking for a method in which I can validate the sum of the individual amounts of each item in my shopping cart.

I want to extract these amounts using the getText function and paste them into an excel file so that I can get the amounts, validate them and save them as a test proof. Basically writing into an excel workbook.

Let’s say the price for each item are as follows:

Price1
Price2
Price3

I want my excel file to contain these values as follows:

image

Any kind of help is very much appreciated!

2

This may help you:
https://store.katalon.com/product/34/Excel-Keywords#qa-content

3

Hi @Dave_Evers, thanks for your reply!

In the comments I’ve read that this plugin is causing some sort of errors relating to versions 7 and forward. I will give it a try anyways.

Do you have another method?

4

You might find an answer in this posting: https://docs.katalon.com/katalon-studio/docs/write-data-into-excel-file-at-runtime-during-test-execution.html