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.
Namespace: ExpertXls.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 9.0.0
Syntaxpublic DataTable GetDataTable(
ExcelRange sourceRange,
bool getColumnNames
)
Public Function GetDataTable (
sourceRange As ExcelRange,
getColumnNames As Boolean
) As DataTable
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
DataTableThe resulted DataTable.
See Also