生成Excel部分
XSSFWorkbook workbook = XSSFWorkbookFactory.createWorkbook(); //创建Excel表
XSSFSheet sheet = workbook.createSheet("Sheet名"); //创建sheet
//设置第一行标题行的宽度
sheet.setColumnWidth(1, 252 * 15 + 600);
sheet.setColumnWidth(2,252 * 30 + 323);
sheet.setColumnWidth(3, 252 * 30 + 323);
sheet.setColumnWidth(4, 252 * 50 + 323);
sheet.setColumnWidth(5, 252 * 15 + 323);
sheet.setColumnWidth(6, 252 * 17 + 650);
sheet.setColumnWidth(7, 252 * 16 + 323);
//固定第一行的标题内容
XSSFRow row = sheet.createRow(0);
row.createCell(0).setCellValue("001");
row.createCell(1).setCellValue("002");
row.createCell(2).setCellValue("003");
row.createCell(3).setCellValue("004");
row.createCell(4).setCellValue("005");
row.createCell(5).setCellValue("006");
row.createCell(6).setCellValue("007");
保存Excel到服务器的固定路径中
String projectName=projectDao.findById(projectId).get().getName();
String date = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyyMMddHHmmss"));
String fileName=projectName+addFileName+date+".xlsx";
String path="/static/excel/";
String Dir = request.getServletContext().getRealPath(path);
//判断文件夹是否存在
File parent = new File(Dir);
if (!parent.exists()) {
parent.mkdirs();
}
File file=new File(Dir,fileName);
OutputStream os=new FileOutputStream(file);
workbook.write(os);
os.flush();
os.close();