angularJS 纯js导出excel

最新推荐文章于 2024-04-14 10:40:27 发布

原创最新推荐文章于 2024-04-14 10:40:27 发布

· 390 阅读

0 ·

版权

需要引用FileSaver.js 、 xlsx.full.min.js

//导出按钮
        self.export = function () {
	    //导出的数据全部放到data中
	    // 表头 
            let data = [["Name", "Desc"]];
            // 填充数据
            for (let i = 0; i < self.viewerData.length; i++) {
                data.push([self.viewerData[i].Name, self.viewerData[i].Desc]);
            }


            let wopts = { bookType: 'xlsx', type: 'binary' };
            // 定义excel表名
            let fileName = "bill.xlsx";

            const ws = XLSX.utils.aoa_to_sheet(data);
            const wb = XLSX.utils.book_new();
            XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');

            const wbout = XLSX.write(wb, wopts);
            saveAs(new Blob([s2ab(wbout)]), fileName); // 保存为文件
        }
        
	function s2ab(s) {
            const buf = new ArrayBuffer(s.length);
            const view = new Uint8Array(buf);
            for (let i = 0; i !== s.length; ++i) {
                view[i] = s.charCodeAt(i) & 0xFF;
            };
            return buf;
        }