master

分支 (1)

管理

管理

master

xlsx_style
/
demo.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>test</title>
    <script src="./libs/xlsx.core.min.js"></script>
    <script src="./libs/xlsx.style.min.js"></script>
</head>
<body>
<h1>整合<a href="https://github.com/SheetJS/js-xlsx" target="_blank">sheetjs</a>和<a href="https://github.com/protobi/js-xlsx" target="_blank">xlsx-style</a>导出自定义样式Excel的示例代码</h1>
<script type="text/javascript">
    ((win,doc) => {

        function str_to_array_buffer(str){
            let buf = new ArrayBuffer(str.length);
            let view = new Uint8Array(buf);
            for (let i=0;i!==str.length;++i) view[i] = str.charCodeAt(i) & 0xFF;
            return buf;
        }

        // 设置数据
        let wb = {
            SheetNames: ["sheet1"],
            Sheets: {},
        };
        let data = [
            ["标题1","标题2","标题3"],
            ["123","456","789"]
        ];
        let ws = XLSX.utils.aoa_to_sheet(data);

        // 设置样式
        ws["A1"].s = {
            fill: { fgColor: { rgb: 'FFFFFF00' } }
        };
        wb.Sheets["sheet1"] = ws;

        // 导出保存
        let wopts = {bookType: 'xlsx',bookSST: false,type: 'binary'};
        let wbout = XlsxStyle.write(wb, wopts);
        let blob = new Blob([str_to_array_buffer(wbout)], {type:"application/octet-stream"});
        let url = window.URL.createObjectURL(blob);

        let link = doc.createElement('a');
        let body = doc.querySelector('body');
        link.href = url;
        link.download = "demo.xlsx";

        // fix Firefox
        link.style.display = 'none';
        body.appendChild(link);
        link.click();
        body.removeChild(link);
        win.URL.revokeObjectURL(link.href);

    })(window,document);
</script>
</body>
</html>