JSON解析
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];
if(typeof(o) == "object"){
if(o.hasOwnProperty("v")){
console.log(o.v);
}
}
}