Imports data from a rectangular array of objects to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved.

 public Area ImportData(System.Object[,] data, Cell cell)
Public Function ImportData(ByVal data As Object(,), ByVal cell As Cell) As Area

A rectangular array of values to import to the worksheet. The first dimension corresponds to row and the second to column.
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.

Area importedArea = ws.ImportData(dataArray, cel);
Dim importedArea As Area = ws.ImportData(dataArray, cel)