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.

2.7K

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 Java Documentation of the Plug-in:

  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 ExcelKeywords-sources.jar to External location to attach the Javadoc.

  4. Now, you could see the JavaDoc of ExcelKeywords Plug-in while you are working with your test cases

Visit Katalon Forum for Plugin related discussions.

3.7
6 Rating(s)
Noor Yeaser Khan
November 9, 2019

It's a great plugin and I was able to work smoothly with it when I had KS 6.3.3. However, updating to KS7.0.8 isn't supporting setValueToCellByIndex of this plugin anymore. It's throwing this error: java.lang.NoSuchFieldError: CREATE_NULL_AS_BLANK Researching a bit revealed that POI version needs to be updated. Can someone tell me a way to have this error fixed please. Any prompt response will be highly appreciated!

hanan tab
July 17, 2019

Thank you !Plugin Works perfectly

Hiral Jogi
June 17, 2019

While this keyword is working fine for excel files with limited data, for reading huge amount of data, it is giving error as ' java.lang.OutOfMemoryError: GC overhead limit exceeded '. I have tried below suggested ways to solve it, however, none of it seems to work for my case: 1) https://forum.katalon.com/t/katalon-studio-memory-issue-adding-variables-for-data-driven-testing/13822/3 2) https://forum.katalon.com/t/upgrade-of-default-included-apache-poi-3-9-0-library-is-not-allowed/9110 Also, I can see there is a solution pending from Katalon team for the issue reported in point number 2. If that can be provided, I assume it can help resolve the 'OutOfMemoryError' exception that I am facing. A quick help would really be appreciated. Thank you, Hiral

Jose Melendez
June 15, 2019

I have couple days trying to install this plugin but it doesn't work, installed, reloaded the plugin, even restarted Katalon a Mac (just in case) but nothing, there's no way to see the jar in the project / settings / external libraries Could some one assist me on this?

Ronish Shrestha
October 18, 2019

i am also unable to find

KMS Technology
June 15, 2019

Hi @Jose Melendez, Could you try to follow the guidelines in the Overview page of this Excel Keywords plugin?https://store.katalon.com/product/34/Excel-Keywords#overview-content It has a link to download the sample test case for you to use the plugin : https://github.com/nhannguyenth/katalon-excel-keyword/tree/master/ExcelPluginSample/

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
June 5, 2019 3:54 am
Publisher
Privacy and License Agreement