ExcelWorksheetGetDataTable(ExcelRange, Boolean) Method

Gets a System.Data.DataTable object from the specified source range. If the getColumnNames parameter is true the first row of the range will be used to obtain names for the DataTable columns.

Definition

Namespace: Winnovative.ExcelLib
Assembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 11.0.0
C#
public DataTable GetDataTable(
	ExcelRange sourceRange,
	bool getColumnNames
)

Parameters

sourceRange  ExcelRange
The worksheet range from where to get the values.
getColumnNames  Boolean
If this parameter is true the first row of the range will be used to obtain names for the DataTable columns.

Return Value

DataTable
The resulted DataTable.

See Also