image.png
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<script>
var json ={
"A2" : {
"w" : "101",
"v" : 101,
"t" : "n"
},
"A1" : {
"w" : " id",
"v" : " id",
"t" : "s",
"r" : "<t xml:space=\"preserve\"> id</t><phoneticPr fontId=\"1\" type=\"noConversion\"/>",
"h" : " id"
},
"A4" : {
"w" : "103",
"v" : 103,
"t" : "n"
},
"A3" : {
"w" : "102",
"v" : 102,
"t" : "n"
},
"A6" : {
"w" : "105",
"v" : 105,
"t" : "n"
},
"A5" : {
"w" : "104",
"v" : 104,
"t" : "n"
},
"A8" : {
"w" : "107",
"v" : 107,
"t" : "n"
},
"A7" : {
"w" : "106",
"v" : 106,
"t" : "n"
},
"A9" : {
"w" : "108",
"v" : 108,
"t" : "n"
},
"C16" : {
"w" : "1500",
"v" : 1500,
"t" : "n"
},
"B5" : {
"w" : "4",
"v" : 4,
"t" : "n"
},
"C17" : {
"w" : "1600",
"v" : 1600,
"t" : "n"
},
"B4" : {
"w" : "3",
"v" : 3,
"t" : "n"
},
"B3" : {
"w" : "2",
"v" : 2,
"t" : "n"
},
"B2" : {
"w" : "1",
"v" : 1,
"t" : "n"
},
"B9" : {
"w" : "8",
"v" : 8,
"t" : "n"
},
"B8" : {
"w" : "7",
"v" : 7,
"t" : "n"
},
"B7" : {
"w" : "6",
"v" : 6,
"t" : "n"
},
"B6" : {
"w" : "5",
"v" : 5,
"t" : "n"
},
"C10" : {
"w" : "900",
"v" : 900,
"t" : "n"
},
"C11" : {
"w" : "1000",
"v" : 1000,
"t" : "n"
},
"C12" : {
"w" : "1100",
"v" : 1100,
"t" : "n"
},
"C13" : {
"w" : "1200",
"v" : 1200,
"t" : "n"
},
"C14" : {
"w" : "1300",
"v" : 1300,
"t" : "n"
},
"C15" : {
"w" : "1400",
"v" : 1400,
"t" : "n"
},
"!ref" : "A1:D17",
"B1" : {
"w" : " 数量",
"v" : " 数量",
"t" : "s",
"r" : "<t xml:space=\"preserve\"> 数量</t><phoneticPr fontId=\"1\" type=\"noConversion\"/>",
"h" : " 数量"
},
"C8" : {
"w" : "700",
"v" : 700,
"t" : "n"
},
"C7" : {
"w" : "600",
"v" : 600,
"t" : "n"
},
"B17" : {
"w" : "16",
"v" : 16,
"t" : "n"
},
"C9" : {
"w" : "800",
"v" : 800,
"t" : "n"
},
"C4" : {
"w" : "300",
"v" : 300,
"t" : "n"
},
"C3" : {
"w" : "200",
"v" : 200,
"t" : "n"
},
"C6" : {
"w" : "500",
"v" : 500,
"t" : "n"
},
"C5" : {
"w" : "400",
"v" : 400,
"t" : "n"
},
"B11" : {
"w" : "10",
"v" : 10,
"t" : "n"
},
"B12" : {
"w" : "11",
"v" : 11,
"t" : "n"
},
"B10" : {
"w" : "9",
"v" : 9,
"t" : "n"
},
"B15" : {
"w" : "14",
"v" : 14,
"t" : "n"
},
"B16" : {
"w" : "15",
"v" : 15,
"t" : "n"
},
"B13" : {
"w" : "12",
"v" : 12,
"t" : "n"
},
"B14" : {
"w" : "13",
"v" : 13,
"t" : "n"
},
"C1" : {
"w" : " 总价",
"v" : " 总价",
"t" : "s",
"r" : "<t xml:space=\"preserve\"> 总价</t><phoneticPr fontId=\"1\" type=\"noConversion\"/>",
"h" : " 总价"
},
"C2" : {
"w" : "100",
"v" : 100,
"t" : "n"
},
"A11" : {
"w" : "102",
"v" : 102,
"t" : "n"
},
"A10" : {
"w" : "101",
"v" : 101,
"t" : "n"
},
"A13" : {
"w" : "104",
"v" : 104,
"t" : "n"
},
"A12" : {
"w" : "103",
"v" : 103,
"t" : "n"
},
"D1" : {
"w" : " 修改",
"v" : " 修改",
"t" : "s",
"r" : "<t xml:space=\"preserve\"> 修改</t><phoneticPr fontId=\"1\" type=\"noConversion\"/>",
"h" : " 修改"
},
"A15" : {
"w" : "106",
"v" : 106,
"t" : "n"
},
"A14" : {
"w" : "105",
"v" : 105,
"t" : "n"
},
"A17" : {
"w" : "108",
"v" : 108,
"t" : "n"
},
"A16" : {
"w" : "107",
"v" : 107,
"t" : "n"
}
};
for(var i in json){
var o = json[i];
console.log(i)
if(typeof(o) == "object"){
if(o.hasOwnProperty("o")){
console.log(o);
}
}
}
</script>
</body>
</html>
解析json数组即对JSONArray的遍历
一、对于标准的json数组如:
var result=[{"flag":1,"macId":"2","mbId":0,"userName":"XXX"},{"flag":1,"macId":"1","mbId":1,"userName":"YYY"}];
进行遍历的时候，可以直接通过for循环遍历这个数组，有两种方法
for (var i = 0; i < result.length; i++) {
//result[i]表示获得第i个json对象即JSONObject
//result[i]通过.字段名称即可获得指定字段的值
result[i].userName;
}
for(var i in result){
//表示遍历数组，而i表示的是数组的下标值，
//result[i]表示获得第i个json对象即JSONObject
//result[i]通过.字段名称即可获得指定字段的值
result[i].userName;
}
二、对于不标准的json数组如:
var result={"datas":[{"flag":1,"macId":"2","mbId":0,"userName":"XXX"},{"flag":1,"macId":"1","mbId":1,"userName":"YYY"}]};
进行遍历之前得先解析出标准的json数组格式即[{},{}]
var data= result.datas;
for (var i = 0; i < data.length; i++) {
//data[i]表示获得第i个json对象即JSONObject
//data[i]通过.字段名称即可获得指定字段的值
data[i].userName;
}
for(var i in data){
//表示遍历数组，而i表示的是数组的下标值，
//data[i]表示获得第i个json对象即JSONObject
//data[i]通过.字段名称即可获得指定字段的值
data[i].userName;
}
/************04*******************/
var data = {"tableContent":[
{"id":1880,"fin_date":"1385856000",
"fin_total_asset":"112050665.66",
"fin_accounts_receivable":"49063408.85",
"fin_inventory":"40939952.09",
"fin_total_debt":"54458137.58",
"fin_only_profit":"54458137.58"}]
}
var control = data.tableContent;
for(var i in control[0]){
if(control[0].hasOwnProperty(i)) {
console.log(i,":",control[0][i]);
}
};
