动态表格合并
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>table合计</title>
</head>
<body>
</body>
<style type="text/css">
table{
font-family: 黑体;
font-size: 14pt;
border-color:rgb(159,159,159);
border-collapse :collapse;
background-color:white;
border-width:1px;
align-content: center;
}
td{
width: 100px;
height: 32px;
text-align: center;
border-color:rgb(159,159,159);
border:gray 1px solid;
font-size:15px;
color:black;
}
#tabTh{
background-color: rgb(52,83,145);
border-color:rgb(172,172,172);
color:white;
font-size: 16px;
height: 38px;
}
#btnSum{margin:0px 1px 10px 0px;}
#btnRes{margin:0px 1px 10px 525px;}
</style>>
<script>
//一共四个步骤：第一步为将json字符串转化为二维数组；第二步为将二维数组转化为表格；第三步为合并相同单元格表格；第四步为添加合计行；
//第一步：将json字符串转化为二维数组
var jsonStr='{"table":[{"country":"China","year":"2014","city":"上海","grade":"高三","contestants":"192","winners":"7"},{"country":"China","year":"2014","city":"上海","grade":"高二","contestants":"267","winners":"11"},{"country":"China","year":"2014","city":"北京","grade":"高二","contestants":"255","winners":"12"},{"country":"China","year":"2014","city":"北京","grade":"高三","contestants":"254","winners":"23"},{"country":"China","year":"2015","city":"北京","grade":"高三","contestants":"259","winners":"18"},{"country":"China","year":"2015","city":"上海","grade":"高二","contestants":"262","winners":"19"},{"country":"China","year":"2016","city":"上海","grade":"高三","contestants":"268","winners":"22"},{"country":"China","year":"2016","city":"上海","grade":"高二","contestants":"218","winners":"18"},{"country":"China","year":"2016","city":"北京","grade":"高二","contestants":"261","winners":"17"},{"country":"China","year":"2016","city":"北京","grade":"高三","contestants":"255","winners":"16"}]}';
//利用JSON.parse()将字符串型转化为对象型
var jsonObj = JSON.parse(jsonStr);
console.log(jsonObj);
//将json对象数组转化为二维数组
var aArr = new Array();
var arr = new Array();
for (var i in jsonObj.table[0]){
aArr.push(i);
}
for (var i = 0; i < jsonObj.table.length; i++) {
arr[i] = new Array();
for (var j = 0; j < aArr.length; j++) {
arr[i][j] = jsonObj.table[i][aArr[j]];
}
};
arr.unshift(aArr);
console.log(arr);
// 第二步：将二维数组转化为表格
var table = document.createElement("table");
table.setAttribute("id","table");
var thead = document.createElement("tr");
for (var i = 0; i < arr[0].length; i++) {
var th = document.createElement("td");
th.setAttribute("id","tabTh");
th.innerText = arr[0][i];
thead.appendChild(th);
}
table.appendChild(thead);
for (var i = 1; i < arr.length; i++) {
var tr = document.createElement("tr");
for (var j = 0; j < arr[i].length; j++) {
var cell = document.createElement("td");
cell.setAttribute("id","td");
cell.innerText = arr[i][j];
tr.appendChild(cell);
}
table.appendChild(tr);
}
document.body.appendChild(table);
// 第三步：合并相同单元格
function checkArray(arr1,arr2){
for (var i = 0; i < arr1.length; i++) {
if (arr1[i].innerText===arr2[i].innerText) {
}else{
return false;
}
}
return true;
}
window.onload = function(){
var tb = document.getElementById("table");
var obj1;
var obj2;
var objtemp1 = [];
var objtemp2 = [];
var rowCount = tb.rows.length;
var colCount = tb.rows[0].cells.length;
var colLength = 4;
//命名(表头除外)
for (var i = 1; i < rowCount; i++) {
for (var j = 0; j < colCount; j++) {
tb.rows[i].cells[j].id = "tb_" + i.toString() + "_" + j.toString();
}
}
//从后往前检查，进行逐列检查合并,开始列为colLength-1
for (var col = colLength -1; col >= 0; col--) {
//当col>0时有前方的单元格
if (col > 0) {
//objtemp1为obj1左侧所有单元格集合，初始objtemp1及obj1均从第二行开始(tb_1_)
for (var l = 0; l < col; l++) {
objtemp1[l] = document.getElementById("tb_1_" + l.toString());
}
}
obj1 = document.getElementById("tb_1_" + col.toString());
//obj2为obj1下方单元格,obj1从第二行开始，则obj2从第三行开始，遍历以row=2为起始值
for (var row = 2; row < rowCount; row++) {
//同obj1及objtemp1，col>0：即有前方单元格，此时有objtemp2
if (col > 0) {
for (var l = 0; l < col; l++) {
objtemp2[l] = document.getElementById("tb_" + row.toString() +"_"+ l.toString());
}
}
obj2 = document.getElementById("tb_" + row.toString() +"_"+ col.toString());
//定义完obj1/obj2/objtemp1/objtemp2后，开始合并
//第一层判断：当obj1的值等于obj2时，即同一列的相邻单元格值相同
if (obj1.innerText == obj2.innerText) {
//第二层判断：obj1/obj2所在列前方还有其他列：即col>0(此步判断为单元格合并的依赖性提供支持)
if (col > 0) {
//第三层判断：obj1/obj2所在列前方还有其他列，且objtemp1,objtemp2值完全相同，可以合并
if (checkArray(objtemp1,objtemp2)) {
obj1.rowSpan++;
obj2.parentNode.removeChild(obj2);
}
//第三层判断：obj1/obj2所在列前方还有其他列，且objtemp1,objtemp2值不同，不可合并，并重新对obj1/objtemp1赋值，令其等于原来的obj2/objtemp2
else{
obj1 = document.getElementById("tb_" + row.toString() +"_"+ col.toString());
for (var l = 0; l < col; l++) {
objtemp1[l] = document.getElementById("tb_" + row.toString() +"_"+ l.toString());
}
}
}
//第二层判断：obj1/obj2所在列为首列，直接合并
else{
obj1.rowSpan++;
obj2.parentNode.removeChild(obj2);
}
}
//第一层判断：当obj1的值不等于obj2时，即同一列的相邻单元格值不相，此时重新对obj1/objtemp1赋值，令其等于原来的obj2/objtemp2
else{
obj1 = document.getElementById("tb_" + row.toString() +"_"+ col.toString());
for (var l = 0; l < col; l++) {
objtemp1[l] = document.getElementById("tb_" + row.toString() +"_"+ l.toString());
}
}
}
objtemp1 = [];
objtemp2 = [];
}
}
</script>
</html>
相关文章
