2021-08-06

InputStream stream = new FileInputStream("C:\\Users\\aa\\Downloads\\demoExcel.xlsx");
OPCPackage open = OPCPackage.open(stream);
XSSFWorkbook sheets = new XSSFWorkbook(open);
XSSFSheet sheet = sheets.getSheetAt(0);
sheet.getRow(0).createCell(3).setCellValue("sum");
sheet.getRow(1).createCell(3).setCellValue("11");
sheet.getRow(2).createCell(3).setCellValue("22");
sheet.getRow(3).createCell(3).setCellValue("33");
OutputStream out = new FileOutputStream("C:\\Users\\aa\\Downloads\\test.xlsx");
sheet.getWorkbook().write(out);

写入后的excel

思路大致如上，可自行对其进行优化