java 单元格为空_如何使用java在空单元格上写？

我目前正在做一个Java程序，它将运行多个测试并在Excel中生成报告。我能够通过excel进行读写，并且“结果”列中显示“通过”或“失败”的结果。我能够在excel中编写这些代码，但是通过在单元格中提供默认值(例如默认值)，以便代码将其覆盖。我想写评论栏的评论，但我不知道如何写入空单元格。下面是我正在生成的报告(可用图像的链接)以及用于在Excel中读写的代码的屏幕截图。

FileInputStream fileInputStream = new FileInputStream("ReportExcel.xls");

HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);

HSSFSheet worksheet = workbook.getSheetAt(0);

fileInput csvInputFile = new fileInput();

String[] sReturnValue = csvInputFile.arrayReturnSingleValue("fileInput.csv");

if (prodnameresult.equals(prodname) ){

Pass++;

totalResult++;

System.out.println ("Testcase1: Branding-Customised Product Name is PASSED");

//Harold's Input

HSSFRow row = worksheet.getRow(1);

HSSFCell cell = row.getCell((short) 4);

cell.setCellValue("Passed");

}

else{

Fail++;

totalResult++;

System.out.println("Testcase1: Branding-Customised Product Name is FAILED");

//assertEquals(prodnameresult.equals(prodname), true);

//Harold's Input

HSSFRow row = worksheet.getRow(1);

HSSFCell cell = row.getCell((short) 4);

cell.setCellValue("Failed");

}

//Harold's Input

FileOutputStream os = new FileOutputStream("ReportExcel.xls");

workbook.write(os);

os.close();

}报告：

http://i47.tinypic.com/2s1lsfc.png