Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

Imports data from an ADO.NET

...

Msdn

...

System.Data.DataView

...

System.Data.DataView
1DataView
to cells in the worksheet. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved.

Signature
C#
C#
 public Area ImportData(System.Data.DataView data, Cell cell, DataImportProperties props)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function ImportData(ByVal data As System.Data.DataView, ByVal cell As Cell, ByVal props As DataImportProperties) As Area
{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#}
Parameters
Param
data
data

The DataView to import.

Param
startCell
startCell

The cell at which to start entering the imported values.

Param
props
props

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

Returns

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

Example
Code Block
csharp
csharp
titleC#

Area importedArea = ws.ImportData(dataDV, cel, importProps);
{code} {code:
Code Block
vb.net
|title=
vb.net
titlevb.net
}

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