小弟做了个javascript导入excel数据。我是直接打分excel导入的。刚开始到入得时候每一列都是有值的。但是到最后我设了一个样式。其中一列值就不见了。这是我代码。那位大虾帮忙解决一下。急啊!!var j = 4;
var eeName = "";
for (var i = 0; i < json.length; i++) {
oSheet.Cells(j, 1).value = i.toString();
oSheet.Cells(j, 2).value = json[i].unitName;
var orgName = "";
if (json[i].cellName != null) {
oSheet.Cells(j, 3).value = json[i].cellName;
orgName = json[i].cellName;
}
else if (json[i].deptName != null) {
oSheet.Cells(j, 3).value = json[i].deptName;
orgName = json[i].deptName;
}
else {
oSheet.Cells(j, 3).value = json[i].unitName;
orgName = json[i].unitName;
}
oSheet.Cells(j, 4).value = json[i].eeType;
if (json[i].eeType == "机构") {
oSheet.Cells(j, 5).value = orgName;
}
else {
oSheet.Cells(j, 5).value = json[i].eeName;
}
oSheet.Cells(j, 6).value = json[i].re;
oSheet.Cells(j, 7).value = json[i].erName;
oSheet.Cells(j, 8).value = json[i].WT_PSNF == null ? "" : json[i].WT_PSNF + "%";
oSheet.Cells(j, 9).value = json[i].ASPECT_NAME;
oSheet.Cells(j, 10).value = json[i].WT_ASP == null ? "" : json[i].WT_ASP + "%";
oSheet.Cells(j, 11).value = json[i].ASPECT_ITEM_NAME;
oSheet.Cells(j, 12).value = json[i].WT_ASP_IT == null ? "" : json[i].WT_ASP_IT + "%";
oSheet.Cells(j, 13).value = json[i].SCORE;
oSheet.Cells(j, 14).value = json[i].ITEM_SCORE;
oSheet.Cells(j, 15).value = json[i].ASP_SCORE;
if (eeName != json[i].eeName) {
oSheet.Cells(j, 16).value = json[i].FINALSCORE;
eeName = json[i].eeName;
}
j++;
}
xls.Range("A1:P" + (j - 1)).select;
xls.Selection.Borders.LineStyle = 1;
xls.Range("A1:P" + (j - 1)).HorizontalAlignment = 3;
xls.Range("A1:P" + (j - 1)).VerticalAlignment = 3; xls.Range("A3:P3").WrapText = true;
xls.Range("A2:P2").HorizontalAlignment = 2;
var eeName = "";
for (var i = 0; i < json.length; i++) {
oSheet.Cells(j, 1).value = i.toString();
oSheet.Cells(j, 2).value = json[i].unitName;
var orgName = "";
if (json[i].cellName != null) {
oSheet.Cells(j, 3).value = json[i].cellName;
orgName = json[i].cellName;
}
else if (json[i].deptName != null) {
oSheet.Cells(j, 3).value = json[i].deptName;
orgName = json[i].deptName;
}
else {
oSheet.Cells(j, 3).value = json[i].unitName;
orgName = json[i].unitName;
}
oSheet.Cells(j, 4).value = json[i].eeType;
if (json[i].eeType == "机构") {
oSheet.Cells(j, 5).value = orgName;
}
else {
oSheet.Cells(j, 5).value = json[i].eeName;
}
oSheet.Cells(j, 6).value = json[i].re;
oSheet.Cells(j, 7).value = json[i].erName;
oSheet.Cells(j, 8).value = json[i].WT_PSNF == null ? "" : json[i].WT_PSNF + "%";
oSheet.Cells(j, 9).value = json[i].ASPECT_NAME;
oSheet.Cells(j, 10).value = json[i].WT_ASP == null ? "" : json[i].WT_ASP + "%";
oSheet.Cells(j, 11).value = json[i].ASPECT_ITEM_NAME;
oSheet.Cells(j, 12).value = json[i].WT_ASP_IT == null ? "" : json[i].WT_ASP_IT + "%";
oSheet.Cells(j, 13).value = json[i].SCORE;
oSheet.Cells(j, 14).value = json[i].ITEM_SCORE;
oSheet.Cells(j, 15).value = json[i].ASP_SCORE;
if (eeName != json[i].eeName) {
oSheet.Cells(j, 16).value = json[i].FINALSCORE;
eeName = json[i].eeName;
}
j++;
}
xls.Range("A1:P" + (j - 1)).select;
xls.Selection.Borders.LineStyle = 1;
xls.Range("A1:P" + (j - 1)).HorizontalAlignment = 3;
xls.Range("A1:P" + (j - 1)).VerticalAlignment = 3; xls.Range("A3:P3").WrapText = true;
xls.Range("A2:P2").HorizontalAlignment = 2;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货