(TEST DATA) Define specific Excel Sheets to get Excel Values

You have to use variables


how does one get the iteration ID or rather the rowcount during runtime as katalon iterates through my spreadsheet? I tried using a loop and getRowNumbers(), but when I do that it just keeps reading the first row only of my test data (no longer iterates)

Hello guys,
can i have some help ?
I have import an excel with user emails and passwords.
When i run the test alone it stops on the email input and does not move on.
When i run the whole test suite, the same issue appears again.
Any ideas?

I found in the screenshot you are using WebUI.setEncryptedText(). Are you sure? Why not you use WebUI.setText()

1 Like

@kazurayam You are right!!
It worked… thanks a lot!

Hi , Is there any way to use relative path instead of full path like this here
Object excelData = ExcelFactory.getExcelDataWithDefaultSheet(“/Data Files/PC_Entities.xlsx”, “Sheet1”, true)

It gives me error as of now , File not found exception

You want to change this absolute path, which would points to nothing, to

“./Data Files/PC_Entities.xlsx”

… path relative to the Current Directory = the project root directory.

Thank you. It worked