• vue中用xlsx、xlsx-style、file-saver插件实现用表格原始数据打印excel文件

     打印出的excel文件如下： 

     1、需要安装插件（xlsx插件使用后已经有换行功能，如果对导出的excel文件没有样式要求就不用下载xlsx-style插件）

    npm i -S xlsx
    npm i -S file-saver

    xlsx-style依据情况选择使用：如需要换单元格底色，加边框，等

    npm i -S xlsx-style

    安装过程中遇到的问题：

    Can‘t resolve ‘./cptable‘ in ‘xxx\node_modules_xlsx

    解决办法：在vue.config.js文件中加入如下代码

    1.   chainWebpack: (config) => {
    2.     //忽略的打包文件
    3.     config.externals({
    4.       './cptable': 'var cptable'
    5.     });
    6.   },

    2、加入关键js文件，我加在工具类文件夹下了

     js文件中完整内容如下：

    Blob.js

    1. /* eslint-disable */
    2. /* Blob.js
    3.  * A Blob implementation.
    4.  * 2014-05-27
    5.  *
    6.  * By Eli Grey, http://eligrey.com
    7.  * By Devin Samarin, https://github.com/eboyjr
    8.  * License: X11/MIT
    9.  *   See LICENSE.md
    10.  */
    11.  
    12. /*global self, unescape */
    13. /*jslint bitwise: true, regexp: true, confusion: true, es5: true, vars: true, white: true,
    14.  plusplus: true */
    15.  
    16. /*! @source http://purl.eligrey.com/github/Blob.js/blob/master/Blob.js */
    17.  
    18. (function (view) {
    19.     "use strict";
    20.  
    21.     view.URL = view.URL || view.webkitURL;
    22.  
    23.     if (view.Blob && view.URL) {
    24.         try {
    25.             new Blob;
    26.             return;
    27.         } catch (e) {}
    28.     }
    29.  
    30.     // Internally we use a BlobBuilder implementation to base Blob off of
    31.     // in order to support older browsers that only have BlobBuilder
    32.     var BlobBuilder = view.BlobBuilder || view.WebKitBlobBuilder || view.MozBlobBuilder || (function(view) {
    33.             var
    34.                 get_class = function(object) {
    35.                     return Object.prototype.toString.call(object).match(/^\[object\s(.*)\]$/)[1];
    36.                 }
    37.                 , FakeBlobBuilder = function BlobBuilder() {
    38.                     this.data = [];
    39.                 }
    40.                 , FakeBlob = function Blob(data, type, encoding) {
    41.                     this.data = data;
    42.                     this.size = data.length;
    43.                     this.type = type;
    44.                     this.encoding = encoding;
    45.                 }
    46.                 , FBB_proto = FakeBlobBuilder.prototype
    47.                 , FB_proto = FakeBlob.prototype
    48.                 , FileReaderSync = view.FileReaderSync
    49.                 , FileException = function(type) {
    50.                     this.code = this[this.name = type];
    51.                 }
    52.                 , file_ex_codes = (
    53.                     "NOT_FOUND_ERR SECURITY_ERR ABORT_ERR NOT_READABLE_ERR ENCODING_ERR "
    54.                     + "NO_MODIFICATION_ALLOWED_ERR INVALID_STATE_ERR SYNTAX_ERR"
    55.                 ).split(" ")
    56.                 , file_ex_code = file_ex_codes.length
    57.                 , real_URL = view.URL || view.webkitURL || view
    58.                 , real_create_object_URL = real_URL.createObjectURL
    59.                 , real_revoke_object_URL = real_URL.revokeObjectURL
    60.                 , URL = real_URL
    61.                 , btoa = view.btoa
    62.                 , atob = view.atob
    63.  
    64.                 , ArrayBuffer = view.ArrayBuffer
    65.                 , Uint8Array = view.Uint8Array
    66.                 ;
    67.             FakeBlob.fake = FB_proto.fake = true;
    68.             while (file_ex_code--) {
    69.                 FileException.prototype[file_ex_codes[file_ex_code]] = file_ex_code + 1;
    70.             }
    71.             if (!real_URL.createObjectURL) {
    72.                 URL = view.URL = {};
    73.             }
    74.             URL.createObjectURL = function(blob) {
    75.                 var
    76.                     type = blob.type
    77.                     , data_URI_header
    78.                     ;
    79.                 if (type === null) {
    80.                     type = "application/octet-stream";
    81.                 }
    82.                 if (blob instanceof FakeBlob) {
    83.                     data_URI_header = "data:" + type;
    84.                     if (blob.encoding === "base64") {
    85.                         return data_URI_header + ";base64," + blob.data;
    86.                     } else if (blob.encoding === "URI") {
    87.                         return data_URI_header + "," + decodeURIComponent(blob.data);
    88.                     } if (btoa) {
    89.                         return data_URI_header + ";base64," + btoa(blob.data);
    90.                     } else {
    91.                         return data_URI_header + "," + encodeURIComponent(blob.data);
    92.                     }
    93.                 } else if (real_create_object_URL) {
    94.                     return real_create_object_URL.call(real_URL, blob);
    95.                 }
    96.             };
    97.             URL.revokeObjectURL = function(object_URL) {
    98.                 if (object_URL.substring(0, 5) !== "data:" && real_revoke_object_URL) {
    99.                     real_revoke_object_URL.call(real_URL, object_URL);
    100.                 }
    101.             };
    102.             FBB_proto.append = function(data/*, endings*/) {
    103.                 var bb = this.data;
    104.                 // decode data to a binary string
    105.                 if (Uint8Array && (data instanceof ArrayBuffer || data instanceof Uint8Array)) {
    106.                     var
    107.                         str = ""
    108.                         , buf = new Uint8Array(data)
    109.                         , i = 0
    110.                         , buf_len = buf.length
    111.                         ;
    112.                     for (; i < buf_len; i++) {
    113.                         str += String.fromCharCode(buf[i]);
    114.                     }
    115.                     bb.push(str);
    116.                 } else if (get_class(data) === "Blob" || get_class(data) === "File") {
    117.                     if (FileReaderSync) {
    118.                         var fr = new FileReaderSync;
    119.                         bb.push(fr.readAsBinaryString(data));
    120.                     } else {
    121.                         // async FileReader won't work as BlobBuilder is sync
    122.                         throw new FileException("NOT_READABLE_ERR");
    123.                     }
    124.                 } else if (data instanceof FakeBlob) {
    125.                     if (data.encoding === "base64" && atob) {
    126.                         bb.push(atob(data.data));
    127.                     } else if (data.encoding === "URI") {
    128.                         bb.push(decodeURIComponent(data.data));
    129.                     } else if (data.encoding === "raw") {
    130.                         bb.push(data.data);
    131.                     }
    132.                 } else {
    133.                     if (typeof data !== "string") {
    134.                         data += ""; // convert unsupported types to strings
    135.                     }
    136.                     // decode UTF-16 to binary string
    137.                     bb.push(unescape(encodeURIComponent(data)));
    138.                 }
    139.             };
    140.             FBB_proto.getBlob = function(type) {
    141.                 if (!arguments.length) {
    142.                     type = null;
    143.                 }
    144.                 return new FakeBlob(this.data.join(""), type, "raw");
    145.             };
    146.             FBB_proto.toString = function() {
    147.                 return "[object BlobBuilder]";
    148.             };
    149.             FB_proto.slice = function(start, end, type) {
    150.                 var args = arguments.length;
    151.                 if (args < 3) {
    152.                     type = null;
    153.                 }
    154.                 return new FakeBlob(
    155.                     this.data.slice(start, args > 1 ? end : this.data.length)
    156.                     , type
    157.                     , this.encoding
    158.                 );
    159.             };
    160.             FB_proto.toString = function() {
    161.                 return "[object Blob]";
    162.             };
    163.             FB_proto.close = function() {
    164.                 this.size = this.data.length = 0;
    165.             };
    166.             return FakeBlobBuilder;
    167.         }(view));
    168.  
    169.     view.Blob = function Blob(blobParts, options) {
    170.         var type = options ? (options.type || "") : "";
    171.         var builder = new BlobBuilder();
    172.         if (blobParts) {
    173.             for (var i = 0, len = blobParts.length; i < len; i++) {
    174.                 builder.append(blobParts[i]);
    175.             }
    176.         }
    177.         return builder.getBlob(type);
    178.     };
    179. }(typeof self !== "undefined" && self || typeof window !== "undefined" && window || this.content || this));
    180.  
    '
    运行

     Export2Excel.js，如果对打印出的表格有样式要求，需要好好读一下代码，对excel文件的样式对象属性做了解。推荐读这篇文章JavaScript导出excel文件，并修改文件样式_FEWY的博客-CSDN博客_js冒泡排序

    1. /* eslint-disable */
    2.  
    3. require('script-loader!file-saver');
    4. require('./Blob.js');
    5. require('script-loader!xlsx/dist/xlsx.core.min');
    6. import XLSXS from "xlsx-style"
    7. function generateArray(table) {
    8.     var out = [];
    9.     var rows = table.querySelectorAll('tr');
    10.     var ranges = [];
    11.     for (var R = 0; R < rows.length; ++R) {
    12.         var outRow = [];
    13.         var row = rows[R];
    14.         var columns = row.querySelectorAll('td');
    15.         for (var C = 0; C < columns.length; ++C) {
    16.             var cell = columns[C];
    17.             var colspan = cell.getAttribute('colspan');
    18.             var rowspan = cell.getAttribute('rowspan');
    19.             var cellValue = cell.innerText;
    20.             if (cellValue !== "" && cellValue == +cellValue) cellValue = +cellValue;
    21.  
    22.             //Skip ranges
    23.             ranges.forEach(function (range) {
    24.                 if (R >= range.s.r && R <= range.e.r && outRow.length >= range.s.c && outRow.length <= range.e.c) {
    25.                 for (var i = 0; i <= range.e.c - range.s.c; ++i) outRow.push(null);
    26.                 }
    27.             });
    28.  
    29.             //Handle Row Span
    30.             if (rowspan || colspan) {
    31.                 rowspan = rowspan || 1;
    32.                 colspan = colspan || 1;
    33.                 ranges.push({
    34.                 s: {
    35.                     r: R,
    36.                     c: outRow.length
    37.                 },
    38.                 e: {
    39.                     r: R + rowspan - 1,
    40.                     c: outRow.length + colspan - 1
    41.                 }
    42.                 });
    43.             };
    44.  
    45.             //Handle Value
    46.             outRow.push(cellValue !== "" ? cellValue : null);
    47.  
    48.             //Handle Colspan
    49.             if (colspan)
    50.                 for (var k = 0; k < colspan - 1; ++k) outRow.push(null);
    51.         }
    52.         out.push(outRow);
    53.     }
    54.     return [out, ranges];
    55. };
    56.  
    57. function datenum(v, date1904) {
    58.     if (date1904) v += 1462;
    59.     var epoch = Date.parse(v);
    60.     return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000);
    61. }
    62.  
    63. function sheet_from_array_of_arrays(data, opts) {
    64.     var ws = {};
    65.     var range = {
    66.         s: {
    67.             c: 10000000,
    68.             r: 10000000
    69.         },
    70.         e: {
    71.             c: 0,
    72.             r: 0
    73.         }
    74.     };
    75.     for (var R = 0; R != data.length; ++R) {
    76.         for (var C = 0; C != data[R].length; ++C) {
    77.             if (range.s.r > R) range.s.r = R;
    78.             if (range.s.c > C) range.s.c = C;
    79.             if (range.e.r < R) range.e.r = R;
    80.             if (range.e.c < C) range.e.c = C;
    81.             var cell = {
    82.                 v: data[R][C]
    83.             };
    84.             if (cell.v == null) continue;
    85.             var cell_ref = XLSXS.utils.encode_cell({
    86.                 c: C,
    87.                 r: R
    88.             });
    89.  
    90.             if (typeof cell.v === 'number') cell.t = 'n';
    91.             else if (typeof cell.v === 'boolean') cell.t = 'b';
    92.             else if (cell.v instanceof Date) {
    93.                 cell.t = 'n';
    94.                 cell.z = XLSX.SSF._table[14];
    95.                 cell.v = datenum(cell.v);
    96.             } 
    97.             else cell.t = 's';
    98.             ws[cell_ref] = cell;
    99.         }
    100.     }
    101.     if (range.s.c < 10000000) ws['!ref'] = XLSXS.utils.encode_range(range);
    102.     return ws;
    103. }
    104.  
    105. function Workbook() {
    106.     if (!(this instanceof Workbook)) return new Workbook();
    107.     this.SheetNames = [];
    108.     this.Sheets = {};
    109. }
    110.  
    111. function s2ab(s) {
    112.     var buf = new ArrayBuffer(s.length);
    113.     var view = new Uint8Array(buf);
    114.     for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;
    115.     return buf;
    116. }
    117.  
    118. export function export_table_to_excel(id) {
    119.     var theTable = document.getElementById(id);
    120.     var oo = generateArray(theTable);
    121.     var ranges = oo[1];
    122.  
    123.     /* original data */
    124.     var data = oo[0];
    125.     var ws_name = "SheetJS";
    126.  
    127.     var wb = new Workbook(),
    128.         ws = sheet_from_array_of_arrays(data);
    129.  
    130.     /* add ranges to worksheet */
    131.     // ws['!cols'] = ['apple', 'banan'];
    132.     ws['!merges'] = ranges;
    133.  
    134.     /* add worksheet to workbook */
    135.     wb.SheetNames.push(ws_name);
    136.     wb.Sheets[ws_name] = ws;
    137.  
    138.     var wbout = XLSX.write(wb, {
    139.         bookType: 'xlsx',
    140.         bookSST: false,
    141.         type: 'binary'
    142.     });
    143.  
    144.     saveAs(new Blob([s2ab(wbout)], {
    145.         type: "application/octet-stream"
    146.     }), "test.xlsx")
    147. }
    148. export function export_json_to_excel({
    149.     multiHeader2 = [], // 第一行表头
    150.     multiHeader = [], // 第二行表头
    151.     header, // 第三行表头
    152.     data,//传递的数据
    153.     filename, //文件名
    154.     merges = [], // 合并
    155.     autoWidth = true,//用于设置列宽的
    156.     bookType = 'xlsx'
    157. } = {}) {
    158.     /* original data */
    159.     filename = filename || '列表';
    160.     data = [...data]
    161.     data.unshift(header);
    162.     for (let i = multiHeader2.length - 1; i > -1; i--) {
    163.         data.unshift(multiHeader2[i])
    164.     }
    165.     for (let i = multiHeader.length - 1; i > -1; i--) {
    166.         data.unshift(multiHeader[i])
    167.     }
    168.     var ws_name = "SheetJS";
    169.     var wb = new Workbook(),
    170.         ws = sheet_from_array_of_arrays(data);
    171.     let borderAll = { //单元格外侧框线
    172.         top: {
    173.             style: 'thin',//表示用细框线
    174.         },
    175.         bottom: {
    176.             style: 'thin'
    177.         },
    178.         left: {
    179.             style: 'thin'
    180.         },
    181.         right: {
    182.             style: 'thin'
    183.         }
    184.     };
    185.     for (let key in ws) {
    186.         if (ws[key] instanceof Object) {
    187.             ws[key].s = {
    188.                 name:'宋体',
    189.                 border: borderAll,
    190.                 alignment: {
    191.                     horizontal: 'center', //水平居中对齐
    192.                     vertical: 'center',//垂直居中
    193.                     wrapText: 1,//自动换行
    194.                 },
    195.                 font: {
    196.                     sz: 10,//单元格中字体的样式与颜色设置
    197.                     color: {
    198.                         rgb: '495060'
    199.                     }
    200.                 },
    201.                 bold: true,
    202.                 numFmt: 0
    203.             }
    204.         }
    205.     }
    206.     let arr = ["A1", "B1", "C1", "D1", "E1", "F1", "G1", "H1", "I1", "J1", "K1", "L1", "M1", "N1", "O1", "P1", "Q1", "R1", "S1", "T1", "U1", "V1", "W1", "X1", "Y1", "Z1"];
    207.     let arr1 = ["A2", "B2", "C2", "D2", "E2", "F2", "G2", "H2", "I2", "J2", "K2", "L2", "M2", "N2", "O2", "P2", "Q2", "R2", "S2", "T2", "U2", "V2", "W2", "X2", "Y2", "Z2"];
    208.     arr.some(function (v) {//对单独的1  2 行进行样式修改，去掉框线，放大字体
    209.         let a = merges[0].split(':')
    210.         if (v == a[1]) {
    211.             ws[v].s.border = {}
    212.           return true;
    213.         }else {
    214.             ws[v].s.border = {}
    215.         }
    216.         ws[v].s.font= {
    217.             sz: 14,//单元格中字体的样式与颜色设置
    218.             color: {
    219.                 rgb: '495060'
    220.             },
    221.             bold: true,
    222.         }
    223.       })
    224.       arr1.some(function (v) {
    225.         if (ws[v]) {
    226.             ws[v].s.border = {}
    227.         }
    228.       })
    229.     if (merges.length > 0) {
    230.         if (!ws['!merges']) ws['!merges'] = [];
    231.         merges.forEach(item => {
    232.             ws['!merges'].push(XLSXS.utils.decode_range(item))
    233.         })
    234.     }
    235.     if (autoWidth) {
    236.         let colWidths = [];
    237.         // 计算每一列的所有单元格宽度
    238.         // 先遍历行
    239.         data.forEach((row) => {
    240.             // 列序号
    241.             let index = 0
    242.             // 遍历列
    243.             for (const key in row) {
    244.                 if (colWidths[index] == null) colWidths[index] = []
    245.                 switch (typeof row[key]) {
    246.                     case 'string':
    247.                     case 'number':
    248.                     case 'boolean':                     colWidths[index].push(getCellWidth(row[key]))
    249.                         break
    250.                     case 'object':
    251.                     case 'function':
    252.                         colWidths[index].push(0)
    253.                         break
    254.                 }
    255.                 index++
    256.             }
    257.         })
    258.         ws['!cols'] = [];
    259.         colWidths.forEach((widths, index) => {
    260.             // 计算列头的宽度
    261.             widths.push(getCellWidth(header[index]))
    262.             // 设置最大值为列宽
    263.             ws['!cols'].push({
    264.                 wch: Math.max(...widths)
    265.             })
    266.         })
    267.     }
    268.     /* add worksheet to workbook */
    269.     wb.SheetNames.push(ws_name);
    270.     wb.Sheets[ws_name] = ws;
    271.     var wbout = XLSXS.write(wb, {
    272.         bookType: bookType,
    273.         bookSST: false,
    274.         type: 'binary'
    275.     });
    276.     saveAs(new Blob([s2ab(wbout)], {
    277.         type: "application/octet-stream"
    278.     }), `${filename}.${bookType}`);
    279. }
    280. export function getCellWidth(value) {
    281.     if (value == null) {
    282.         return 10
    283.     } else if (value.toString().charCodeAt(0) > 255) {
    284.         // 判断是否包含中文
    285.         let length = value.toString().length * 2
    286.         if (length > 60) {
    287.             length = length - 40 
    288. //这里的宽度可以自己设定，在前面设置wrapText: 1可以在单元格内换行
    289.         }
    290.         return length
    291.     } else {
    292.         return value.toString().length * 1.2
    293.     }
    294. }

    若不需要操作样式，可将Export2Excel.js文件中的方法替换为如下

    1. // 对此方法进行修改，如下：
    2.  export function export_json_to_excel({
    3.      multiHeader2 = [],   // 第一行表头
    4.     multiHeader = [], // 第二行表头
    5.      header,  // 第三行表头
    6.      data,
    7.     filename, //文件名
    8.      merges = [], // 合并
    9.     autoWidth = true,
    10.      bookType = 'xlsx'
    11.  } = {}) {
    12.      /* original data */
    13.      filename = filename || '列表';
    14.      data = [...data]
    15.      data.unshift(header);
    16.  
    17.      for (let i = multiHeader2.length - 1; i > -1; i--) {
    18.          data.unshift(multiHeader2[i])
    19.      }
    20.  
    21.     for (let i = multiHeader.length - 1; i > -1; i--) {
    22.          data.unshift(multiHeader[i])
    23.      }
    24.  
    25.      var ws_name = "SheetJS";
    26.      var wb = new Workbook(),
    27.          ws = sheet_from_array_of_arrays(data);       
    28.     if (merges.length > 0) {
    29.          if (!ws['!merges']) ws['!merges'] = [];
    30.              merges.forEach(item => {
    31.             ws['!merges'].push(XLSX.utils.decode_range(item))
    32.         })
    33.     }
    34.  
    35.     if (autoWidth) {
    36.          /*设置worksheet每列的最大宽度*/
    37.          const colWidth = data.map(row => row.map(val => {
    38.         /*先判断是否为null/undefined*/
    39.              if (val == null) {
    40.                  return {
    41.                      'wch': 10
    42.                };
    43.            }
    44.              /*再判断是否为中文*/
    45.              else if (val.toString().charCodeAt(0) > 255) {
    46.                  return {
    47.                      'wch': val.toString().length * 2
    48.                  };
    49.              } else {
    50.                  return {
    51.                      'wch': val.toString().length
    52.                  };
    53.              }
    54.          }))
    55.          /*以第一行为初始值*/
    56.          let result = colWidth[0];
    57.          for (let i = 1; i < colWidth.length; i++) {
    58.              for (let j = 0; j < colWidth[i].length; j++) {
    59.                  if (result[j]['wch'] < colWidth[i][j]['wch']) {
    60.                  result[j]['wch'] = colWidth[i][j]['wch'];
    61.                  }
    62.              }
    63.          }
    64.          ws['!cols'] = result;
    65.      }
    66.  
    67.      /* add worksheet to workbook */
    68.      wb.SheetNames.push(ws_name);
    69.      wb.Sheets[ws_name] = ws;
    70.  
    71.      var wbout = XLSX.write(wb, {
    72.          bookType: bookType,
    73.          bookSST: false,
    74.         type: 'binary'
    75.      });
    76.      saveAs(new Blob([s2ab(wbout)], {
    77.          type: "application/octet-stream"
    78.      }), `${filename}.${bookType}`);
    79.  }

    3、页面中的使用，一些关键变量需要的格式贴在文章最后

    1.     //html部分
    3.             size="small"
    4.             icon="el-icon-download"
    5.             @click="exportDataEvent"
    6.             circle
    7.           >
    8.           
    9. //js部分
    10.     exportDataEvent() {
    11.       this.handleExportMarketingList(information,tableColumn);},
    12.  
    13. // 导出方法
    14.     handleExportMarketingList(information, optionColumnList) {
    15.       import("_b/pages/utils/vendor/Export2Excel.js").then((excel) => {//根据实际路径进行修改
    16.         let tHeader = [];
    17.         optionColumnList.forEach((ele) => {
    18.           tHeader.push(ele.title);
    19.         });
    20.         let multiHeader = [[]];
    21.         tHeader.forEach((ele, index) => {
    22.           index === 0
    23.             ? multiHeader[0].push("汇总表")
    24.             : multiHeader[0].push("");
    25.         });
    26.         let multiHeader2 = [[]];
    27.         tHeader.forEach((ele, index) => {
    28.           index === 0
    29.             ? multiHeader2[0].push(`名称：${this.proName}`)
    30.             : multiHeader2[0].push("");
    31.         });
    32.         multiHeader2[0].splice(
    33.           multiHeader2[0].length - 1,
    34.           1,
    35.           `编号：${this.proCode}`
    36.         );
    37.         const filterVal = optionColumnList;
    38.         let data = information.map((v) => filterVal.map((j) => v[j.field]));
    39.         const englishWordList = [
    40.           "A",
    41.           "B",
    42.           "C",
    43.           "D",
    44.           "E",
    45.           "F",
    46.           "G",
    47.           "H",
    48.           "I",
    49.           "J",
    50.           "K",
    51.           "L",
    52.           "M",
    53.           "N",
    54.           "O",
    55.           "P",
    56.           "Q",
    57.           "R",
    58.           "S",
    59.           "T",
    60.           "U",
    61.           "V",
    62.           "W",
    63.           "X",
    64.           "Y",
    65.           "Z",
    66.         ];
    67.         // 进行所有表头的单元格合并
    68.         let typeList = [];
    69.         data.forEach((ele) => {
    70.           typeList.push(ele[0]);
    71.         });
    72.         data = data.concat(this.footerDataList);
    73.         let merges = [
    74.           `A1:${englishWordList[tHeader.length - 1]}1`,
    75.           `A2:${englishWordList[tHeader.length - 2]}2`,
    76.         ];
    77.         for (let i = 1; merges.length < (data.length - 4) / 2 + 2; i += 2) {
    78.           merges.push(`A${3 + i}:A${4 + i}`);
    79.         }
    80.         merges.push(`A${data.length}:B${data.length}`);
    81.         merges.push(`A${data.length + 1}:B${data.length + 1}`);
    82.         merges.push(`A${data.length + 2}:B${data.length + 2}`);
    83.         merges.push(`A${data.length + 3}:B${data.length + 3}`);
    84.         excel.export_json_to_excel({
    85.           multiHeader,
    86.           multiHeader2,
    87.           header: tHeader,
    88.           data,
    89.           filename: "汇总",
    90.           merges,
    91.         });
    92.       });
    93.     },

     

     

     

  • 相关阅读:
    Linux的root用户
    C++题解(6) 信息学奥赛一本通：2069：【例2.12 】糖果游戏
    使用JAVA pdf转word
    翻车了，被读者找出 BUG
    Rocky linux8.8系统通过packstack安装OpenStack yoga版本
    文本变成文本路径图 保存txt
    Kubernetes学习大纲
    [elastic 8.x]java客户端连接elasticsearch与操作索引与文档
    Java：SpringBoot实现JDK动态代理和CGLIB动态代理
    蓝桥杯每日一题20223.9.26
  • 原文地址：https://blog.csdn.net/weixin_45294459/article/details/127107399