I found nullPointerException during writing data in Excel using same code as java selenium.. i.e java.lang.NullPointerException: Cannot invoke method createCell() on null object I found some solution like during writing data in excel we need to put data in that cell in which we creating cell then …

This code is suitable to write data into xlsx file. _ String excelFileName = “C:\\results.xls”;_ _ File src = new File(excelFileName);_ _ FileInputStream fis = new FileInputStream(src);_ _ HSSFWorkbook wb = new HSSFWorkbook(fis);_ _ HSSFSheet sheet = wb.getSheetAt(0);_ _ HSSFRow row = sh…

plaidshirtakos said: This code is suitable to write data into xlsx file. _ String excelFileName = “C:\\results.xls”;_ _ File src = new File(excelFileName);_ _ FileInputStream fis = new FileInputStream(src);_ _ HSSFWorkbook wb = new HSSFWorkbook(fis);_ _ HSSFSheet sheet = wb.getSheetAt(0)…

Why would you like to create new keyword? You can simply put that code to your test case.

I have made another post: [image] Multiple Test Cases in a Test Suite can share a Excel file to read/write data dynamically Web Testing I have made a demo project on GitHub: GitHub - kazurayam/MultipleTestCasesSafelyWriteIntoExcelFile: [Katalon Studio] W…

Hi, one way to write to excel :slight_smile: TESTCASE List excel = new ArrayList (); excel.add(“First”); excel.add(“Second”); excel.add(“Third”); excel.add(“Fourth”); excel.add(“Fifth”); excel.add(""); CustomKeywords.‘spreadsheet.WriteToFile.writeToExcel’(excel, 1) KEYWORD import org.ap…

Writing Data In Excel

Web Testing

kazurayam September 1, 2018, 11:14pm 5

I have made another post:

I hope this may help.

Topic		Replies	Views
java.lang.NullPointerException: Cannot invoke method getCell() on null object Web Testing katalon-studio	8	18337	August 8, 2022
Write into excel at runtime during test execution Feature Request katalon-studio , feature-request	26	13745	February 28, 2020
Issue while writing value to Excel File Web Testing katalon-studio , web-testing	2	1076	January 29, 2019
Unable to write data into an excel file Integrations integrations , katalon-studio	5	5021	October 1, 2018
Write in excel using katalon studio Web Testing katalon-studio , web-testing	5	1132	August 8, 2022

Writing Data In Excel

Related topics