GetRowCount
(
Object [,] aoColumnValues
)
{
Debug.Assert(aoColumnValues != null);
AssertValid();
return ( aoColumnValues.GetUpperBound(0) -
aoColumnValues.GetLowerBound(0) + 1);
}
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);
}
///<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);
}
}
}