记录一个简单完整的导出方法

前端在请求导出方法时 不要使用Ajax交互，使用 
 

window.location.href = url+"?id="+id+"&name="+name;

这种方式
 

    @RequestMapping(value = "/daochu",method = RequestMethod.GET)
    public void daochu(AppealFormVO appealFormVO, HttpServletRequest request, HttpServletResponse response){
        //获取需要导出的数据值
        List<AppealFormVO> list = appealFormService.ExportSelectAllList(appealFormVO);
        //创建excel表头
        List<String> column = new ArrayList<>();
        column.add("兑现单");
        column.add("企业名称");
        column.add("企业信用代码");
        column.add("企业联系人");
        //表头对应的数据
        List<Map<String,Object>> data = new ArrayList<>();
        //遍历获取到的需要导出的数据，k要和表头一样
        for (int i = 0; i < list.size(); i++) {
            Map<String,Object> dataMap = new HashMap<>();
            AppealFormVO appealFormVO1 = list.get(i);
            dataMap.put("兑现单",appealFormVO1.getCashNo());
            dataMap.put("企业名称",appealFormVO1.getCompanyName());
            dataMap.put("企业信用代码",appealFormVO1.getCreditCode());
            dataMap.put("企业联系人",appealFormVO1.getContactName());
            data.add(dataMap);
        }
        //调用导出工具类
        ExportExcel.exportExcel_two("table",column,data,request,response);
    }

注意

RequestMapping 使用 GET

package XXXXXXXXXX

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.xssf.streaming.SXSSFRow;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import sun.misc.BASE64Encoder;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.net.URLEncoder;
import java.util.List;
import java.util.Map;

public class ExportExcel {
    /**
     * @param sheetName 工作表的名字
     * @param column  列名
     * @param data  需要导出的数据    ( map的键定义为列的名字 一定要和column中的列明保持一致  )
     * @param response
     */
    public static void exportExcel(String sheetName, List<String> column, List<Map<String,Object>> data, HttpServletRequest request, HttpServletResponse response){
        //创建工作薄
        SXSSFWorkbook hssfWorkbook = new SXSSFWorkbook();
        //创建sheet
        SXSSFSheet sheet = hssfWorkbook.createSheet(sheetName);
        // 表头
        SXSSFRow headRow = sheet.createRow(0);
        for (int i = 0; i < column.size(); i++){
            headRow.createCell(i).setCellValue(column.get(i));
        }

        for (int i = 0; i < data.size(); i++) {
            SXSSFRow dataRow = sheet.createRow(sheet.getLastRowNum() + 1);
            for (int x = 0; x < column.size(); x++) {
                dataRow.createCell(x).setCellValue(data.get(i).get(column.get(x))==null?"":data.get(i).get(column.get(x)).toString());
            }
        }

        response.setContentType("application/vnd.ms-excel");

        try {
            //获取浏览器名称
            String agent=request.getHeader("user-agent");
            String filename=sheetName+".xls";
            //不同浏览器需要对文件名做特殊处理
            if (agent.contains("Firefox")) { // 火狐浏览器
                filename = "=?UTF-8?B?"
                        + new BASE64Encoder().encode(filename.getBytes("utf-8"))
                        + "?=";
                filename = filename.replaceAll("\r\n", "");
            } else { // IE及其他浏览器
                filename = URLEncoder.encode(filename, "utf-8");
                filename = filename.replace("+"," ");
            }
            //推送浏览器
            response.setHeader("Content-Disposition","attachment;filename="+filename);
            hssfWorkbook.write(response.getOutputStream());
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    //可自动新增sheet
    public static void exportExcel_two(String sheetName, List<String> column, List<Map<String,Object>> data, HttpServletRequest request, HttpServletResponse response){
        //创建工作薄
        HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
        //创建sheet
        HSSFSheet sheet = hssfWorkbook.createSheet(sheetName);
        // 表头
        HSSFRow headRow = sheet.createRow(0);
        for (int i = 0; i < column.size(); i++){
            headRow.createCell(i).setCellValue(column.get(i));
        };
        int index = 1;

        for (int i = 0; i < data.size(); i++) {
            if(i%65534 == 0 && i != 0){
                //写入数据达到10000条时 新增一个sheet 防止报错
                sheet = hssfWorkbook.createSheet(sheetName + index);
                headRow = sheet.createRow(0);
                for (int k = 0; k < column.size(); k++){
                    headRow.createCell(k).setCellValue(column.get(k));
                };
                index ++;
            }
            HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum() + 1);
            for (int x = 0; x < column.size(); x++) {
                dataRow.createCell(x).setCellValue(data.get(i).get(column.get(x))==null?"":data.get(i).get(column.get(x)).toString());
            }
        }

        response.setContentType("application/vnd.ms-excel");

        try {
            //获取浏览器名称
            String agent=request.getHeader("user-agent");
            String filename=sheetName+".xls";
            //不同浏览器需要对文件名做特殊处理
            if (agent.contains("Firefox")) { // 火狐浏览器
                filename = "=?UTF-8?B?"
                        + new BASE64Encoder().encode(filename.getBytes("utf-8"))
                        + "?=";
                filename = filename.replaceAll("\r\n", "");
            } else { // IE及其他浏览器
                filename = URLEncoder.encode(filename, "utf-8");
                filename = filename.replace("+"," ");
            }
            //推送浏览器
            response.setHeader("Content-Disposition","attachment;filename="+filename);
            hssfWorkbook.write(response.getOutputStream());
        } catch (Exception e) {
            e.printStackTrace();
        }
    }


}

导出工具类  拷贝直接使用   

exportExcel_two（）方法 当sheet 行数到达65534行将自动新增sheet子页exportExcel()方法不会