【poi excel导出】不同浏览器的编码方式，解决下载文件名称乱码

poi所需要的jar包

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

controller

 /**     * 数字数据导出excel     * @param statisticsDataForm     * @param request     * @param response     * @throws Exception     */    @RequestMapping("/staDataExport")    public void staDataExport(StatisticsDataForm statisticsDataForm,HttpServletRequest request,                              HttpServletResponse response) throws Exception{        ArrayList<String> fieldName =new ArrayList<>();        fieldName.add("统计时间");        fieldName.add("参与次数");        fieldName.add("参与人数");        fieldName.add("中奖人数");        ArrayList<ArrayList<String>> fieldData = eggService.findStaDataExportExcel(statisticsDataForm);        ExcelFileGenerator generator = new ExcelFileGenerator(fieldName,fieldData);        OutputStream os = response.getOutputStream();        String filename = "砸金蛋数字数据统计（"+ DateUtils.format(new Date(), DateUtils.PATTERN_TIMESTAMP)+"）.xls";        filename = ExcelFileGenerator.processFileName(request,filename);        //可以不加，但是保证response缓冲区没有任何数据，开发时建议加上        response.reset();        response.setContentType("application/vnd.ms-excel;charset=utf-8");        response.setHeader("Content-disposition", "attachment;filename="+filename);        response.setBufferSize(1024);        /**将生成的excel报表，写到os中*/        generator.expordExcel(os);    }

poi报表导出excel小工具

/** * 系统数据导出Excel 生成器 * @version 1.0 */package com.raipeng.micro.enterprise.utils;import org.apache.poi.hssf.usermodel.*;import org.apache.poi.hssf.util.HSSFColor;import javax.servlet.http.HttpServletRequest;import java.io.OutputStream;import java.util.ArrayList;public class ExcelFileGenerator {private final int SPLIT_COUNT = 65536; //Excel每个工作簿的行数private ArrayList<String> fieldName = null; //excel标题数据集private ArrayList<ArrayList<String>> fieldData = null; //excel数据内容private HSSFWorkbook workBook = null;/** * 构造器 * @param fieldName 结果集的字段名 * @param fieldData */public ExcelFileGenerator(ArrayList<String> fieldName, ArrayList<ArrayList<String>> fieldData) {this.fieldName = fieldName;this.fieldData = fieldData;}/** * 创建HSSFWorkbook对象 * @return HSSFWorkbook */public HSSFWorkbook createWorkbook() {workBook = new HSSFWorkbook();//创建一个工作薄对象int rows = fieldData.size();//总的记录数int sheetNum = 0;           //指定sheet的页数if (rows % SPLIT_COUNT == 0) {sheetNum = rows / SPLIT_COUNT;} else {sheetNum = rows / SPLIT_COUNT + 1;}for (int i = 1; i <= sheetNum; i++) {//循环2个sheet的值HSSFSheet sheet = workBook.createSheet("Page " + i);//使用workbook对象创建sheet对象HSSFRow headRow = sheet.createRow((short) 0); //创建行，0表示第一行（本例是excel的标题）for (int j = 0; j < fieldName.size(); j++) {//循环excel的标题HSSFCell cell = headRow.createCell( j);//使用行对象创建列对象，0表示第1列/**************对标题添加样式begin********************///设置列的宽度/sheet.setColumnWidth(j, 6000);HSSFCellStyle cellStyle = workBook.createCellStyle();//创建列的样式对象HSSFFont font = workBook.createFont();//创建字体对象//字体加粗font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);//字体颜色变红font.setColor(HSSFColor.RED.index);//如果font中存在设置后的字体，并放置到cellStyle对象中，此时该单元格中就具有了样式字体cellStyle.setFont(font);/**************对标题添加样式end********************///添加样式cell.setCellType(HSSFCell.CELL_TYPE_STRING);if(fieldName.get(j) != null){//将创建好的样式放置到对应的单元格中cell.setCellStyle(cellStyle);cell.setCellValue((String) fieldName.get(j));//为标题中的单元格设置值}else{cell.setCellValue("-");}}//分页处理excel的数据，遍历所有的结果for (int k = 0; k < (rows < SPLIT_COUNT ? rows : SPLIT_COUNT); k++) {if (((i - 1) * SPLIT_COUNT + k) >= rows)//如果数据超出总的记录数的时候，就退出循环break;HSSFRow row = sheet.createRow((short) (k + 1));//创建1行//分页处理，获取每页的结果集，并将数据内容放入excel单元格ArrayList<String> rowList = (ArrayList<String>) fieldData.get((i - 1) * SPLIT_COUNT + k);for (int n = 0; n < rowList.size(); n++) {//遍历某一行的结果HSSFCell cell = row.createCell( n);//使用行创建列对象if(rowList.get(n) != null){cell.setCellValue((String) rowList.get(n).toString());}else{cell.setCellValue("");}}}}return workBook;}public void expordExcel(OutputStream os) throws Exception {workBook = createWorkbook();workBook.write(os);//将excel中的数据写到输出流中，用于文件的输出os.close();}    //解决设置名称时的乱码    public static String processFileName(HttpServletRequest request, String fileNames) {        String codedfilename = null;        try {            String agent = request.getHeader("USER-AGENT");            if (null != agent && -1 != agent.indexOf("MSIE") || null != agent                    && -1 != agent.indexOf("Trident")) {// ie                String name = java.net.URLEncoder.encode(fileNames, "UTF8");                codedfilename = name;            } else if (null != agent && -1 != agent.indexOf("Mozilla")) {// 火狐,chrome等                codedfilename = new String(fileNames.getBytes("UTF-8"), "iso-8859-1");            }        } catch (Exception e) {            e.printStackTrace();        }        return codedfilename;    }}