把html表格中数据转化为数据
function tableInfo(id) {//把页面的表转为两维数组var tr_s = $("tr", $("#grideData"));//grideData是表格的id
var col_length = 0;
var rows = $("td,th", $(tr_s));
$.each(rows, function (i, n) {
if ($(n).attr("colspan") == null) {
col_length++;
} else {
col_length = parseInt(col_length) + parseInt($(n).attr("colspan"));
}
});
var table_array = new Array();
for (var i = 0; i < tr_s.length; i++) {
var col_array = new Array();
for (var j = 0; j < col_length; j++) {
col_array.push("#");
}
table_array.push(col_array);
}
for (var i = 0; i < tr_s.length; i++) {
var rows = $("td,th", $(tr_s));
for (j = 0; j < rows.length; j++) {
var col_num = $(rows).attr("colspan");
var row_num = $(rows).attr("rowspan");
if (col_num != null || row_num > 1) {
if (col_num != null) {
var count = parseInt(col_num);
for (var c = j; c < (j + count); c++) {
if (table_array == "#") {
table_array = $.trim($(rows).text());
} else {
for (var h = j; h < table_array.length; h++) {
if (table_array != "#") {
continue;
}
if ($.trim($(rows).text()) != "%") {
table_array = $.trim($(rows).text());
} else {
table_array = $.trim($(rows).text()) + "%";
}
break;
}
}
}
}
if (row_num > 1) {
var count = parseInt(row_num);
for (var c = i; c < (i + count); c++) {
if (table_array == "#") {
table_array = $.trim($(rows).text());
}
}
}
} else {
if (table_array == "#") {
if ($.trim($(rows).text()) != "%") {
table_array = $.trim($(rows).text());
} else {
table_array = $.trim($(rows).text()) + "%";
}
} else {
for (var h = j; h < table_array.length; h++) {
if (table_array != "#") {
continue;
}
if ($.trim($(rows).text()) != "%") {
table_array = $.trim($(rows).text());
} else {
table_array = $.trim($(rows).text()) + "%";
}
break;
}
}
}
}
}
return table_array;
}
function changArray(array) {//数组x轴和y轴对换
var arrays = [];
for (var i = 0; i < array.length; i++) {
for (var j = 0; j < array.length; j++) {
arrays = array;
}
}
return arrays;
}
function getArrayByTitle(titles, tableInfo, type, types) {//根据文本计算数据下标
var str = "{";
if (types == 1) {//左边有全拼行的情况下
tableInfo = changArray(tableInfo);
}
if (type == "col") {
for (var j = 0; j < titles.length; j++) {
str += "\"" + titles + "\":[";
for (var i = 0; i < tableInfo.length; i++) {
if ($.trim(titles) == $.trim(tableInfo)) {
str += i + ",";
}
}
str = str.substring(0, str.length - 1);
str += "],";
}
str = str.substring(0, str.length - 1);
str += "}";
} else {
if (type == "row") {
for (var j = 0; j < titles.length; j++) {
str += "\"" + titles + "\":[";
for (var i = 0; i < tableInfo.length; i++) {
if ($.trim(titles) == $.trim(tableInfo)) {
str += i + ",";
}
}
str = str.substring(0, str.length - 1);
str += "],";
}
str = str.substring(0, str.length - 1);
str += "}";
}
}
return str;
}
页:
[1]