Is it possible to get objects from an excel file?

Product Forums Katalon Studio
,
1

I have the following excel file showing ObjectName | ObjectID | ObjectValue.

|Column 1 | Column 2 | Column 3 | Column 4|

|— | — | — | —|
|ObjectName | ObjectID | ObjectValue | |
|SignName_username | //input[@id=‘username’] | qarisc_admin_auto | |
|Password | //input[@id=‘password’] | 1 | |
| | | | |
| | | | |
| | | | |

How is it possible to get the objects? to execute the following?

Click on the object
Set text to the object

2

If you are trying to read data in from an Excel spreadsheet, you can possibly do it as below. You will have to adjust the references to your cell locations.

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

gTestIdPathWay = "G:\\Katalon Test Cases\\Data Files\\TestId RT-WP-003"

FileInputStream fis = new FileInputStream (gTestIdPathWay);
XSSFWorkbook workbook = new XSSFWorkbook (fis);

XSSFSheet sheet = workbook.getSheet("Sheet1");

// get customer name from cell A2
Row row = sheet.getRow(1);
Cell cell = row.getCell(0);
userName = cell.getStringCellValue();

// get item name, or upc, from cell A6
row = sheet.getRow(5);
cell = row.getCell(0);
tempReferenceName = cell.getStringCellValue();

// get the sales staff from cell A9
row = sheet.getRow(8);
cell = row.getCell(0);
gSalesStaff = cell.getStringCellValue();

fis.close();
3

this will never work for katalon recorder product.
read the topics carefully prior to reply.
it was, yet again, posted under a wrong section

4

I assumed the above was the Excel file. Perhaps the OP can clarify.

5

you also assumed is about Katalon Studio.
but is not.

6

If @bionel is correct and you are using the browser extension, Katalon Recorder, then the above code I posted is not possible. In your heading, you have Katalon Studio. Katalon Studio and Katalon Recorder are two separate applications.

7

You can create an instance of the com.kms.katalon.core.testobject.TestObject class by code. See

import com.kms.katalon.core.testobject.TestObject
import com.kms.katalon.core.testobject.ConditionType
...
TestObject testobject = new TestObject("1st mail sender")
String expr = '//table/tbody/tr[1]/td[5]/div[2]/span/span'
testobject.addProperty("xpath", ConditionType.EQUALS, expr)

Here you need to specify 2 string values as parameters. You should be able to pick up the id and xpath from your excel file and use them.