Click or drag to resize

ExcelWorksheetGetDataTable Method (ExcelRange, Boolean, Boolean, 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. If the getFormulaResult parameter is true the result values of the formulas evaluation will be exported If the getColumnDataTypes is true the data type of the first value of the range column will give the data type of the corresponding column in the resulted DataTable.

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

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.
getColumnDataTypes
Type: SystemBoolean
If this parameter is true the data type of the first value of the range column will give the data type of the corresponding column in the resulted DataTable.
getFormulaResult
Type: SystemBoolean
If the getFormulaResult parameter is true the result values of the formulas evaluation will be exported

Return Value

Type: DataTable
The resulted DataTable.
See Also