909422229_springboot中使用poi导出Excel

技术交流群：958923746，有学习视频，文档等。

一、首先是pox.xml

        <dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi</artifactId>
			<version>RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.apache.poi</groupId>
			<artifactId>poi-ooxml</artifactId>
			<version>RELEASE</version>
		</dependency>

二、工具类，这是Excel调用部分，下载，创建excel等。

package com.jeesite.modules.award.basic.utils;

import java.io.FileOutputStream;
import java.io.OutputStream;
import java.net.URLEncoder;
import javax.servlet.http.HttpServletResponse;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.hibernate.validator.internal.util.StringHelper;

/**
 * @date 2019年4月11日 19:47:25
 * @author wangsh
 *
 */
public class ExportUtils {
	// 创建表头
	public static void createTitle(HSSFWorkbook workbook, HSSFSheet sheet) {
		HSSFRow row = sheet.createRow(0);
		// 设置列宽，setColumnWidth的第二个参数要乘以256，这个参数的单位是1/256个字符宽度
		sheet.setColumnWidth(0, 30 * 256);
		sheet.setColumnWidth(1, 40 * 256);
		sheet.setColumnWidth(2, 30 * 256);

		// 设置为居中加粗
		HSSFCellStyle style = workbook.createCellStyle();
		HSSFFont font = workbook.createFont();
            //eclipse使用
		style.setAlignment(HorizontalAlignment.CENTER);
		//idea 使用
		//style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
		
		font.setBold(true);
		//style.setFont(font);
		HSSFCell cell;
		cell = row.createCell(0);
		cell.setCellValue("申报年份");
		cell.setCellStyle(style);

		cell = row.createCell(1);
		cell.setCellValue("企业名称");
		cell.setCellStyle(style);

		cell = row.createCell(2);
		cell.setCellValue("所属区县");
		cell.setCellStyle(style);


	}

	// 生成excel文件
	public static void buildExcelFile(String filename, HSSFWorkbook workbook) throws Exception {
		FileOutputStream fos = new FileOutputStream(filename);
		workbook.write(fos);
		fos.flush();
		fos.close();
	}

	// 浏览器下载excel
	public static void buildExcelDocument(String filename, HSSFWorkbook workbook, HttpServletResponse response)
			throws Exception {
		response.setContentType("application/vnd.ms-excel");
		response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, "utf-8"));
		OutputStream outputStream = response.getOutputStream();
		workbook.write(outputStream);
		outputStream.flush();
		outputStream.close();
	}

}

三、controller层的代码，前端点击按钮下载Excel

    @RequestMapping(value = "getExcel")
	public String getExcel(HttpServletRequest request,HttpServletResponse response,List rows) throws Exception {
        HSSFWorkbook workbook = new HSSFWorkbook();
			HSSFSheet sheet = workbook.createSheet("统计表");
			ExportUtils.createTitle(workbook, sheet);
			// 设置日期格式
			HSSFCellStyle style = workbook.createCellStyle();
			style.setAlignment(HorizontalAlignment.CENTER);
			// 新增数据行，并且设置单元格数据
			int rowNum = 1;
			for (Object obj : rows) {
				HSSFRow row = sheet.createRow(rowNum);
				HSSFCell cell0 = row.createCell(0);
				cell0.setCellStyle(style);
				    cell0.setCellValue("00");
				HSSFCell cell1 = row.createCell(1);
				cell1.setCellStyle(style);
					cell1.setCellValue((!StringHelper.isNullOrEmptyString("11");
				HSSFCell cell2 = row.createCell(2);
				cell2.setCellStyle(style);
					cell2.setCellValue("22");
				rowNum++;
			}
			rows = null;
			String fileName = DateUtil.getTodayShort()+".xls";

			// 生成excel文件
			ExportUtils.buildExcelFile(fileName, workbook);

			// 浏览器下载excel
			ExportUtils.buildExcelDocument(fileName, workbook, response);

			return "download excel";