Page History

 public Area ImportData(System.Object[][] data, Cell startCell)
{signature}{signature:

Public Function ImportData(ByVal data As Object()(), ByVal startCell As Cell) As Area
{signature}
{parameters}
{param:data}A two\-dimensional array of values to import to the worksheet.
        The first dimension corresponds to column and the second to row \(that is, Object\[column\]\[row\]\).
        Thus, an array of data  
{code:csharp}

A two-dimensional array of values to import to the worksheet.
The first dimension corresponds to column and the second to row (that is, Object[column][row]).
Thus, an array of data

{{"A","X"},{"B","Y"},{"C","Z"}}

would

be

inserted

into

the

worksheet

as:

The cell at which to start entering the imported values.

An Area object representing the set of cells populated with the imported values.

The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved.