Java Excel数据导出

导出效果展示

  相关jar包: pom.xml
	<!-- Excel -->
	<dependency>
		<groupId>cn.afterturn</groupId>
		<artifactId>easypoi-base</artifactId>
		<version>3.2.0</version>
	</dependency>
	<dependency>
		<groupId>cn.afterturn</groupId>
		<artifactId>easypoi-web</artifactId>
		<version>3.2.0</version>
	</dependency>
	<dependency>
		<groupId>cn.afterturn</groupId>
		<artifactId>easypoi-annotation</artifactId>
		<version>3.2.0</version>
	</dependency>

pojo实体类:ExcelCustomerCar; ExcelCustomer;

客户车辆信息

客户信息

Controller类

setExportExcelFormat();方法

  public static void setExportExcelFormat(HttpServletResponse response, Workbook workbook, String fileName) throws Exception {
    response.setHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(), "ISO8859-1"));
    response.setHeader("Pargam", "no-cache");
    response.setHeader("Cache-Control", "no-cache");
    ServletOutputStream outStream = null;
    try {
        outStream = response.getOutputStream();
        workbook.write(outStream);
    } finally {
        outStream.flush();
        outStream.close();
    }
}

Java Excel数据导出

原文：https://www.cnblogs.com/dawndefend/p/14313260.html