Hi, is there any way we can read data from excel file or any external file in custom keyword and use the data for further testing ? any method please?

Hi Mehran, You can refer to this links: [image] Loading test data file programmatically (Dynamic Test Data) Katalon Studio Hi Guys, Just wanted to share some ideas about test data. If your test data changes upon running your test automation it seems impossible to load it…

I am not sure about Custom Keyword but I use excel to fetch a random First Name and Last Name from a list of 2000 names, The excel formula returns a new random First Name and Last Name on a particular cell and Katalon Test picks data every time from that cell.

Hi Manpreet, For random selection approach, refer to this. . . [image] Random select value from Data file Katalon Studio I created a data file via excel sheet having 100 entries. I want to read a random value from the cell using random function. Please can someone help wi…

Hi Arnel, Well i have try both ways CSV method working fine but for the excel file its always giving the error “File not found” Object excelData = ExcelFactory.getExcelDataWithDefaultSheet(“‪D:/Testdata.xlsx”, “first_file”, true) int z = excelData.getRowNumbers() System.out.println(z) I have i…

Hi Mehran, I think it’s because you entered a wrong slash. Try changing your slash from “/” to “\”. should be like this: “D:\Testdata.xlsx” should be backslash. Hope that helps. . . :slight_smile:

Hi Arnel well with the changes its not even accepting the parameters like “D:\Testdata.xlsx” mostly in java we are using “/”

Hi Mehran, Sorry my bad, it should be double backslash… like this: D:\\Testdata.xlsx

Hi Arnel, I have done and everything and try to solve it but still its giving the error file not found. Here is the Excel file [Screenshot_3] And here is my Actual Test case with code and import and console error. [Screenshot_4] Not sure whats wrong here with Excel file.

Hi Mehran, I don’t see anything wrong with your code. Can you double check the location of the file, is it really stored in D:\\? did you save it already?

And based on your logs, it fails on test case “New Test Case” not in test case “Testdata”. Could you run the test case “Testdata” for me and send the logs here for me to see… Thanks.

Read data from excel file or csv in Custom keyword

Web Testing

Arnel January 25, 2019, 10:33pm 4

Hi Manpreet,

For random selection approach, refer to this. . .

Hope that helps. . .

Topic		Replies	Views
Read Test Data from Excel Web Testing katalon-studio	6	5609	September 2, 2020
Posibble to store all data under one excel sheet? API Testing katalon-studio , api-testing	22	2408	February 6, 2020
Write into excel at runtime during test execution Feature Request katalon-studio , feature-request	25	13918	May 9, 2019
Refresh internal excel data Web Testing katalon-studio	6	2653	June 30, 2022
Random select value from Data file Web Testing katalon-studio	8	4599	March 15, 2022

Read data from excel file or csv in Custom keyword

Related topics