GetRowCount
    (
        Object [,] aoColumnValues
    )
    {
        Debug.Assert(aoColumnValues != null);
        AssertValid();

        return ( aoColumnValues.GetUpperBound(0) -
            aoColumnValues.GetLowerBound(0) + 1);
    }
Ejemplo n.º 2
0
        SetRangeValues
        (
            Range upperLeftCornerMarker,
            Object[,] values
        )
        {
            Debug.Assert(upperLeftCornerMarker != null);
            Debug.Assert(values != null);

            Debug.Assert(upperLeftCornerMarker.Parent is Worksheet);

            Worksheet oWorksheet = (Worksheet)upperLeftCornerMarker.Parent;

            Int32 iRow = upperLeftCornerMarker.Row;
            Int32 iColumn = upperLeftCornerMarker.Column;

            Range oRangeToSet = oWorksheet.get_Range(

                oWorksheet.Cells[iRow, iColumn],

                oWorksheet.Cells[
                    iRow + values.GetUpperBound(0) - values.GetLowerBound(0),
                    iColumn + values.GetUpperBound(1) - values.GetLowerBound(1)
                    ]
                );

            oRangeToSet.set_Value(Missing.Value, values);
        }
Ejemplo n.º 3
0
 ///<summary>
 ///Creates a XArrayHelper and copies the values from an object array.
 ///</summary>
 ///<param name="array">The source array to be copied.</param>
 public void LoadRows(Object[,] array)
 {
     this.RedimXArray(new int[] { array.GetUpperBound(0), array.GetUpperBound(1) }, new int[] { array.GetLowerBound(0), array.GetLowerBound(1) });
     for (int row = array.GetLowerBound(0); row <= array.GetUpperBound(0); row++)
     {
         for (int col = array.GetLowerBound(1); col <= array.GetUpperBound(1); col++)
         {
             this.SetValue(array[row, col], row, col);
         }
     }
 }