vue 本地xlsx文件下载_vue前端项目中excel文件下载

/*eslint-disable*/require('script-loader!file-saver');

import XLSX from'xlsx'

functiongenerateArray(table) {var out =[];var rows = table.querySelectorAll('tr');var ranges =[];for (var R = 0; R < rows.length; ++R) {var outRow =[];var row =rows[R];var columns = row.querySelectorAll('td');for (var C = 0; C < columns.length; ++C) {var cell =columns[C];var colspan = cell.getAttribute('colspan');var rowspan = cell.getAttribute('rowspan');var cellValue =cell.innerText;if (cellValue !== "" && cellValue == +cellValue) cellValue = +cellValue;//Skip ranges

ranges.forEach(function(range) {if (R >= range.s.r && R <= range.e.r && outRow.length >= range.s.c && outRow.length <=range.e.c) {for (var i = 0; i <= range.e.c - range.s.c; ++i) outRow.push(null);

}

});//Handle Row Span

if (rowspan ||colspan) {

rowspan= rowspan || 1;

colspan= colspan || 1;

ranges.push({

s: {

r: R,

c: outRow.length

},

e: {

r: R+ rowspan - 1,

c: outRow.length+ colspan - 1}

});

};//Handle Value

outRow.push(cellValue !== "" ? cellValue : null);//Handle Colspan

if(colspan)for (var k = 0; k < colspan - 1; ++k) outRow.push(null);

}

out.push(outRow);

}return[out, ranges];

};functiondatenum(v, date1904) {if (date1904) v += 1462;var epoch =Date.parse(v);return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000);

}functionsheet_from_array_of_arrays(data, opts) {var ws ={};var range ={

s: {

c:10000000,

r:10000000},

e: {

c:0,

r:0}

};for (var R = 0; R != data.length; ++R) {for (var C = 0; C != data[R].length; ++C) {if (range.s.r > R) range.s.r =R;if (range.s.c > C) range.s.c =C;if (range.e.r < R) range.e.r =R;if (range.e.c < C) range.e.c =C;var cell ={

v: data[R][C]

};if (cell.v == null) continue;var cell_ref =XLSX.utils.encode_cell({

c: C,

r: R

});if (typeof cell.v === 'number') cell.t = 'n';else if (typeof cell.v === 'boolean') cell.t = 'b';else if (cell.v instanceofDate) {

cell.t= 'n';

cell.z= XLSX.SSF._table[14];

cell.v=datenum(cell.v);

}else cell.t = 's';

ws[cell_ref]=cell;

}

}if (range.s.c < 10000000) ws['!ref'] =XLSX.utils.encode_range(range);returnws;

}functionWorkbook() {if (!(this instanceof Workbook)) return newWorkbook();this.SheetNames =[];this.Sheets ={};

}functions2ab(s) {var buf = newArrayBuffer(s.length);var view = newUint8Array(buf);for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;returnbuf;

}

exportfunctionexport_table_to_excel(id) {var theTable =document.getElementById(id);var oo =generateArray(theTable);var ranges = oo[1];/*original data*/

var data = oo[0];var ws_name = "SheetJS";var wb = newWorkbook(),

ws=sheet_from_array_of_arrays(data);/*add ranges to worksheet*/

//ws['!cols'] = ['apple', 'banan'];

ws['!merges'] =ranges;/*add worksheet to workbook*/wb.SheetNames.push(ws_name);

wb.Sheets[ws_name]=ws;var wbout =XLSX.write(wb, {

bookType:'xlsx',

bookSST:false,

type:'binary'});

saveAs(newBlob([s2ab(wbout)], {

type:"application/octet-stream"}),"test.xlsx")

}

exportfunctionexport_json_to_excel({

header,

data,

filename,

autoWidth= true,

bookType= 'xlsx'}={}) {/*original data*/filename= filename || 'excel-list'data=[...data]

data.unshift(header);var ws_name = "SheetJS";var wb = newWorkbook(),

ws=sheet_from_array_of_arrays(data);if(autoWidth) {/*设置worksheet每列的最大宽度*/const colWidth= data.map(row => row.map(val =>{/*先判断是否为null/undefined*/

if (val == null) {return{'wch': 10};

}/*再判断是否为中文*/

else if (val.toString().charCodeAt(0) > 255) {return{'wch': val.toString().length * 2};

}else{return{'wch': val.toString().length

};

}

}))/*以第一行为初始值*/let result= colWidth[0];for (let i = 1; i < colWidth.length; i++) {for (let j = 0; j < colWidth[i].length; j++) {if (result[j]['wch'] < colWidth[i][j]['wch']) {

result[j]['wch'] = colWidth[i][j]['wch'];

}

}

}

ws['!cols'] =result;

}/*add worksheet to workbook*/wb.SheetNames.push(ws_name);

wb.Sheets[ws_name]=ws;var wbout =XLSX.write(wb, {

bookType: bookType,

bookSST:false,

type:'binary'});

saveAs(newBlob([s2ab(wbout)], {

type:"application/octet-stream"}), `${filename}.${bookType}`);

}