Excel Keywords FREE

This plug-in makes writing automation tests using excel files (.xls and .xlsx) much easier by reading, writing, and comparing Excel files.

728

This plug-in makes writing automation tests using excel files (.xls and .xlsx) much easier by reading, writing, and comparing Excel files.

Some key features of this plug-in are:

  • Create an excel file with the provided file path
  • Get an instance of a workbook object from an excel file
  • Create one or many excel sheets in a workbook
  • Generate a list of the sheet names in a workbook
  • Read the value of one or many of the cells within a sheet
  • Write value into one or many of the cells in a sheet
  • Save a workbook into an excel file
  • Compare two excel files, two sheets, two rows, or two cells
  • Supported Excel file types: .xlsx and .xls (from Excel versions 97/2000/XP/2003). It does not work with Excel versions 5.0/95.

Katalon Studio version supported: v6.0.5 or later To make things easier, we have included a sample with test cases using the plug-in. Download it here.

Follow the steps below to install and begin using the plug-in.

Installing The Plug-in

  1. Create/Open Katalon project (Katalon Studio version v6.0.5 or later)

  2. Select Project > Settings > External Libraries

  3. Add ExcelKeywords.jar, then click OK.

  4. On the test case file, import com.kms.katalon.keyword.excel.ExcelKeywords. You can now use the plug-in.

To import sample test cases:

  1. Hover on import com.kms.katalon.keyword.excel.ExcelKeywords, right click, then select Open Declaration.

  2. Select *Attach Source * on Class File Editor page.

  3. Add ExcelKeywordssources.jar to External location to attach the Javadoc.

  4. Import the JavaDoc of sample test cases.

Visit Katalon Forum for Plugin related discussions.

4.5
2 Rating(s)
Tester Pegasus
April 13, 2019

Should be interesting see a video showing with examples how to implement this CKs

KMS Technology
April 8, 2019

Hello Pegasus, In the Overview page, we give many examples of using this custom keyword in the Katalon project on GitHub with the following URL https://github.com/nhannguyenth/katalon-excel-keyword/tree/master/ExcelPluginSample/ Hope you could download it and follow the instruction in the README file to enjoy the sample of using this keyword to work with Excel files.

Tina
April 12, 2019

API keys are required in Katalon Studio Commandline Execution. Generate Key
Information
Project details
Version
1.0.1
Type
Custom Keywords Plugin
Last updated
May 16, 2019 10:56 am
Publisher
Privacy and License Agreement