1,引入所用的包
org.apache.poi
poi-ooxml
3.5-FINAL
2,创建列名List,此处将显示到单元格每列名称,根据自己的业务需求更改列名
List columnList = newArrayList();
columnList.add("申请人账号");
columnList.add("申请人");
columnList.add("提现金额");columnList.add("开户行");
columnList.add("持卡人");
columnList.add("卡号");
columnList.add("银行名称");
columnList.add("申请时间");
3,创建将要导出的参数(实体类),此处必须和创建的列名List一一对应,否则会错行显示
packagecom.sanmi.active.fission.management.balance.dto;importlombok.Data;importjava.math.BigDecimal;importjava.sql.Timestamp;/***@author:Ziggo Xu
*
提现管理导出参数
* ===============================
* Date:2018/12/12
* Time:16:55
* ================================*/@Datapublic classUserBalanceCashExcelDTO {/*** 申请人账户*/
privateString account;/*** 申请人*/
privateString nickName;/*** 提现金额*/
privateBigDecimal bcCashMoney;/*** 开户行名称*/
privateString ubiOpenBank;/*** 持卡人姓名*/
privateString ubiRealName;/*** 银行卡卡号*/
privateString ubiCardNo;/*** 银行卡名称*/
privateString ubiBankName;/*** 提现时间*/
privateTimestamp bcCreateTime;
}
4,创建导出Excel的工具类
packagecom.sanmi.active.fission.base.util;importorg.apache.poi.xssf.usermodel.XSSFRow;importorg.apache.poi.xssf.usermodel.XSSFSheet;importorg.apache.poi.xssf.usermodel.XSSFWorkbook;importjavax.servlet.http.HttpServletResponse;importjava.io.IOException;importjava.lang.