模仿 https://github.com/PanJiaChen/vue-element-admin/ 的下载
创建文件夹vendor 创建文件 Export2Excel.js
内容:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 | /* eslint-disable */ require( 'script-loader!file-saver' ); import XLSX from 'xlsx' function generateArray(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]; }; function datenum(v, date1904) { if (date1904) v += 1462; var epoch = Date.parse(v); return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000); } function sheet_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 instanceof Date) { 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); return ws; } function Workbook() { if (!( this instanceof Workbook)) return new Workbook(); this .SheetNames = []; this .Sheets = {}; } function s2ab(s) { var buf = new ArrayBuffer(s.length); var view = new Uint8Array(buf); for ( var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF; return buf; } export function export_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 = new Workbook(), 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( new Blob([s2ab(wbout)], { type: "application/octet-stream" }), "test.xlsx" ) } export function export_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 = new Workbook(), 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( new Blob([s2ab(wbout)], { type: "application/octet-stream" }), `${filename}.${bookType}`); } |
安装包 "xlsx": "^0.11.16"
"file-saver": "^2.0.0",
"script-loader": "^0.7.2",
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | onClickBtnExportX(datas){ let that = this ; if (!datas|| datas.length<=0) { that.$message( '请先选择要导出的数据!' ) return } import ( '@/vendor/Export2Excel' ).then(excel => { const tHeader = [ '进口报关单号' , '报关单号' , '报关编号' , '类型名称' , '车队系统名称' , '车身编号' , '发动机号码' , '后备发动机号码' , '数量' , '报关日期' , '运输公司' , '单据日期' , '货品类型编号' , '经办人' , '审核状态' , '运输方式' ]; const filterVal = [ 'customsOrderNum' , 'customsOrderNum' , 'customsClearCode' , 'type' , 'fleetSystemName' , 'carBodyNum' , 'engineNum' , 'backupEngineNum' , 'account' , 'customsClearDate' , 'tranCompany' , 'listDate' , 'typeCode' , 'manager' , 'orderStatus' , 'transMode' ]; const fileName = parseTime( new Date(), '{y}-{m}-{d}' )+ "_" + datas[0].customsOrderNum; const data = this .formatJson(filterVal, datas) excel.export_json_to_excel({ header: tHeader, data, filename: fileName }) }) }, formatJson(filterVal, jsonData) { return jsonData.map(v => filterVal.map(j => { if (j === 'customsClearDate' || j === 'listDate' ) { return parseTime(v[j]) } else if (j === 'orderStatus' ){ debugger if (v[j]=== true ) { v[j]= "审批通过" ; } else if (v[j]=== false ){ v[j]= "审批不通过" ; } else { v[j]= "未审批" ; } return v[j] } else { return v[j] } })) }, |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步