exportExcel(data) { if (data.length > 0) { const ws = XLSX.utils.json_to_sheet(data, { sheetStubs: true }); ws['!cols'] = this.fitToColumn(data); const wb = XLSX.utils.book_new(); XLSX.utils.book_append_sheet(wb, ws, 'Sheet1'); XLSX.writeFile(wb, `name.xlsx`); } else { Message({ message: '表格数据为空', type: 'error', center: true }); } }, fitToColumn(arrayOfArray) { let re=[] let keys={} Object.keys(arrayOfArray[0]).forEach((item,index) => {keys[item]=item.toString().length}) for (let i in arrayOfArray[0]){ let a=arrayOfArray.map(a2 => a2[i] ? a2[i].toString().length: 0) a.unshift(keys[i]) re.push(a) } return this.findMaxAtEachIndex(re) }, findMaxAtEachIndex(arr) { let maxNumbers = []; for
前端xlsx表格导出,宽度自适应简单版
最新推荐文章于 2024-03-25 17:08:46 发布