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

Msdn
System.Data.IDataReader
System.Data.IDataReader
1IDataReader
to the specified Area. 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.IDataReader data)
Signature
vb.net
vb.net
Public Function ImportData(ByVal data As System.Data.IDataReader) As Area
Parameters
Param
data
data

An instance of

Msdn
System.Data.SqlClient.SqlDataReader
System.Data.SqlClient.SqlDataReader
1System.Data.SqlClient.SqlDataReader
,
Msdn
System.Data.OleDb.OleDbDataReader
System.Data.OleDb.OleDbDataReader
1System.Data.OleDb.OleDbDataReader
or

Code Block
Microsoft.AnalysisServices.AdomdClient.AdomdDataReader

.

Returns

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

Example
Code Block
csharp
csharp
titleC#
Area importedArea = a.ImportData(dr);
Code Block
vbnet
vbnet
titlevb.net
Dim importedArea As Area = a.ImportData(dr)
Scrollbar