ExcelWorksheetExtractUsedRangeToDataTable Method

Note: This API is now obsolete.

Extracts data from used cells of this worksheet to a new DataTable with columns of type object.

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1000
Syntax
[ObsoleteAttribute("Use 'GemBox.Spreadsheet.ExcelWorksheet.CreateDataTable(GemBox.Spreadsheet.CreateDataTableOptions)' method instead. For more info, see http://www.gemboxsoftware.com/spreadsheet/help/html/Obsolete_Members.htm#ExcelWorksheetExtractUsedRangeToDataTable.")]
public DataTable ExtractUsedRangeToDataTable(
	ExtractDataOptions options
)

Parameters

options
Type: GemBox.SpreadsheetExtractDataOptions
Options that describe how data will be extracted.

Return Value

Type: DataTable
New DataTable.
Remarks
This method first calls GetUsedCellRange(Boolean) method to find block of used cells in this worksheet. Then it creates a new DataTable with the same number of columns as width of that range and with the column type of object. Finally, it extracts block of used cells to DataTable and returns filled DataTable.
See Also