Overloads Function GetDataSet( _
   ByVal reference As String, _
   ByVal flags As GetDataFlags _
) As DataSet

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

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.

Reference