Click or drag to resize

ExcelWorksheetGetDataTable Method (ExcelRange, Boolean)

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.

Namespace:  ExpertXls.ExcelLib
Assembly:  expertxls (in expertxls.dll) Version: 7.0.0
Syntax
Copy
public DataTable GetDataTable(
	ExcelRange sourceRange,
	bool getColumnNames
)

Parameters

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

Return Value

Type: DataTable
The resulted DataTable.
See Also