FileNotFoundException

[Andreas_Voit]

I didn’t tested your example, but I think you should also close the file?

file.close();

I found an example:

@Keyword
def void writeToExcel(String text ){
	FileInputStream file = new FileInputStream (new File("D:\\Testdata.xlsx"))
	XSSFWorkbook workbook = new XSSFWorkbook(file);
	XSSFSheet sheet = workbook.getSheetAt(0);
	Cell searchText = sheet.getRow(1).getCell(1);
	searchText.setCellValue(text);
	file.close();
	FileOutputStream outFile =new FileOutputStream(new File("D:\\Testdata.xlsx"));
	workbook.write(outFile);
	outFile.close();
}

Source: Write into excel at runtime during test execution - #6 by nhi

Theres also an example for your usecase:

Write into excel at runtime during test execution

Melinda Lakner said: I would like to get different texts and write them into excel into different cells, but now only the last appears not all. I don’t know why. I needed to write data to excel. I created Custom Keyword for that. Under Keywords right click and select NEW -> PACKAGE. Name it writeToExcel (or however you want) After that right click your package and select NEW -> KEYWORD. Name it WriteExcel (or however you want). Inside your new keyword add this code (my code has package …