导出Excel

最新推荐文章于 2023-07-27 23:39:49 发布

优秀的麒麟

最新推荐文章于 2023-07-27 23:39:49 发布

阅读量180

点赞数

分类专栏：前端开发 java开发文章标签： java javascript jquery 前端

本文链接：https://blog.csdn.net/qq_44102963/article/details/121991971

版权

java开发同时被 2 个专栏收录

14 篇文章 3 订阅

订阅专栏

前端开发

4 篇文章 0 订阅

订阅专栏

jsp生成Excel表格

字符串转化成数组

function string2Array(stringObj){
	stringObj = stringObj.replace(/\[([\w, ]*)\]/,"$1");
	if(stringObj.indexOf("[") == 0){
		stringObj = stringObj.substring(1,stringObj.length-1);
	}
	var arr = stringObj.split(",");
	var newArray =[];
	for(var i=0;i<arr.length;i++){
		var arrOne = arr[i];
		newArray.push(arrOne);
	}
	return newArray;
}

设置表格头

function setKeys(array){
	var keyMap = {id:'姓名'...}
	for(var i =0;i<array.length;i++){
		var obj = array[i];
		for(var key in obj){
			var newKey = keyMap[key];
			if(newKey){
				obj[newKey] = obj[key];
				delete obj[key];
			}
		}
	}
	return array;
}

添加表格数据

function JSONToExcelConvertor(JSONData,FileName){
	//先转化json
	var arrData = typeof JSONData != 'object'? JSON.parse(JSONData):JSONData;
	var excel ='<table>';
	var row='<tr>';
	//设置表头
	var keys = Object.keys(JSONData[0]);
	keys.forEach(function (item){
		row += "<td>"+item+'</td>';
		});
		//换行
		excel +=row+"</tr>";
		//设置数据
		for(var i =0;i<arrData.length;i++){
			var row ="<tr>";
			for(var index in arrData[i]){
			row +='<td>'+arrData[i][index]+'</td>';
			}
			excel +=row+"</tr>";
		}
		excel += "</table>";
		var excelFile = "<html xmins:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='htp://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:WoksheetOptions>";
excelFile +="<x:DisplayGridlines/>";
excelFile +="</x:WoksheetOptions>";
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.removenChild(link);
}

优秀的麒麟

关注

0
点赞
踩
0

收藏

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

jsp生成Excel表格字符串转化成数组function string2Array(stringObj){ stringObj = stringObj.replace(/\[([\w, ]*)\]/,"$1"); if(stringObj.indexOf("[") == 0){ stringObj = stringObj.substring(1,stringObj.length-1); } var arr = stringObj.split(","); var newArray =[];
复制链接

扫一扫