Spreadsheet.GetData2

This function gets spreadsheet data as 2-D array of variant. Text type variables returned as strings, numeric as numbers (or text labels if desired.).

Syntax Parameters Return Value 
Function Spreadsheet.GetData2( _
    StartCase As Long, _
    nbCases As Long, _
    StartVar As Long, _
    nbVars As Long, _
    Optional flags As GetDataOptions = 0) As Variant
  • StartCase [in]

Type: Long

  • nbCases [in]

Type: Long

  • StartVar [in]

Type: Long

  • nbVars [in]

Type: Long

  • flags [in,optional]

Type: GetDataOptions

Default value: 0

Variant