ExcelWorksheetGetDataTable 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.

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.