##前端HTML页面：

<div class="col-lg-1 mb" style="text-align:center"><button class="btn btn-oval btn-danger" type="button" (click)="export()" >导出</button>
</div>

 

## 前端js:

 前端js方法：

public export() {const params = {appId:this.appId};this.http.download('/user/app/order/export',params).subscribe(res => {const blob = new Blob([res], {type: 'application/vnd.ms-excel'});// const fileName = res.headers().filename;const fileName = '支付交易记录' + '.xlsx';if (window.navigator.msSaveOrOpenBlob) {// For IE浏览器
　　　　　　　　navigator.msSaveBlob(blob, fileName);} else { // For 其他浏览器const objectUrl = URL.createObjectURL(blob);const a = document.createElement('a');document.body.appendChild(a);a.setAttribute('style', 'display:none');a.setAttribute('href', objectUrl);a.setAttribute('download', fileName);a.click();URL.revokeObjectURL(objectUrl);}});}
}

 http.download代码封装

 public download(url:string, params?: any): Observable<any> {
        url = HOST + url;
        const headers = new HttpHeaders().set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
        const responseType ='blob';
        let httpParams: HttpParams = new HttpParams();
        if (params) {
            for (const p in params) {
                if (params[p]) {
                    httpParams = httpParams.set(p, params[p]);
                }
            }
        }
        return this.http.get( url,{ 'headers': headers,'responseType': responseType,'params':httpParams })
        .map(res =>{
            return res
        });
    }

 

## java后台:

/**
     * 导出excel
     */
    public void export(){
        //获取查询条件
        String appId = getPara("appId");
        //判空校验
        if(StrKit.isBlank(appId)){
            renderJson(RMsg.fail("参数不存在"));
            return;
        }
        //查询数据
        List<TblTransferRecord> list = TblTransferRecord.me.find(
                "SELECT " +
                "a.*, b. NAME, " +
                "CASE transferState " +
                "WHEN 1 THEN " +
                "'待转账' " +
                "WHEN 2 THEN " +
                "'转账处理中' " +
                "WHEN 3 THEN " +
                "'转账失败' " +
                "WHEN 4 THEN " +
                "'已退款' " +
                "ELSE " +
                "'成功' " +
                "END AS transferState " +
                "FROM " +
                "TblTransferRecord a " +
                "LEFT JOIN MstTransferMethod b ON a.transferCode = b. CODE " +
                "WHERE " +
                "appId = ? " +
                "ORDER BY " +
                " a.updateTime DESC ",appId);
        //判空
        if(list == null || list.size() <  0){
            renderText("暂无记录");
            return;
        }

        //获取上传地址
        String uploadFolder = PropKit.get(ConstValue.UPLOAD_FILE_PATH).replace('/', File.separatorChar).replace('\\',File.separatorChar);
        //获取文件路径
        String filePath = uploadFolder + File.separator + System.currentTimeMillis() + FILE_EXTENSION;

        //创建目录
        File dir = new File(filePath);

        if(!dir.getParentFile().exists()){
            dir.getParentFile().mkdirs();
        }

        createExcel(filePath,list);

        File file = new File(filePath);

        if (file == null || !file.exists()) {
            renderText("对不起,您所要下载的文件不存在！");
        } else {
            renderDownloadFile(file, "退款记录.xlsx");
        }
    }

##excel样式：

private static CellStyle getCenterCellStyle(Workbook wb) {
    CellStyle cellStyle = wb.createCellStyle();
    cellStyle.setAlignment(CellStyle.ALIGN_CENTER);
    cellStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);

    cellStyle.setBorderLeft(CellStyle.BORDER_THIN);
    cellStyle.setBorderTop(CellStyle.BORDER_THIN);
    cellStyle.setBorderRight(CellStyle.BORDER_THIN);
    cellStyle.setBorderBottom(CellStyle.BORDER_THIN);
    cellStyle.setLeftBorderColor(IndexedColors.BLACK.getIndex());
    cellStyle.setTopBorderColor(IndexedColors.BLACK.getIndex());
    cellStyle.setRightBorderColor(IndexedColors.BLACK.getIndex());
    cellStyle.setBottomBorderColor(IndexedColors.BLACK.getIndex());

    return cellStyle;
}

/**
 * 设置自定义的颜色
 *
 * @param cellStyle
 */
private static void setCustomColor(XSSFCellStyle cellStyle) {
    cellStyle.setFillForegroundColor(new XSSFColor(new java.awt.Color(0xf3, 0xf3, 0xf3)));
    cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
}

/**
 * 设置白色
 *
 * @param cellStyle
 */
private static void setWhiteColor(XSSFCellStyle cellStyle) {
    cellStyle.setFillForegroundColor(IndexedColors.WHITE.getIndex());
    cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
}

##创建excel:方法1

/**
     * 生成excel表格
     * @param filePath
     * @param list
     * @author tgb
     */
    private static void createExcel(String filePath, List<TblTransferRecord> list) {

        //创建工作簿
        Workbook wb = new XSSFWorkbook();
        //创建工作表
        Sheet sheet = wb.createSheet("转账记录");
        //创建一行
        Row row = sheet.createRow(0);
        //创建列
        for(int i = 0;i < 8; ++i){
            row.createCell(i);
        }

        //设置单元格的宽高
        sheet.setColumnWidth(0, 35 * 200);
        sheet.setColumnWidth(1, 35 * 200);
        sheet.setColumnWidth(2, 35 * 200);
        sheet.setColumnWidth(3, 35 * 200);
        sheet.setColumnWidth(4, 35 * 200);
        sheet.setColumnWidth(5, 35 * 200);
        sheet.setColumnWidth(6, 35 * 200);
        sheet.setColumnWidth(7, 35 * 200);
        //去掉网格线
        sheet.setDisplayGridlines(false);

        //合并标题单元格
        sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 7));
        //标题
        row.getCell(0).setCellValue("转账记录");
        //行高
        row.setHeightInPoints(30);
        //获取工作薄样式
        CellStyle cellStyle = getCenterCellStyle(wb);
        //设置标题单元格的颜色
        cellStyle.setFillForegroundColor(IndexedColors.ORANGE.getIndex());
        //设置标题单元格的填充模式
        cellStyle.setFillPattern(CellStyle.SOLID_FOREGROUND);
        row.getCell(0).setCellStyle(cellStyle);

        //换行
        row = sheet.createRow(1);

        cellStyle = getCenterCellStyle(wb);
        row.createCell(0).setCellValue("批次号");
        row.createCell(1).setCellValue("卡号");
        row.createCell(2).setCellValue("银行");
        row.createCell(3).setCellValue("收款人");
        row.createCell(4).setCellValue("金额");
        row.createCell(5).setCellValue("转账方式");
        row.createCell(6).setCellValue("状态");
        row.createCell(7).setCellValue("创建时间");

        row.getCell(0).setCellStyle(cellStyle);
        row.getCell(1).setCellStyle(cellStyle);
        row.getCell(2).setCellStyle(cellStyle);
        row.getCell(3).setCellStyle(cellStyle);
        row.getCell(4).setCellStyle(cellStyle);
        row.getCell(5).setCellStyle(cellStyle);
        row.getCell(6).setCellStyle(cellStyle);
        row.getCell(7).setCellStyle(cellStyle);

        if (list != null && list.size() > 0) {
            for (int i = 0; i < list.size(); ++i) {
                row = sheet.createRow(i + 2);
                TblTransferRecord record = list.get(i);

                row.createCell(0).setCellValue(record.getStr("batchNo")); //批次号
                row.createCell(1).setCellValue(record.getStr("cardNo"));  //卡号
                row.createCell(2).setCellValue(record.getStr("bankName"));//银行
                row.createCell(3).setCellValue(record.getStr("cardHolder"));//收款人
                row.createCell(4).setCellValue(record.getStr("amount"));//金额
                row.createCell(5).setCellValue(record.getStr("transferCode"));//转账方式
                row.createCell(6).setCellValue(record.getStr("transferState"));//状态
                row.createCell(7).setCellValue(record.getStr("createTime")); //创建时间

                cellStyle = getCenterCellStyle(wb);

                if (i % 2 == 0) {
                    setCustomColor((XSSFCellStyle) cellStyle);
                } else {
                    setWhiteColor((XSSFCellStyle) cellStyle);
                }

                row.getCell(0).setCellStyle(cellStyle);
                row.getCell(1).setCellStyle(cellStyle);
                row.getCell(2).setCellStyle(cellStyle);
                row.getCell(3).setCellStyle(cellStyle);
                row.getCell(4).setCellStyle(cellStyle);
                row.getCell(5).setCellStyle(cellStyle);
                row.getCell(6).setCellStyle(cellStyle);
                row.getCell(7).setCellStyle(cellStyle);
            }
        }

        FileOutputStream fileOut = null;

        try {
            File file = new File(filePath);

            if (file.isFile() && !file.exists()) {
                file.createNewFile();
            }
            fileOut = new FileOutputStream(filePath);
            wb.write(fileOut);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            try {
                if(fileOut != null) {
                    fileOut.close();
                }
            } catch (IOException e) {
                e.printStackTrace();
            }
        }

    }

 ##createExcel 方法2：