Imports data from an to the specified Area. The new data will overwrite values and formulas in the target worksheet cells, but existing formatting will be preserved.

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

An instance of , or

Microsoft.AnalysisServices.AdomdClient.AdomdDataReader

.

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

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


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

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