JavaScript 导出 xls_js生成xls

作者：小惠珠哦 | 2024-06-29 21:46:02

踩

js生成xls

引入js

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

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);
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68

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);
	})
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91

在这里插入图片描述

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小惠珠哦/article/detail/770405