Page History

Imports data from a two-dimensional array of objects to cells in the worksheet.

 public Area ImportData(System.Object[][] data, Cell startCell)

Public Function ImportData(ByVal data As Object()(), ByVal startCell As Cell) As Area

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.