Page History

...

{description}
{excerpt}Imports data from an ADO.NET

...

 {msdn

...

:System.Data.DataView

...

|DataView} to cells in the worksheet. The new data will +overwrite+ values and formulas in the target worksheet cells, but existing formatting will be preserved.{excerpt}
{signature:C#}
 public Area ImportData(System.Data.DataView data, Cell cell, DataImportProperties props)

{signature}{signature:vb.net

}
Public Function ImportData(ByVal data As System.Data.DataView, ByVal cell As Cell, ByVal props As DataImportProperties) As Area

...

The DataView 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.

{signature}
{parameters}
{param:data}The {{DataView}} to import.{param}
{param:startCell}The cell at which to start entering the imported values.{param}
{param:props}A [DataImportProperties|DataImportProperties] object that contains a set of properties that will determine the behavior of the data import.{param}
{returns}An [Area|Area] object representing the set of cells populated with the imported values.{returns}
{example}{code:csharp|title=C#}
Area importedArea = ws.ImportData(dataDV, cel, importProps);

{code}
{code:vb.net

|title=vb.net

}
Dim importedArea As Area = ws.ImportData(dataDV, cel, importProps){code}

{example}