JavaScript 导出 xls

最新推荐文章于 2023-07-22 12:02:29 发布

生生不息的希望

最新推荐文章于 2023-07-22 12:02:29 发布

阅读量402

点赞数

本文链接：https://blog.csdn.net/weixin_39589065/article/details/89253287

版权

引入js

引入：
<script src="../js/json2excel.js" type="text/javascript" charset="utf-8"></script>

json2excel.js 插件代码

function JSONToExcelConvertor(JSONData, FileName, ShowLabel) {
	//先转化json  
	var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;

	var excel = '<table>';

	//设置表头  
	var row = "<tr>";
	for(var i = 0, l = ShowLabel.length; i < l; i++) {
		row += "<td>" + ShowLabel[i].value + '</td>';
	}

	//换行  
	excel += row + "</tr>";

	//设置数据  
	for(var i = 0; i < arrData.length; i++) {
		var row = "<tr>";

		for(var index in arrData[i]) {
			var value = arrData[i][index].value === "." ? "" : arrData[i][index].value;
			row += '<td>' + value + '</td>';
		}

		excel += row + "</tr>";
	}

	excel += "</table>";

	var excelFile = "<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'>";
	excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
	excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel';
	excelFile += '; charset=UTF-8">';
	excelFile += "<head>";
	excelFile += "<!--[if gte mso 9]>";
	excelFile += "<xml>";
	excelFile += "<x:ExcelWorkbook>";
	excelFile += "<x:ExcelWorksheets>";
	excelFile += "<x:ExcelWorksheet>";
	excelFile += "<x:Name>";
	excelFile += "{worksheet}";
	excelFile += "</x:Name>";
	excelFile += "<x:WorksheetOptions>";
	excelFile += "<x:DisplayGridlines/>";
	excelFile += "</x:WorksheetOptions>";
	excelFile += "</x:ExcelWorksheet>";
	excelFile += "</x:ExcelWorksheets>";
	excelFile += "</x:ExcelWorkbook>";
	excelFile += "</xml>";
	excelFile += "<![endif]-->";
	excelFile += "</head>";
	excelFile += "<body>";
	excelFile += excel;
	excelFile += "</body>";
	excelFile += "</html>";

	var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile);

	var link = document.createElement("a");
	link.href = uri;

	link.style = "visibility:hidden";
	link.download = FileName + ".xls";

	document.body.appendChild(link);
	link.click();
	document.body.removeChild(link);
}

h5 页面就不写了，下面是执行代码

	var export_conte = [ //  表格数据。
		[{
				"value": "预约类型",
				"type": "ROW_HEADER",
			},
			{
				"value": "商品",
				"type": "ROW_HEADER",

			},
			{
				"value": "时间",
				"type": "ROW_HEADER",

			},
			{
				"value": "价格",
				"type": "ROW_HEADER",

			},
			{
				"value": "会员名",
				"type": "ROW_HEADER",

			},
			{
				"value": "预约号码",
				"type": "ROW_HEADER",

			},
			{
				"value": "会员号码",
				"type": "ROW_HEADER",

			},
			{
				"value": "推荐人",
				"type": "ROW_HEADER",

			}
		]
	]

	$("#export").click(function() {
		var data = {
			"title": [{  //表头设置
					"value": "预约类型",
					"type": "ROW_HEADER_HEADER",
					"datatype": "string"
				},
				{
					"value": "商品",
					"type": "ROW_HEADER_HEADER",
					"datatype": "string"
				},
				{
					"value": "时间",
					"type": "ROW_HEADER_HEADER",
					"datatype": "string"
				},
				{
					"value": "价格",
					"type": "ROW_HEADER_HEADER",
					"datatype": "string"
				},
				{
					"value": "会员名",
					"type": "ROW_HEADER_HEADER",
					"datatype": "string"
				},
				{
					"value": "预约号码",
					"type": "ROW_HEADER_HEADER",
					"datatype": "string"
				},
				{
					"value": "会员号码",
					"type": "ROW_HEADER_HEADER",
					"datatype": "string"
				},
				{
					"value": "推荐人",
					"type": "ROW_HEADER_HEADER",
					"datatype": "string"
				}
			],

			"data": export_conte
		}; 
		JSONToExcelConvertor(data.data, "Report", data.title);
	})

在这里插入图片描述

生生不息的希望

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
JavaScript 导出 xls

引入js引入：<script src="../js/json2excel.js" type="text/javascript" charset="utf-8"></script>json2excel.js 插件代码function JSONToExcelConvertor(JSONData, FileName, ShowLabel) { //先转化json ...
复制链接

扫一扫