js-xlsx 读取和导出excel的工具库

npm install xlsx

data : [] //导出的数据二维数组
header:[] //对应的header api
headerName:[] //导出的列标题
name:'name.xlsx'//导出的文件名称

　　

import * as XLSX from 'xlsx';
export const exportData = (data,header,headerName,name)=>{
	let arrAll = [];
	data.forEach(item=>{
		let arr = [];
		header.forEach(item1=>{
			let singleData = ''
			for (let i in item) {
				if (item1 == i) {
					
				} else {
					singleData = item[item1]
				}
			}
			arr.push(singleData)
		})
		arrAll.push(arr)
	})
	
	const workbook = XLSX.utils.book_new();
	const sheetName = 'Sheet1'
	const sheetData = [headerName,...arrAll]
	const worksheet = XLSX.utils.aoa_to_sheet(sheetData)

	XLSX.utils.book_append_sheet(workbook,worksheet,sheetName)
	XLSX.writeFile(workbook,name)
}