记录后台使用Easy Excel导出Excel为Base64传到前台解析问题

最新推荐文章于 2024-04-25 11:54:24 发布

cavan2

最新推荐文章于 2024-04-25 11:54:24 发布

阅读量929

点赞数

分类专栏：记录文章标签： java 开发语言后端

本文链接：https://blog.csdn.net/chinasun2015/article/details/122102343

版权

记录专栏收录该内容

4 篇文章 0 订阅

订阅专栏

/**
     *
     * @param list 数据
     * @param clazz EasyExcel 表格Modal
     * @return
     */
    public static <T> String exportExcelToBase64(List<T> list, Class<T> clazz) {
        ByteArrayOutputStream out = new ByteArrayOutputStream();
        ExcelWriter excelwriter = EasyExcel.write(out).build();
        WriteSheet sheet = EasyExcel.writerSheet(1, "sheet0").build();
        WriteTable table = new WriteTable();
        table.setClazz(clazz);
        excelwriter.write(list, sheet, table);
        excelwriter.finish();
        InputStream inputStream = new ByteArrayInputStream(out.toByteArray());
        return Base64Util.fileToBase64(inputStream);
    }

/**
     * @return String
     * @description 将文件转base64字符串
     */
    public static String fileToBase64(InputStream inputStream) {
        // 将文件转化为字节数组字符串，并对其进行Base64编码处理
        byte[] data = null;
        // 读取文件字节数组
        try {
            ByteArrayOutputStream swapStream = new ByteArrayOutputStream();
            byte[] buff = new byte[2048];
            int rc = 0;
            while ((rc = inputStream.read(buff, 0, 100)) > 0) {
                swapStream.write(buff, 0, rc);
            }
            data = swapStream.toByteArray();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (inputStream != null) {
                try {
                    inputStream.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }

        return Base64.encodeBase64String(data);
    }

前台demo 引用其他博客文章

https://www.jianshu.com/p/d625fd88146d

<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8" />
        <title>base64ToExcel</title>
    </head>
    <body>
        请输入base64串
        <button onclick="submit()">生成excel</button>
        <br /><br />
        <input id="test" style="width: 800px; height: 30px" />

        <script>
            function submit() {
                let data = document.getElementById("test").value;
                saveData(data, "test.xlsx");
            }

            function saveData(data, filename) {
                let blob = dataURItoBlob(data);
                let objectUrl = URL.createObjectURL(blob);
                //let spl = filename.split(".");
                //window.open(objectUrl,'_blank','alwaysRaised=yes,height=500, width=800, toolbar= no, menubar=no, scrollbars=no, resizable=no, location=yes, status=no,top=100,left=300')
                let aLink = document.createElement("a"); //新添加的  尝试
                let evt = document.createEvent("HTMLEvents");
                evt.initEvent("click", true, true);
                aLink.download = filename; //新添加的  尝试
                aLink.href = objectUrl;
                aLink.click();
                //没有清理的 DOM 元素引用
                //document.body.removeChild(aLink)
            }
            /**
             * base64  to blob二进制
             */
            function dataURItoBlob(dataURI) {
                debugger;
                var byteString = window.atob(dataURI); //base64 解码
                var arrayBuffer = new ArrayBuffer(byteString.length); //创建缓冲数组
                var intArray = new Uint8Array(arrayBuffer); //创建视图
                for (var i = 0; i < byteString.length; i++) {
                    intArray[i] = byteString.charCodeAt(i);
                }

                // return new Blob([intArray],{type: "application/vnd.ms-excel;charset=utf-8;"});//原来封装好的 下载的是excel

                return new Blob([intArray], {
                    type: "application/octet-stream;charset=utf-8;",
                }); //修改-1
            }
        </script>
    </body>
</html>

cavan2

关注

0
点赞
踩
5

收藏

觉得还不错? 一键收藏
0
评论
记录后台使用Easy Excel导出Excel为Base64传到前台解析问题

/** * * @param list 数据 * @param clazz EasyExcel 表格Modal * @return */ public static <T> String exportExcelToBase64(List<T> list, Class<T> clazz) { ByteArrayOutputStream out = new ByteArrayOutputStream()
复制链接

扫一扫

专栏目录