Imports data from a two-dimensional 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, System.String[] columnNames, Cell startCell, DataImportProperties props)
Public Function ImportData(ByVal data As Object()(), ByVal columnNames As String(), ByVal startCell As Cell, ByVal props As DataImportProperties) As Area

A two-dimensional array of values to import to the worksheet.
By default, 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:

A

X

B

Y

C

Z

If you enable DataImportProperties.Transpose , the format will be [row][column], so:
{ {"A","B","C"},{"X","Y","Z"} } would be inserted into the worksheet as:

A

X

B

Y

C

Z

An array of column names for the imported data. columnNames and the column dimension of data must contain the same number of elements.

The cell at which to start entering the imported values.

A DataImportProperties object that contains a set of properties that will determine the behavior of the data import.

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

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