SpringBoot集成easypoi实现execl导出

 <!--easypoi依赖，excel导入导出--><dependency><groupId>cn.afterturn</groupId><artifactId>easypoi-spring-boot-starter</artifactId><version>4.4.0</version></dependency>

通过@Exce注解设置标头名字和单元格宽度；
导出实体设置:

@Data
public class ExportOrder implements Serializable {/*** 订单号*/@Excel(name = "订单号", width = 10.0)private String orderId;/*** 产品名称*/@Excel(name = "产品名称", width = 10.0)private String productName;/*** 品牌*/@Excel(name = "品牌", width = 10.0)private String brandName;/*** 分类*/@Excel(name = "分类", width = 10.0)private String type;/*** 数量*/@Excel(name = "数量", width = 10.0)private Long orderNumber;/*** 付款时间*/@Excel(name = "付款时间", width = 10.0)private String payTime;/*** 付款金额*/@Excel(name = "付款金额", width = 10.0)private BigDecimal payAmount;/*** 订单状态*/@Excel(name = "订单状态", width = 10.0)private String status;/*** 操作*/@Excel(name = "操作", width = 10.0)private String orderOpt;/*** 下单时间*/@Excel(name = "下单时间", width = 10.0)private String createTime;
}

Controller层

@GetMapping("export")public void exportUsers(OrderEntity orderEntity, HttpServletResponse response) {orderManagerService.exportOrders(orderEntity,response);}

Service层

@Overridepublic void exportOrders(OrderEntity orderEntity,HttpServletResponse response) {try {//从数据库查询到数据List<OrderDao> orderDaoList = orderMapper.selectOrders(orderEntity);List<SupplyChainOrdersVo> supplyChainOrdersVos = null;if (CollectionUtil.isEmpty(orderDaoList)) {log.error("order表中未查询到对应数据");return;}supplyChainOrdersVos = new ArrayList<>(orderDaoList.size());.......//设置信息头，告诉浏览器内容为excel类型response.setHeader("content-Type", "application/vnd.ms-excel");//sheet名称String sheetName = "订单";response.setCharacterEncoding("UTF-8");//设置下载名称response.setHeader("Content-Disposition", "attachment;filename="+ URLEncoder.encode("订单表.xls","UTF-8"));//字节流输出ServletOutputStream out = response.getOutputStream();//设置excel参数ExportParams params = new ExportParams();//设置sheet名params.setSheetName(sheetName);//设置标题params.setTitle("订单表");//转成对应的类型;要不然会报错，虽然也可以导出成功。List<ExportOrder> exportUsers = changeType(supplyChainOrdersVos);//导入excelWorkbook workbook = ExcelExportUtil.exportExcel(params, ExportOrder.class,exportUsers);//写入workbook.write(out);} catch (Exception e) {e.printStackTrace();}}