Read data from excel file or csv in Custom keyword

Product Forums Katalon Studio
22

Hi guys,

Me also trying this getting same error/exception “java.io.FileNotFoundException:” and also object is not accepting method getRowNumbers().

23

I’ve same issue …please help!!

24

I’ve stored a data from website in a variable which i want to write in a CSV(in my local) using Katalon Studio . Can somebody please provide me the code as this functionality is new for me.

Thanks in Advance !!

25

Hi @ms.mayuri111

Please refer to this plugin:
https://store.katalon.com/product/34/Excel-Keywords

And the repository where samples are available:

26

Thanks for the quick help …I’m able to write the data in excel .
but facing issue while writing the data in CSV …Can you please help me in getting the solution for this ?

27

In my keyword, I used opencsv. One thing I had to do was read in the complete CSV, do my CRUD, then write it all back out.

def csvc = new File(targetCSV).readLines()findAll({x -> !x.isEmpty()})
def foundKey = false
csvc.findAll{it.startsWith(key + ',')}.each {
	foundKey = true
	def strindex = csvc.indexOf(it)
	//change the testdata
	csvc[strindex] = key + "," + keyValue
}
if (!foundKey){
	//New key, add to file with correct execution profile
	csvc[csvc.size()] = key + "," + keyValue
}
def newFile = new File(targetCSV)
PrintWriter printWriter = new PrintWriter(newFile)
csvc.each
	    { printWriter.println(it) }
printWriter.close()
1 Like
28

Hi @Arnel how to unzip and read CSV file and get the data from the cell, Could you please help me regarding this.

29

Hi @Mehran_Shafqat,

Can you please help me to read and get the data from csv file.

30

Hi @bhargavia,

You can try this

Hope that helps. . . :slight_smile:

31

Create an Excel Test Data
Select File > New > Test Data from the main menu. The New Test Data dialog is displayed. Enter the name for your test data and select Data Type as Excel File. Click OK.

Browse to the Excel file that you want to import into Katalon Studio.

Data from the selected Excel file is populated into the preview section below.

Save the Test Data when you finish. The data set defined here can be utilized in other configurations. For example, you can use it to input data for keywords in Manual View or data for Test Execution when setting up test suites.

32

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?