This is a companion discussion topic for the original entry at https://store.katalon.com/product/34#qa-content

where i can find a video on how to implement this? Thanks.

Hello pgonzalez , Instead of a video, in the Overview page, we give many examples of using this custom keyword in the Katalon project on GitHub with the following URL ExcelPluginSample Hope you could download it and follow the instruction in the README file to enjoy the sample of using this keywor…

Hey its working now, thank you :smiley: [image]

Im trying to implement this in a test suite, CustomKeywords.‘com.kms.katalon.keyword.excel.ExcelKeywords.setValueToCellByIndex’(sheet01, RowVar, 0, TextOne) In every iteration i want to write into (RowVar, 0) but How do i implement this to not create the File.xlsx every time.

Hi pgonzalez, You could open an existing excel file once. Then update into that file on many cells as your expectation. Then you save the workbook once after you completed the update. Finally, you could open that existing file to check the result. Below is an example of scripts. Enjoy test script…

How do I download ExcelKeywords.jar to install in an offline environment? I can’t see a download link anywhere on this site or in github. Thanks in advance for the help.

Hello Brandon-Hinds, In the Overview page of this plugin, you could find the URL to download a sample katalon project with test cases using the plug-in. The ExcelKeywords.jar file is under the Drivers sub-folder. Thanks, Nhan Nguyen Thi Hanh

Can we have the same implementation for CSV as well. It would be great

Hi I can not open newest excel version “.xls”. I try to change the XSSF for HSSFWorkbook but the result it’s the same. java.io.IOException: block[ 2 ] already removed - does your POIFS have circular or duplicate block references? Regards

It is a good idea, Tony. We will consider about this option to create a new keyword for it.

Read Write Excel Custom Keywords

Miscellaneous

pgonzalez April 13, 2019, 1:03pm 4

Hey its working now, thank you

1 Like

Topic		Replies	Views
Write data into Excel file at runtime during test execution Miscellaneous new-doc-request	29	8324	July 3, 2020
Write into excel at runtime during test execution Feature Request katalon-studio , feature-request	26	13732	February 28, 2020
Posibble to store all data under one excel sheet? API Testing katalon-studio , api-testing	22	2331	February 6, 2020
Katalon writing data to excel Web Testing katalon-studio	41	11197	February 10, 2022
Can Read the data from Excel But Cannot able to write the data in Same Excel Web Testing katalon-studio	29	4326	March 19, 2019

Read Write Excel Custom Keywords

Related topics