导出为Excel文件

/**

* 导出为Excel文件

*

* @param dataList  数据列表

* @param columnMap 输出列及其中文列名，按顺序输出

* @param fileName  文件名

* @param <T>

* @return oss文件url

*/

public static StringexportExcel(List dataList, LinkedHashMap columnMap, String fileName) {

    String url ="";

    if (null == dataList) {

        return url;

    }

    try {

        //写到字节输出流

        ByteArrayOutputStream byteArrayOutputStream =exportExcelOutputStream(dataList, columnMap);

        if (null == byteArrayOutputStream) {

            return url;

        }

        //文件流上传Oss

        fileName = fileName.replace(".xlsx", "");

        fileName = fileName.replace(".xls", "");

        ByteArrayInputStream byteArrayInputStream = ConversionUtil.outputStream2InputStream(byteArrayOutputStream);

        url = OssUtil.uploadStream(byteArrayInputStream, fileName, ".xlsx");

    }catch (Exception e) {

        logger.error("exportExcel error: ", e);

    }

    return url;

}

导出Excel到HttpServletResponse

/**

* 导出Excel到HttpServletResponse

*

* @param dataList  数据列表

* @param columnMap 输出列及其中文列名，按顺序输出

* @param fileName  文件名

* @param <T>

*/

public static void exportExcelToHttpServletResponse(List dataList, LinkedHashMap columnMap, String fileName, HttpServletResponse response) {

    if (null == dataList) {

        return;

    }

    try {

        //写到字节输出流

        ByteArrayOutputStream byteArrayOutputStream =exportExcelOutputStream(dataList, columnMap);

        if (null == byteArrayOutputStream) {

            return;

        }

        //导出文件流到HttpServletResponse

        //防止乱码，设置HttpServletResponse编码

        response.setCharacterEncoding("utf-8");

        response.setContentType("multipart/form-data");

        //设置页面禁止缓存

        response.setDateHeader("Expires", 0);

        response.setHeader("Cache-Control", "no-cache");

        response.setHeader("Pragma", "no-cache");

        //设置下载文件名

        response.setHeader("Content-Disposition", "attachment;filename=" +

        new String(fileName.getBytes("gb2312"), "ISO8859-1"));

        //文件输出流写入HttpServletResponse

        byteArrayOutputStream.writeTo(response.getOutputStream());

    }catch (Exception e) {

        logger.error("exportExcel error: ", e);

    }

}