Page History

Description

Excerpt

Imports data from an

Msdn

	System.Data.IDataReader
	System.Data.IDataReader
1	IDataReader

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

	vb.net
	vb.net

Public Function ImportData(ByVal data As System.Data.IDataReader, ByVal props As DataImportProperties) As Area

Parameters

Param

	data
	data

An instance of

Msdn

	System.Data.SqlClient.SqlDataReader
	System.Data.SqlClient.SqlDataReader
1	System.Data.SqlClient.SqlDataReader

,

Msdn

	System.Data.OleDb.OleDbDataReader
	System.Data.OleDb.OleDbDataReader
1	System.Data.OleDb.OleDbDataReader

or

Code Block
Microsoft.AnalysisServices.AdomdClient.AdomdDataReader

.

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
title	C#


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

Code Block

	vbnet
	vbnet
title	vb.net


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

Scrollbar

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version Current

Key