poi导出excel

1、pom.xml文件中添加依赖

<!--EasyPOI--><dependency>    <groupId>org.jeecg</groupId>    <artifactId>easypoi-base</artifactId>    <version>2.3.0.2</version>    <exclusions>        <exclusion>            <groupId>javax.validation</groupId>            <artifactId>validation-api</artifactId>        </exclusion>    </exclusions></dependency><dependency>    <groupId>org.jeecg</groupId>    <artifactId>easypoi-web</artifactId>    <version>2.3.0.2</version></dependency><dependency>    <groupId>org.jeecg</groupId>    <artifactId>easypoi-annotation</artifactId>    <version>2.3.0.2</version></dependency><!--EasyPOI 校验,下面两个实现 --><dependency>    <groupId>org.hibernate</groupId>    <artifactId>hibernate-validator</artifactId>    <version>5.1.3.Final</version>    <optional>true</optional></dependency><dependency>    <groupId>org.apache.bval</groupId>    <artifactId>org.apache.bval.bundle</artifactId>    <version>1.1.0</version></dependency>

2、实体类（用到了注解）

import lombok.Data;import org.jeecgframework.poi.excel.annotation.Excel;import org.jeecgframework.poi.excel.annotation.ExcelCollection;import java.math.BigDecimal;import java.util.Date;import java.util.List;/** * @author   Yanli Yang */@Datapublic class StatementAccountDetails{    /**     *     */    private Long id;    /**     * 订单id     */    private Long orderId;    /**     * 订单编号     */    @Excel(name = "Order No.")    private String orderNo;    /**     * 实收     */    @Excel(name = "Amount Received(RM)")    private BigDecimal paidInAmount;    /**     * 卖家SKU     */    @Excel(name = "SellerID")    private String sellerSku;    /**     * 平台SKU   这个字段不要了     */    private String platformSku;    /**     * 交易时间     */    @Excel(name = "Order Time")    private Date tradingTime;    /**     * 第三方支付手续费     */    @Excel(name = "Third Party Payment Handling Fee")    private BigDecimal poundage;    /**     * 运费     */    @Excel(name = "Shipping")    private BigDecimal freight;    /**     * 对账单id     */    @Excel(name = "Reconciliation Order No.")    private Long statementOfAccountId;    /**     * 手续费的税费     */    @Excel(name = "Tax for handling fee")    private BigDecimal poundageTaxes;    /**     * 运费的税费     */    @Excel(name = "Tax for shipping")    private BigDecimal freightTaxes;    /**     * 订单金额     */    @Excel(name = "Order Amount")    private BigDecimal orderAmount;    @ExcelCollection(name = "GoodsDetails", orderNum = "6")    private List<StatementAccountGoods> statementAccountGoodsList;}

3、查询数据，并调用导出的方法

@RequestMapping("exportExcel")public void exportExcel(HttpServletResponse response,String statementAccountId){    Integer accountId = null;    if(StringUtils.isNotEmpty(statementAccountId)){        accountId = Integer.parseInt(statementAccountId);    }    List<StatementAccountDetails> accountList = this.statementAccountService.getExportAccountDetailsList(accountId);    if (accountList != null && accountList.size() > 0){        for (StatementAccountDetails statementAccountDetails : accountList) {            List<StatementAccountGoods> statementAccountGoodses = this.statementAccountService.getExportAccountGoodsList(statementAccountDetails.getOrderId());            statementAccountDetails.setStatementAccountGoodsList(statementAccountGoodses);        }    }    ExportParams exportParams = new ExportParams();    exportParams.setTitle("Reconciliation Details");    exportParams.setSheetName("Reconciliation Details");    Workbook workbook = ExcelExportUtil.exportExcel(exportParams,StatementAccountDetails.class,accountList);    try {        ResponseUtils.writeExcel(response,workbook,"ReconciliationDetails.xls");    } catch (IOException e) {        log.error("对账单明细导出Excel错误",e);    }}

4、工具类

import javax.servlet.http.HttpServletResponse;import java.io.BufferedOutputStream;import java.io.IOException;import java.io.OutputStream;/** * HttpServletResponse 相关的工具类 * * @author songjunjie */public class ResponseUtils {    /**     * 将excel数据写到HttpServletResponse中，浏览器将提示下载文件。默认的编码格式为UTF-8     *     * @param response     * @param data 数据     * @param filename 浏览器下载文件时，显示的文件名字     * @throws IOException     */    public static void writeExcel(HttpServletResponse response, byte[] data , String filename) throws IOException {//        ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();//        workbook.write(byteArrayOutputStream);//        byte[] bytes = byteArrayOutputStream.toByteArray();        // 清空response        response.reset();        // 设置response的Header        response.setContentType(HttpContentTypes.XLS + ";charset=utf-8");        response.addHeader("Content-Disposition", "attachment;filename=" + new String(filename.getBytes("utf-8"), "iso8859-1"));        response.addHeader("Content-Length", "" + data.length);        OutputStream outputStream = new BufferedOutputStream(response.getOutputStream());        outputStream.write(data);        outputStream.flush();        outputStream.close();    }}

5、前端页面调用 要使用window.location.href 不能使用ajax调用

window.location.href = basePath+"/appointmentCtr/exportData?patientId="+appointment.patientId;