Imports data from an ADO.NET to the specified Area. 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)
Public Function ImportData(ByVal data As System.Data.DataTable) As Area

The DataTable to import.

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

Area importedArea = a.ImportData(dt);
Dim importedArea As Area = a.ImportData(dt)