1.下载 iview
iview 官网
2.下载xlsx npm install xlsx --save
3.创建excel.js 工具文件 (在utils 文件夹下)
import XLSX from 'xlsx';
function auto_width(ws, data){
const colWidth = data.map(row => row.map(val => {
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;
}
function json_to_array(key, jsonData){
return jsonData.map(v => key.map(j => {
return v