JS创建简单Excel文件_js xlsx创建excel-CSDN博客

本文链接：https://blog.csdn.net/liyichuanZhengzhou/article/details/133467469

function getExcelFileTemplate(tableRows, excelWorkbookName){return multilineString(function(){/*<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8" />
<head>
<!--[if gte mso 9]>
<xml>
	<x:ExcelWorkbook>
		<x:ExcelWorksheets>
			<x:ExcelWorksheet>
				<x:Name>{excelWorkbookName}</x:Name>
				<x:WorksheetOptions>
					<x:DisplayGridlines/>
				</x:WorksheetOptions>
			</x:ExcelWorksheet>
		</x:ExcelWorksheets>
	</x:ExcelWorkbook>
</xml>
<![endif]-->
</head>
<body>
<table>{tableRows}</table>
</body>
</html>*/}).replace('{excelWorkbookName}',excelWorkbookName||'sheet1').replace('{tableRows}',tableRows);
}

function donwdeom_click(sef){ // excelFile
	// window.usestrictfield=[[1,4,3,2],[11,11,11,11],['姓名','AAA','工种A','性别'],[1,0,1,1],[1,0,1,0]];
	var tableRows = function(){
			var i, names = window.usestrictfield[2], tr = [];
			for (var i = 0; i < 3; i++) {
				tr.push('<tr>');
				for (var j = 0; j < names.length; j++) {
					var name = names[j];
					if (i > 0) {
						name = '这里输入【'+name+'】值'+i;
					}
					tr.push('<td>'+name+'</td>');
				}
				tr.push('</tr>');
			}
			return tr.join('');
		}
		, a = document.createElement('a')
		, excelWorkbookName = '请严格按照字段模板排序格式导入'
	;
	a.href = 'data:application/vnd.ms-excel;charset=utf-8,'+encodeURIComponent(getExcelFileTemplate(tableRows(''),excelWorkbookName));
	a.download = '批量导入Excel数据格式.xls';
	a.click();
	document.body.appendChild(a);
	document.body.removeChild(a);
}