js json转excel

最新推荐文章于 2025-06-20 22:56:13 发布

a410147597

最新推荐文章于 2025-06-20 22:56:13 发布

阅读量2.6w

点赞数 1

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/nai_vee/article/details/48022841

这篇博客主要讲述了博主在寻找前端将JSON数据转换为Excel文件的过程中遇到的问题，包括尝试JSON转CSV但出现中文乱码的情况。最终，博主通过使用tableExport.jquery.plugin插件成功解决了问题，并分享了相关代码，以帮助他人避免走弯路。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

本人在网上查找前台json转excel。结果大多都是json转scv。（不知道google结果怎么样）

结果试了下导出之后用excel打开中文还是乱码。

最后还是参考tableExport.jquery.plugin插件完成。

减少别人走得弯路

上代码

<html>
<head>
	<meta http-equiv="content-type" content="text/html; charset=utf-8">
	<script type="text/javascript" src="jquery.min.js"></script>
	<script type="text/javascript">
		$(document).ready(function(){
		    $('#wwo').click(function(){
		        var data = {"title":[{"value":"集团", "type":"ROW_HEADER_HEADER", "datatype":"string"}, {"value":"日期", "type":"ROW_HEADER_HEADER", "datatype":"string"}],"data":[[{"value":"好好", "type":"ROW_HEADER"}, {"value":"2015-08-24", "type":"ROW_HEADER"}]]};
		        if(data == '')
		            return;
		        JSONToExcelConvertor(data.data, "Report", data.title);
		    });
		});

		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);
		}
	</script>
</head>
<body>
	<input type="button" id="wwo" value="导出" />
</body>
</html>

附件是tableExport代码

http://download.csdn.net/detail/a410147597/9052583