前言

多多點(diǎn)贊，會(huì)變好看！

多多留言，會(huì)變有錢！

有些時(shí)候列表的列可能是動(dòng)態(tài)的，需要根據(jù)動(dòng)態(tài)表頭導(dǎo)出Excel文件，這時(shí)候可以使用下面的方法解決：

    /**
     * 使用EasyExcel導(dǎo)出動(dòng)態(tài)Excel
     * @param includeColumnFiledNames
     * @param fileName
     * @param list
     * @param clazz
     * @param response
     */
    public static void exportDynamicExcel(Set<String> includeColumnFiledNames, String fileName, List list, Class clazz, HttpServletResponse response) {
        try {
            ServletOutputStream os = response.getOutputStream();
            response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
            response.setCharacterEncoding("utf-8");
            String encodeFileName = new String(fileName.getBytes(), "ISO8859-1");
            response.setContentType("application/octet-stream;charset=UTF-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + encodeFileName + ".xlsx");

            ExcelWriterBuilder excelBuilder = EasyExcel.write(os, clazz);
            excelBuilder = includeColumnFiledName(includeColumnFiledNames, excelBuilder);
            excelBuilder.useDefaultStyle(false).sheet(fileName).doWrite(list);
            os.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    private static ExcelWriterBuilder includeColumnFiledName(Set<String> includeColumnFiledNames, ExcelWriterBuilder excelBuilder) {
        excelBuilder = excelBuilder.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy());
        if (includeColumnFiledNames.size() > 0) {
            excelBuilder = excelBuilder.includeColumnFiledNames(includeColumnFiledNames);
        }
        excelBuilder = excelBuilder.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy());
        return excelBuilder;
    }

擴(kuò)展

靜態(tài)列導(dǎo)出代碼：文章來源地址http://www.zghlxwxcb.cn/news/detail-608826.html

    /**
     * 使用EasyExcel導(dǎo)出Excel
     */
    public static void exportExcel(String fileName, List list, Class clazz, HttpServletResponse response) {
        try {
            String fileNameFull = fileName + "(" + TimeUtils.getTime() + ")";
            ServletOutputStream os = response.getOutputStream();
            response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
            response.setCharacterEncoding("utf-8");
            String encodeFileName = URLEncoder.encode(fileNameFull, "UTF-8");
            response.setContentType("application/octet-stream;charset=UTF-8");
            response.setHeader("Content-Disposition", "attachment;filename=" + encodeFileName + ".xlsx");
            EasyExcel.write(os, clazz).useDefaultStyle(false).sheet(fileName).doWrite(list);
            os.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

到了這里，關(guān)于Java——使用EasyExcel導(dǎo)出動(dòng)態(tài)列的Excel的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！