若依框架下自定义字段集合类报表的导出功能

1.前端查询条件显示：



<el-input
style=“width: 100px;”
type=“number”
v-model=“queryCondition[item.fieldName][0]”
placeholder=“最小值”
@change=“getMaxName(item.fieldName)”
>
-
<el-input
style=“width: 100px;”
type=“number”
v-model=“queryCondition[item.fieldName][1]”
placeholder=“最大值”
@change=“getMaxName(item.fieldName)”
>






<el-button v-if=“queryList.length” type=“primary” @click=“onSubmit”>查询
<el-button v-if=“queryList.length” type=“primary” @click=“exportExcel”>导出

2.前端添加方法,使用post请求，将自定义字段封装为对象进行传递
async exportExcel() {
// 最大值 最小值必须都填写
if (this.maxName && this.queryCondition[this.maxName] && this.queryCondition[this.maxName].length) {
if (this.queryCondition[this.maxName].length !== 2) {
this.KaTeX parse error: Expected 'EOF', got '}' at position 61: …eturn; }̲ } …http.post(“/report/exportExcel”, this.queryCondition);
if (res.code === 200) {
fileExport.name(res.msg);
} else {
this.$message.error(res.msg);
}
}

3.在后端Controller添加导出方法，根据接收到的对象信息，查询报表内容
@RequestMapping(“/exportExcel”)
public AjaxResult exportExcel(@RequestBody JSONObject jsonObject, HttpServletResponse response) throws IOException {
OutputStream ouputStream = null;
String fileName = “报表详情列表”;
try {
List<LinkedHashMap<Object, Object>> detailList = reportCenterService.getDetail(jsonObject);
if(CollectionUtil.isNotEmpty(detailList)){
try {
//获取报表详情的表头
LinkedHashMap<Object, Object> map = detailList.get(0);
List kyList = map.keySet().stream().collect(Collectors.toList());
fileName = UUID.randomUUID().toString() + “_报表详情列表.xlsx”;
response.setHeader(“Content-disposition”, “attachment; filename=”
+ new String(fileName.getBytes(“utf-8”), “ISO8859-1”));//设置下载的文件名
SXSSFWorkbook wb = new SXSSFWorkbook();
exportDetail(kyList, detailList, wb, 0);
String downloadPath = DihugeConfig.getDownloadPath() + fileName;
File desc = new File(downloadPath);
if (!desc.getParentFile().exists())
{
desc.getParentFile().mkdirs();
}
ouputStream = new FileOutputStream(downloadPath);
wb.write(ouputStream);
ouputStream.flush();
ouputStream.close();
} catch (Exception e) {
ouputStream.close();
throw e;
}
}
} catch (Exception e) {
logger.debug(“报表详情导出异常” + e.getMessage());
}
return AjaxResult.success(fileName);
}

4.报表内容的自定义方法解析
private SXSSFWorkbook exportDetail(List kyList, List<LinkedHashMap<Object, Object>> detailList, SXSSFWorkbook workbook, int index) {
Sheet sheet = workbook.createSheet();
workbook.setSheetName(index, “报表详情列表”);

    // 生成一个样式
    CellStyle style1 = workbook.createCellStyle();
    // 设置背景色
    style1.setFillForegroundColor(IndexedColors.LIGHT_TURQUOISE.getIndex());
    style1.setFillPattern(FillPatternType.SOLID_FOREGROUND);

    //设置边框
    style1.setBorderBottom(BorderStyle.THIN);
    style1.setBorderLeft(BorderStyle.THIN);
    style1.setBorderRight(BorderStyle.THIN);
    style1.setBorderTop(BorderStyle.THIN);
    style1.setAlignment(HorizontalAlignment.CENTER);

    // 设置字体
    Font font1 = workbook.createFont();
    font1.setFontName("仿宋_GB2312");
    font1.setColor(IndexedColors.OLIVE_GREEN.index);
    font1.setFontHeightInPoints((short) 14);
    // 把字体应用到当前的样式
    style1.setFont(font1);
    for(int i =0; i < kyList.size(); i++){
        sheet.setColumnWidth(i, 12000);
    }

    //生成一行
    Row row2 = sheet.createRow(0);
    Cell cell1;
    for (int k = 0; k < kyList.size(); k++) {
        cell1 = row2.createCell(k);
        cell1.setCellValue(String.valueOf(kyList.get(k)));
        cell1.setCellStyle(style1);
    }

    sheet = workbook.getSheetAt(index);
    // 生成一个样式
    CellStyle style3 = workbook.createCellStyle();

    //设置边框
    style3.setBorderBottom(BorderStyle.THIN);
    style3.setBorderLeft(BorderStyle.THIN);
    style3.setBorderRight(BorderStyle.THIN);
    style3.setBorderTop(BorderStyle.THIN);
    style3.setAlignment(HorizontalAlignment.CENTER);
    style3.setVerticalAlignment(VerticalAlignment.CENTER);//垂直居中

    Font font3 = workbook.createFont();
    font3.setFontName("仿宋_GB2312");
    font3.setColor(IndexedColors.BLACK.index);
    font3.setFontHeightInPoints((short) 10);
    font3.setBold(true);
    // 把字体应用到当前的样式
    style3.setFont(font3);
    style3.setWrapText(true);

    Row row3;
    Cell cell3;
    for (int i = 0; i < detailList.size(); i++) {
        LinkedHashMap<Object, Object> detailMap = detailList.get(i);
        row3 = sheet.createRow(i+1);

        for (int k = 0; k < kyList.size(); k++) {
            for (Object key : detailMap.keySet()) {
                if (String.valueOf(kyList.get(k)).equals(String.valueOf(key))) {
                    cell3 = row3.createCell(k);
                    if(ObjectUtil.isNotEmpty(detailMap.get(key))){
                        cell3.setCellValue(String.valueOf(detailMap.get(key)));
                    }else {
                        cell3.setCellValue("");
                    }
                    cell3.setCellStyle(style3);
                }
            }
        }
    }
    return workbook;
}