SpreadsheetGear 2010
GetDataSet(String,GetDataFlags) Method
See Also  Send Feedback
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

Visual Basic (Declaration) 
Overloads Function GetDataSet( _
   ByVal reference As String, _
   ByVal flags As GetDataFlags _
) As DataSet
C# 
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

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

See Also

Copyright © 2003-2010 SpreadsheetGear LLC. All Rights Reserved.Help Powered by Innovasys   
SpreadsheetGear is a registered trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel and Visual Studio are trademarks or registered trademarks of Microsoft Corporation.