纯记录文章--前端表格导出

export const downloadExl = (COLUMNS, tableData, title) => {
	const data = []; // 下载的二维数组数据
	let dataChild = []; // 子数组数据
	const labels = []; // 表头标签
	const props = []; // 表头属性

	COLUMNS.map(item => {
		labels.push(item.title);
		props.push(item.dataIndex);
	});
	data.push(labels);

	tableData.map(item => {
		dataChild = [];
		props.map(itemChild => {
			dataChild.push(item[itemChild]);
		});
		data.push(dataChild);
	});
	const xlsTitle = title ? title : '驾校活跃报表';
	const filename = xlsTitle + '.xlsx';
	const wb = XLSX.utils.book_new(),
		ws = XLSX.utils.aoa_to_sheet(data);
	XLSX.utils.book_append_sheet(wb, ws, filename); //将数据添加到工作薄
	XLSX.writeFile(wb, filename); //导出Excel
};

调用 downloadExl(COLUMNS, data, '学员录入数据');