springboot导出excel

poi 

    <!--导入导出Excel-->
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>3.13</version>
    </dependency>
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>3.13</version>
    </dependency>

工具类
 

package com.fc.test.util;

import com.fc.test.model.auto.ApplianceDevice;
import org.apache.poi.hssf.usermodel.*;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.OutputStream;
import java.util.List;
/**
 * 客户端工具类
 * @author zlxls
 * @date 2020年08月18日
 */
public class ExcelUtils {
    /**
     * ！！！！注意List<ApplianceDevice> list 根据自己的需要填充数据
     * 导出部门台账
     * @param list
     * @param response
     * @throws IOException
     */
    public static void deviceExport(List<ApplianceDevice> list, HttpServletResponse response) throws IOException {
        String fileName = "台帐（使用单位（部门）版）";
        //表头数据
        String[] header = {"序号", "名称", "规格型号（参数）", "厂家名称", "总数量", "领用","领用数量","备注"};
        //声明一个工作簿
        HSSFWorkbook workbook = new HSSFWorkbook();
        //生成一个表格，设置表格名称
        HSSFSheet sheet = workbook.createSheet(fileName);
        //设置表格列宽度为10个字节
        sheet.setDefaultColumnWidth(10);
        //创建第一行表头
        HSSFRow headrow = sheet.createRow(0);
        //遍历添加表头(下面模拟遍历，也是同样的操作过程)
        for (int i = 0; i < header.length; i++) {
            //创建一个单元格
            HSSFCell cell = headrow.createCell(i);

            //创建一个内容对象
            HSSFRichTextString text = new HSSFRichTextString(header[i]);

            //将内容对象的文字内容写入到单元格中
            cell.setCellValue(text);
        }
        for (int i=0;i<list.size();i++){
            ApplianceDevice record = list.get(i);
            HSSFRow row = sheet.createRow(i+1);
            row.createCell(0).setCellValue(new HSSFRichTextString(String.valueOf(i+1)));
            row.createCell(1).setCellValue(new HSSFRichTextString(record.getName()));
            row.createCell(2).setCellValue(new HSSFRichTextString(record.getSpec()));
            row.createCell(3).setCellValue(new HSSFRichTextString(record.getFactory()));
            row.createCell(4).setCellValue(new HSSFRichTextString(record.getPrintNumber().toString()));
            row.createCell(5).setCellValue(new HSSFRichTextString(record.getOrganizeId()));
            row.createCell(6).setCellValue(new HSSFRichTextString(record.getPrintNumber().toString()));
            row.createCell(7).setCellValue(new HSSFRichTextString(""));
        }
        //生成文件的文件名
        fileName= new String((fileName+".xls").getBytes("UTF-8"),"iso-8859-1");
        //准备将Excel的输出流通过response输出到页面下载
        //八进制输出流
        response.setContentType("application/octet-stream");
        //这后面可以设置导出Excel的名称
        response.setHeader("Content-disposition", "attachment;filename="+ fileName);
        //刷新缓冲
        response.flushBuffer();
        //workbook将Excel写入到response的输出流中，供页面下载
        OutputStream os = response.getOutputStream();
        workbook.write(os);
        if(os!=null){
            os.close();
        }
    }
}