Home > Automation Testing > Read data from excel sheet using Katalon Studio

Read data from excel sheet using Katalon Studio

This post was most recently updated on July 25th, 2017

It it very easy to get data from excel using Katalon Studio. For Data driven test cases we need excel sheet. In this article will see how to use excel sheet in KATALON studio by using findTestData method.

  1. Select Menu File -> New -> Test Data (Katalon studio will show “New Test Data” Dialog.
  2. Provide Test Data Name in “Name” Text box.
  3. Select “Excel” from data type dropdown list.
  4. Provide Description if required and then click on Ok Button. (File’s Information Window should appear)
  5. Select File Name which you want to use as test data by clicking on Browse Button
  6. By default “use first row as header” is checked. Don’t uncheck it.
  7. Now select the sheet name and then click on Save All.

Now in script define variable for e.g 

url = findTestData(“New Test Data”).getValue(“url”, 1)

in findTestData method pass the parameter name of Test Data which you have created by following step 1 to 7 and then provide column name and row number in getValue.

 

Below is the sample code to read input values from excel sheet and pass it to script.

 

This Article is TAGGED in , . BOOKMARK THE permalink.

6 thoughts on “Read data from excel sheet using Katalon Studio

Leave a Reply to Adrian Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">