Worksheet.ImportData(System.Data.DataTable, Cell)

Description

Imports data from an ADO.NET DataTable to cells in the worksheet. 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.

startCell

The cell at which to start entering the imported values.

Returns

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

Examples

C#