uniapp生成excel,uniapp导出excel,微信小程序生成excel,微信小程序导出excel-爱代码爱编程
需求:根据后端返回的数据,由前端独自生成并导出excel
下载excel.js:点击去下载
提取码:1234
import * as XLSX from "@/static/excel.js";
onExpot() {
//文件名
const fileName='订单数据';
//需要导出的字段
const header = ['goodsName', 'price', 'date','orderNo'];
//excel头部名称,字段对应名称
const headerName = { goodsName: '商品名称', date: '日期', price: '价格',orderNo:"订单编号" };
//后台数据
const ExcelData = [
{date:'2022-02-02',price: '999',goodsName:'钓鱼竿',orderNo:"123456789"},
{date:'2022-02-03',price: '888',goodsName:'路亚', orderNo:"987654321"}
]
XLSX.excel_exprot(ExcelData, header, headerName,fileName)
}
最终导出样式