Area.ImportData(System.Data.DataTable, DataImportProperties)

Description

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

C#

vb.net

Parameters

data

The DataTable to import.

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.

Examples

C#