使用apache poi修改现有excel

Question

当我修改服务器中现有的excel文件并复制到本地计算机并打开它时，我发现excel无法打开，因为某些内容不可读，是否要打开并修复此工作簿

File f = new File(directory+"users.xlsx");
FileInputStream fileInputStream = new FileInputStream(f);

workbook = new XSSFWorkbook(fileInputStream);
sheet = workbook.getSheetAt(0);
Row row = sheet.getRow(4);
for(int i = 0; i<5; i++)
{
Cell cell = row1.getCell(i);
cell.setCellValue(formattedDate);
cell.setCellStyle(normalStyle);
}

 FileOutputStream out = new FileOutputStream(f, false);
               workbook.write(out);
               out.close();

已经努力解决了8个小时，但运气不好。如果有人能解释一下，我会很感激的。

Answer 1

将输出移到另一个文件，不要忘记关闭输入和输出并使用此选项http://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/WorkbookFactory.html

File f = new File(directory+"users.xlsx");

FileInputStream fileInputStream = new FileInputStream(f);

Workbook workbook = WorkbookFactory.create(fileInputStream);
fileInputStream.close();
sheet = workbook.getSheetAt(0);
Row row = sheet.getRow(4);
for(int i = 0; i<5; i++)
{
Cell cell = row1.getCell(i);
cell.setCellValue(formattedDate);
cell.setCellStyle(normalStyle);
}

 FileOutputStream out = new FileOutputStream(f, false);
               workbook.write(out);
               out.close();