ExcelWorksheetGetDataTable Method (ExcelRange, Boolean)

Winnovative Excel Library Documentation

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: Winnovative.ExcelLib
Assembly: wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)

Syntax

C++

Copy

public DataTable GetDataTable(
	ExcelRange sourceRange,
	bool getColumnNames
)

Public Function GetDataTable ( 
	sourceRange As ExcelRange,
	getColumnNames As Boolean
) As DataTable

public:
DataTable^ GetDataTable(
	ExcelRange^ sourceRange, 
	bool getColumnNames
)

member GetDataTable : 
        sourceRange : ExcelRange * 
        getColumnNames : bool -> DataTable

Parameters

sourceRange: Type: Winnovative.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.

Reference

ExcelWorksheet Class

GetDataTable Overload

Winnovative.ExcelLib Namespace

ExcelWorksheetAddLanguageSpecificTextSet("LST3CF963C4_0?cpp=::|nu=.");GetDataTable Method (ExcelRange, Boolean)

Parameters

Return Value

Reference

ExcelWorksheetGetDataTable Method (ExcelRange, Boolean)