| | |
|---|
| | | ClassPathResource classPathResource = new ClassPathResource("template/销售数据列表.xls"); |
|---|
| | | TemplateExportParams params = new TemplateExportParams(classPathResource.getPath()); |
|---|
| | | Workbook workbook = ExcelExportUtil.exportExcel(params, result); |
|---|
| | | |
|---|
| | | Sheet firstSheet = workbook.getSheetAt(0); |
|---|
| | | // List<CellRangeAddress> mergedRegions = firstSheet.getMergedRegions(); |
|---|
| | | // List<Integer> removeMergedRegionIndexList = new ArrayList<>(); |
|---|
| | | // 处理数据不显示 |
|---|
| | | // for (int i = 0; i < mergedRegions.size(); i++) { |
|---|
| | | // CellRangeAddress mergedRegion = mergedRegions.get(i); |
|---|
| | | // int firstColumn = mergedRegion.getFirstColumn(); |
|---|
| | | // int lastColumn = mergedRegion.getLastColumn(); |
|---|
| | | // int firstRow = mergedRegion.getFirstRow(); |
|---|
| | | // if(firstRow >= 2 && firstColumn >= 3 && lastColumn <= 5){ |
|---|
| | | // removeMergedRegionIndexList.add(i); |
|---|
| | | // } |
|---|
| | | // } |
|---|
| | | // firstSheet.removeMergedRegions(removeMergedRegionIndexList); |
|---|
| | | |
|---|
| | | HttpServletResponse response = WebUtils.response(); |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | | response.setCharacterEncoding("utf-8"); |
|---|
