js导出Excel，导出当前页面内容

ghx123456ghx

已于 2023-11-14 16:59:39 修改

阅读量160

点赞数

文章标签： excel 前端 vue导出

于 2023-11-14 15:13:10 首次发布

本文链接：https://blog.csdn.net/ghx123456ghx/article/details/104134932

版权

js代码

import FileSaver from 'file-saver'
import * as XLSX from 'xlsx'

  var xlsxParam = { raw: false } // 导出的内容进行格式转换
        var wb = XLSX.utils.table_to_book(document.querySelector('#planTable'), xlsxParam)
        var ws = wb.Sheets['Sheet1']
        //设置金额格式
        ws['A2'].z = '#,##0.00_ '
        delete ws['A2'].w
        //设置单元格宽度，字母1个占1，汉字一个占2
ws['!cols'] = [
          { wch: 4 },
          { wch: 6 },
          { wch: 28 },
          { wch: 28 },
          { wch: 26 },
          { wch: 8 },
          { wch: 24 },
          { wch: 12 },
          { wch: 12 }
        ]
        XLSX.utils.format_cell(ws['A2'])
            // const style = {alignment: 'center'}
        // XLSX.utils.sheet_set_range_style(ws,'A1:C3',style)
        /* get binary string as output */
        var wbout = XLSX.write(wb, { bookType: 'xlsx', bookSST: true, type: 'array' })
        try {
          FileSaver.saveAs(new Blob([wbout], { type: 'application/octet-stream' }), '计划信息导出.xlsx')
        } catch (e) {
          if (typeof console !== 'undefined') {
            console.log(e, wbout)
          }
        }
        return wbout