> 文章列表 > easyexcel特殊要求处理

easyexcel特殊要求处理

easyexcel特殊要求处理

easyexcel是在poi基础上开发的,那么我们就可以在easyexcel生成后,再给workbook、sheet创建样式,给个别单元格设置样式等操作。

理论来说可用,待测试。

    httpServletResponse.setContentType("application/vnd.ms-excel");httpServletResponse.setCharacterEncoding("utf-8");httpServletResponse.setHeader("Content-disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8") + ".xlsx");EasyExcel.write(httpServletResponse.getOutputStream(), exportVoClass).sheet("汇总").doWrite(voList);ExcelWriterSheetBuilder excelWriterSheetBuilder=new ExcelWriterSheetBuilder();WriteSheet writeSheet= excelWriterSheetBuilder.build();ExcelWriterBuilder excelWriterBuilder=EasyExcel.write(httpServletResponse.getOutputStream(), exportVoClass);ExcelWriter excelWriter=excelWriterBuilder.build();WriteContext writeContext=excelWriter.writeContext();WriteWorkbookHolder writeWorkbookHolder= writeContext.writeWorkbookHolder();Workbook workbook= writeWorkbookHolder.getWorkbook();Sheet sheet = workbook.getSheetAt(0);sheet.getWorkbook().createCellStyle();CellStyle cellStyle = sheet.getWorkbook().createCellStyle();Row row=sheet.getRow(0);//            CellRangeAddress region = new CellRangeAddress(firstRow, lastRow, firstCol, lastCol); //初始行,终止行,初始列,终止列
//            sheet.addMergedRegion(region);