ExcelWorksheetGetDataTable(ExcelRange, Boolean, Boolean, Boolean) Method

public DataTable GetDataTable(
	ExcelRange sourceRange,
	bool getColumnNames,
	bool getColumnDataTypes,
	bool getFormulaResult
)

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

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

member GetDataTable : 
        sourceRange : ExcelRange * 
        getColumnNames : bool * 
        getColumnDataTypes : bool * 
        getFormulaResult : bool -> 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.

getColumnDataTypes  Boolean

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  Boolean

If the getFormulaResult parameter is true the result values of the formulas evaluation will be exported

Return Value

Reference