OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 5

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version Current

changes.mady.by.user Wiki Administrator

Saved on

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, DataImportProperties props)
{signature}{signature:
}
Signature
vb.net
vb.net
Public Function ImportData(ByVal data As System.Data.IDataReader, ByVal props As DataImportProperties) As Area
{signature}
{parameters}
{param:data}An instance of {msdn:
Parameters
Param
data
data

An instance of

Msdn
System.Data.SqlClient.SqlDataReader

|

System.Data.SqlClient.SqlDataReader

}, {msdn:

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

|

System.Data.OleDb.OleDbDataReader

} or {code}

1System.Data.OleDb.OleDbDataReader
or

Code Block

Microsoft.AnalysisServices.AdomdClient.AdomdDataReader
{code} .{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}} object representing the set of cells populated with the imported values.{returns} {example}{code:csharp|title=C#}
.
 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#


DataImportProperties importProps = wb.CreateDataImportProperties();
importProps.Truncate = true;
Area importedArea = a.ImportData(dr, importProps);

{code}
{code:vbnet|title=
 Code Block
vbnet
vbnet
titlevb.net
}


Dim importProps As DataImportProperties = wb.CreateDataImportProperties()
importProps.Truncate = True
Dim importedArea As Area = a.ImportData(dr, importProps)

{code}

{example}
{scrollbar}
 Scrollbar