GetDataSet(String,GetDataFlags) Method

Returns a newly created data set consisting of a data table for each of the ranges specified by reference.

[Visual Basic]
Overloads Overridable Function GetDataSet( _
   ByVal reference As String, _
   ByVal flags As GetDataFlags _
) As DataSet

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

[C++]
virtual DataSet GetDataSet( 
   string* reference,
   GetDataFlags flags
) 

[C++/CLI]
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 Type

the newly created data set.

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.

Example

See examples here.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IWorkbook Interface  | IWorkbook Members  | Overload List

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.