Uncaught Error: Invalid count什么错误？速来

收藏

Clark.Pan · Clark.Pan

您好，能提供具体一点的信息吗？光是上面信息我们也无法确定问题所在，希望您能将造成该错误的前因后果，或者截图，代码等告诉我们，方便我们定位问题所在

swejet · swejet

swejet · swejet

///收入表
function sheet1(SP, Trees, getNs, deptarr, years, months) {

$("#amobaConfigBtn").hide();

$("#loadmsg").show();

var sheet = SP.sheets[0];

sheet.frozenColumnCount(3);

sheet.options.gridline.color = "#ccc";

//SP.options.tabStripVisible = false;
///控制横向滚动条
SP.options.showHorizontalScrollbar = true;
SP.options.showVerticalScrollbar = false;

///----------------风格设置
sheet.defaults.colHeaderRowHeight = 40;
sheet.defaults.rowHeight = 25;
var defaultStyle = sheet.getDefaultStyle();
defaultStyle.font = "14px 微软雅黑";
sheet.setDefaultStyle(defaultStyle);

var style = new GC.Spread.Sheets.Style();
style.font = "15px 微软雅黑";
sheet.setStyle(0, -1, style, GC.Spread.Sheets.SheetArea.colHeader);
sheet.setStyle(-1, 0, style, GC.Spread.Sheets.SheetArea.rowHeader);

////----------------------风格设置结束

//sheet1(spread, TreeNodeCellType, ns);

//var sheet = SP.getActiveSheet();

///设置单行
sheet.selectionUnit(GC.Spread.Sheets.SelectionUnit.row);
//sheet.SelectionPolicy(GC.Spread.Sheets.SelectionPolicy.range);

var amuhdata = ["编码", "井别", "阿米巴井组", "月度收入金额", "平均日产油量", "平均日产气量", '月度地产油量', '月度地产气量', '月度油气商品量', '累积地产油量', '累积地产气量', '累积油气商品量'];

var h = getNs.SheetArea.colHeader;

sheet.setColumnCount(amuhdata.length, h);
sheet.setColumnCount(amuhdata.length, GC.Spread.Sheets.SheetArea.viewport);

for (var i = 0; i < amuhdata.length; i++) {
      sheet.addSpan(0, i, h);
      sheet.setValue(0, i, amuhdata[i], h);

      if (i == 0) {
         sheet.getRange(-1, i, -1, 1).width(80);///指定列的宽度，第二个参数为列坐标
      }
      else if (i == 1) {
         sheet.getRange(-1, i, -1, 1).width(80);///指定列的宽度，第二个参数为列坐标
      }
      else if (i == 2) {
         sheet.getRange(-1, i, -1, 1).width(300);///指定列的宽度，第二个参数为列坐标
      }
      else {
         sheet.getRange(-1, i, -1, 1).width(150);///指定列的宽度，第二个参数为列坐标
      }

}
console.log("/Ajax/amuAjax.ashx?act=LoadSheet1&deparr=" + escape(deptarr) + "&y=" + years + "&m=" + months + "");
$.ajax({
      type: "POST",
      cache: false,
      url: "/Ajax/amuAjax.ashx?act=LoadSheet1&deparr=" + escape(deptarr) + "&y=" + years + "&m=" + months + "",
      success: function (redata) {

         var adarr = JSON.parse(redata);

         sheet.suspendPaint();
         sheet.suspendEvent();
         sheet.rowOutlines.direction(GC.Spread.Sheets.Outlines.OutlineDirection.backward);

         sheet.getRange(-1, 2, -1, 1).cellType(new Trees());

         for (var i = 0; i < adarr.length; i++) {

            sheet.setValue(i, 0, adarr[i].d1);
            sheet.setValue(i, 1, adarr[i].d2);///第三列作为合并参数，不参与显示
            sheet.setValue(i, 2, adarr[i].WellName);

            if (adarr[i].subAmount > 0) {
                  sheet.setFormula(i, 3, adarr[i].YDSRJE);
                  sheet.setFormula(i, 4, adarr[i].PJRCYL);
                  sheet.setFormula(i, 5, adarr[i].PJRCQL);
                  sheet.setFormula(i, 6, adarr[i].YDDCYL);
                  sheet.setFormula(i, 7, adarr[i].YDDCQL);
                  sheet.setFormula(i, 8, adarr[i].YDYQSPL);
                  sheet.setFormula(i, 9, adarr[i].LJDCYL);
                  sheet.setFormula(i, 10, adarr[i].LJDCQL);
                  sheet.setFormula(i, 11, adarr[i].LJYQSPL);
            }
            else {
                  sheet.setValue(i, 3, adarr[i].YDSRJE);
                  sheet.setValue(i, 4, adarr[i].PJRCYL);
                  sheet.setValue(i, 5, adarr[i].PJRCQL);
                  sheet.setValue(i, 6, adarr[i].YDDCYL);
                  sheet.setValue(i, 7, adarr[i].YDDCQL);
                  sheet.setValue(i, 8, adarr[i].YDYQSPL);
                  sheet.setValue(i, 9, adarr[i].LJDCYL);
                  sheet.setValue(i, 10, adarr[i].LJDCQL);
                  sheet.setValue(i, 11, adarr[i].LJYQSPL);
            }

            sheet.rowOutlines.group(i + 1, adarr[i].subAmount);

         }

         sheet.showRowOutline(false);///隐藏分租线
         sheet.setRowCount(adarr.length + 1); ///总行数
         ///必须放在下面
         sheet.getRange(-1, 1, -1, 1).hAlign(getNs.HorizontalAlign.left);
         sheet.resumeEvent();
         sheet.resumePaint(false);

         $("#loadmsg").hide();

      }
});
}

dexteryao · dexteryao

问题已解决，此贴关闭

		自动登录	找回密码
密码			立即注册

[已处理] Uncaught Error: Invalid count什么错误？速来

4 个回复

浏览过的版块

悬赏达人

活字格高级认证

活字格认证

圣诞拼拼乐

微信认证勋章

讲师达人

SpreadJS 认证

SpreadJS 高级认证

元老葡萄