学步园

出现这种错误, 是要具体问题具体分析, 我在网上搜索发现各自的状况和解决方案都不一样.

今天在进行Excel的批量赋值的时候发现这个问题.

        protected override void FillTableData(Excel.Range DataStartRng, System.Collections.ArrayList LeafItems, DataView dv)
        {

            dv = rebuildData(dv,LeafItems);
            //int x,y;
            //x = dv.Count;
            //y = LeafItems.Count;
            //Object[,] datas = new object[x,y];
            //for(int i=0;i<x;i++)
            //{
            //    for(int j=0; j<y ;j++)
            //    {
            //        datas[i,j] = dv[i][((RelationItem)LeafItems[j]).ColumnName];
            //    }
            //}

            //Excel.Range dataRng = getRangeByRectangle(y,x,DataStartRng);
            //dataRng.Value = datas;
            //dataRng = null;
            Excel.Range dataRng = DataStartRng;
            int cycleRunTimes = dv.Count / MAX_EVALUATE_LINES + (dv.Count % MAX_EVALUATE_LINES > 0 ? 1 : 0);
            for (int i = 0; i < cycleRunTimes; i++)
            {
                object[,] datas =null;
                try
                {
                    datas = getSegmentData(i, dv, LeafItems);
                    dataRng = getRangeByRectangle(datas.GetLength(1), datas.GetLength(0), dataRng);
                }
                catch (Exception ex)
                {
                    throw new Exception(string.Format("取得segment data出错,dv[..] = {0} , Error :{1}",
                        dv[i * MAX_EVALUATE_LINES][0],
                        ex.ToString()));
                }
                try
                {
                    dataRng.Value = datas;
                }
                catch (Exception ex)
                {
                    throw new Exception(string.Format("赋值segment data出错,data[..]  = {0} ,  address :{1}, Error :{2}",
                        datas[0,0],
                        dataRng.get_AddressLocal(false, false, Excel.XlReferenceStyle.xlA1, m_objOpt, m_objOpt),
                        ex.ToString()));
                }


#if DEBUG
                    System.Diagnostics.Debug.WriteLine(String.Format("Lines: {0},    dataRng: {1} "
                        ,
                        i,
                        dataRng.get_AddressLocal(false, false, Excel.XlReferenceStyle.xlA1, m_objOpt, m_objOpt)));
#endif
                    dataRng = dataRng.get_Offset(datas.GetLength(0), m_objOpt);
                

            }

        }
        const int MAX_EVALUATE_LINES = 10;

如果我修改 MAX_EVALUATE_LINES = 100 的时候,就会时不时出现标题的错误.

减小MAX_EVALUATE_LINES 则不会出问题.