您好,欢迎来到二三娱乐。
搜索
您的当前位置:首页Angularjs 导出数据到Excel

Angularjs 导出数据到Excel

来源:二三娱乐
    let arr = ['方法1'];

    let blob = new Blob([arr], {type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"});
    let objectUrl = URL.createObjectURL(blob);
    let a = document.createElement('a');
    document.body.appendChild(a);
    a.setAttribute('style', 'display:none');
    a.setAttribute('href', objectUrl);
    a.setAttribute('download', "导出.xlsx");
    a.click();
    URL.revokeObjectURL(objectUrl);
    let arr = [{id: '1',name:'22'}];

    const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(arr);
    const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['data'] };
    const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });

    const data: Blob = new Blob([excelBuffer], {
        type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
    });
    FileSaver.saveAs(data, "导出.xlsx");

Copyright © 2019- yule263.com 版权所有 湘ICP备2023023988号-1

违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务