前端使用XLSX实现Excel导入导出

Excel导出

let excelData = [["基站名称","基站地址","归属地市","归属区县","类型","经度","维度","lac",],["测试基站","测试地址","测试地市","测试区县","测试类型","测试经度","测试维度","测试lac",],];let workSheet = XLSX.utils.aoa_to_sheet(excelData);let bookNew = XLSX.utils.book_new();XLSX.utils.book_append_sheet(bookNew, workSheet, "模板"); // 工作簿名称let name = "模板" + ".xlsx";XLSX.writeFile(bookNew, name); // 保存的文件名

Excel导入

let file = ev.raw;if (!file) return;if (file) {const reader = new FileReader();reader.onload = (evt) => {const data = evt.target.result;const workbook = XLSX.read(data, { type: "binary" }); // 读取Excel文件内容const sheetName = workbook.SheetNames[0]; // 读取第一个表const worksheet = workbook.Sheets[sheetName];const excelData = XLSX.utils.sheet_to_json(worksheet); // 将工作表数据转换为JSON数组console.log(excelData);this.cloneTableData = JSON.parse(JSON.stringify(excelData));this.tableData = this.cloneTableData.slice((this.currentPage - 1) * this.pageSize,this.currentPage * this.pageSize);};reader.readAsBinaryString(file);}