Imports data from an ADO.NET 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.Data.DataTable data, Cell cell, DataImportProperties props)
Public Function ImportData(ByVal data As System.Data.DataTable, ByVal cell As Cell, ByVal props As DataImportProperties) As Area

The DataTable to import.

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(dataDT, cel, importProps);
Dim importedArea As Area = ws.ImportData(dataDT, cel, importProps)