使用XSSFWorkbook写入excel无效
-----------原代码---------
InputStream inputStream = Files.newInputStream(Paths.get("C:\\Users\\SQT\\Desktop\\2023.07DRG数据(原始).xlsx"));
xssfWorkbook = new XSSFWorkbook(inputStream);
//通过索引获取工作表中的第一个sheet页 索引是0
XSSFSheet sheet = xssfWorkbook.getSheetAt(0);
Row row = sheet.getRow(1);
System.out.println(row.getCell(1).getStringCellValue());
//System.out.println(row);
//row.createCell(43).setCellValue(CTPCPDesc);//医生
if(row == null){
row = sheet.createRow(1);
}
Cell cell1 = row.getCell(42);
if(cell1 == null){
cell1 = row.createCell(42);
}
cell1.setCellValue("acbcccc");//科室CTLOCCode
inputStream.close();
xssfWorkbook.close();
-----------修改后代码---------
InputStream inputStream = Files.newInputStream(Paths.get("C:\\Users\\SQT\\Desktop\\ces.xlsx"));
xssfWorkbook = new XSSFWorkbook(inputStream);
//通过索引获取工作表中的第一个sheet页 索引是0
XSSFSheet sheet = xssfWorkbook.getSheetAt(0);
Row row = sheet.getRow(1);
System.out.println(row.getCell(1).getStringCellValue());
//System.out.println(row);
//row.createCell(43).setCellValue(CTPCPDesc);//医生
if(row == null){
row = sheet.createRow(1);
}
Cell cell1 = row.getCell(2);
if(cell1 == null){
cell1 = row.createCell(2);
}
cell1.setCellValue("acbcccc");//科室CTLOCCode
FileOutputStream outputStream = new FileOutputStream("C:\\Users\\SQT\\Desktop\\ces.xlsx");
xssfWorkbook.write(outputStream);
inputStream.close();
outputStream.close();
xssfWorkbook.close();