예제 #1
0
 /// <summary>
 /// 保存手写的数据,为了和新更新的数据比较
 /// 点击更新时把旧表保存在IList中
 /// </summary>
 /// <param name="BeginCol">要保存的起始行</param>
 /// <param name="BeginRow">要保存的起始列</param>
 /// <param name="indexX">二维数组的一维个数</param>
 /// <param name="indexY">二维数组的二维个数</param>
 public void SaveData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol, int indexX, int indexY)
 {
     list.Clear();
     for (int i = IntRow; i < (obj.RowCount); i += 2)//行从第IntRow行开始保存
     {
         SSheet11_2 SS11_2 = new SSheet11_2();
         SS11_2.strDQ   = null;
         SS11_2.strType = null;
         SS11_2.data    = new object[indexX, indexY];
         for (int j = IntCol; j < obj.ColumnCount; ++j)//列从第IntCol列开始保存
         {
             SS11_2.strType             = PF.ReturnStr(obj, i, 1).ToString();
             SS11_2.strDQ               = PF.ReturnStr(obj, i, 2).ToString();
             SS11_2.data[0, j - IntCol] = obj.Cells[i, j].Value;
             SS11_2.data[1, j - IntCol] = obj.Cells[i + 1, j].Value;
         }
         list.Add(SS11_2);
     }
 }
예제 #2
0
 /// <summary>
 /// 保存手写的数据,为了和新更新的数据比较
 /// 点击更新时把旧表保存在IList中
 /// </summary>
 /// <param name="BeginCol">要保存的起始行</param>
 /// <param name="BeginRow">要保存的起始列</param>
 /// <param name="indexX">二维数组的一维个数</param>
 /// <param name="indexY">二维数组的二维个数</param>
 public void SaveData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol,int indexX,int indexY)
 {
     list.Clear();
     for (int i = IntRow; i < (obj.RowCount); i += 2)//行从第IntRow行开始保存
     {
         SSheet11_2 SS11_2 = new SSheet11_2();
         SS11_2.strDQ = null;
         SS11_2.strType = null;
         SS11_2.data = new object[indexX, indexY];
         for (int j = IntCol; j < obj.ColumnCount; ++j)//列从第IntCol列开始保存
         {
             SS11_2.strType =  PF.ReturnStr(obj, i,1).ToString();
             SS11_2.strDQ = PF.ReturnStr(obj, i, 2).ToString();
             SS11_2.data[0, j - IntCol] = obj.Cells[i, j].Value;
             SS11_2.data[1, j - IntCol] = obj.Cells[i + 1, j].Value;
         }
         list.Add(SS11_2);
     }
 }