SpreadsheetGear The Performance Spreadsheet Component Company 
GetDataSet(String,GetDataFlags) Method
See Also 
SpreadsheetGear Namespace > IWorkbook Interface > GetDataSet Method : GetDataSet(String,GetDataFlags) Method
reference
a comma separated list of ranges.
flags
Specifies optional features such as column headers and formatted text values.
Returns a newly created data set consisting of a data table for each of the ranges specified by reference.

Syntax

C# 
virtual DataSet GetDataSet( 
   string reference,
   GetDataFlags flags
)

Parameters

reference
a comma separated list of ranges.
flags
Specifies optional features such as column headers and formatted text values.

Return Value

the newly created data set.

Example

See examples here.

Remarks

Each reference must consist of a defined name or a range reference such as:

  • "A1:E15" - specifies the range A1:E15 in the first worksheet.
  • "Sheet3!B2:D5" - specifies the range B2:D5 in Sheet3.
  • "MyDatabase" - specifies the worksheet and range referred to by the defined name "MyDatabase".
  • "A1:E15,Sheet3!B2:D5,MyDatabase" - specifies all of the above as three data tables in the data set.

Requirements

Platforms: Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Me and Windows 98, including 32 bit and 64 bit editions where applicable. SpreadsheetGear for .NET 1.x requires the Microsoft .NET Framework 1.1 or .NET 2.0 (works with .NET 3.x). SpreadsheetGear for .NET 2007 requires the Microsoft .NET Framework 2.0 (works with .NET 3.x).

See Also