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:
[ObsoleteAttribute("Use 'GemBox.Spreadsheet.ExcelWorksheet.CreateDataTable(GemBox.Spreadsheet.CreateDataTableOptions)' method instead. For more info, see https://www.gemboxsoftware.com/spreadsheet/help/html/Obsolete_Members.htm#ExcelWorksheetExtractUsedRangeToDataTable.")]
public DataTable ExtractUsedRangeToDataTable(
	ExtractDataOptions options


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

Return Value

Type: DataTable
New DataTable.
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