getvaropts

Get variable import options

Syntax

varOpts = getvaropts(opts,selection)

Description

varOpts = getvaropts(opts,selection) returns the variable import options for the variables specified in selection.

Examples

Get Import Options for Variable

Access the variable import options object that controls the importing of a variable using the getvaropts function.

Create import options from a file. The options object is a collection of individual variable import options.

opts = detectImportOptions('patients.xls')

opts = 
  SpreadsheetImportOptions with properties:

   Sheet Properties:
                        Sheet: ''

   Replacement Properties:
                  MissingRule: 'fill'
              ImportErrorRule: 'fill'

   Variable Import Properties: Set types by name using setvartype
                VariableNames: {'LastName', 'Gender', 'Age' ... and 7 more}
                VariableTypes: {'char', 'char', 'double' ... and 7 more}
        SelectedVariableNames: {'LastName', 'Gender', 'Age' ... and 7 more}
              VariableOptions: Show all 10 VariableOptions 
	Access VariableOptions sub-properties using setvaropts/getvaropts
           VariableNamingRule: 'modify'

   Range Properties:
                    DataRange: 'A2' (Start Cell)
           VariableNamesRange: 'A1'
                RowNamesRange: ''
           VariableUnitsRange: ''
    VariableDescriptionsRange: '' 
	To display a preview of the table, use preview

Get the variable import options object for the specified variable.

varOpts = getvaropts(opts, 'Systolic')

varOpts = 
  NumericVariableImportOptions with properties:

   Variable Properties:
                  Name: 'Systolic'
                  Type: 'double'
             FillValue: NaN
        TreatAsMissing: {}
             QuoteRule: 'remove'
              Prefixes: {}
              Suffixes: {}
        EmptyFieldRule: 'missing'

   Numeric Options:
     ExponentCharacter: 'eEdD'
      DecimalSeparator: '.'
    ThousandsSeparator: ''
        TrimNonNumeric: 0
          NumberSystem: 'decimal'

To modify the variable import options, see the setvaropts and setvartype function reference pages.

Input Arguments

opts — File import options

SpreadsheetImportOptions | DelimitedTextImportOptions | FixedWidthImportOptions

File import options, specified as a SpreadsheetImportOptions, DelimitedTextImportOptions, or a FixedWidthImportOptions object created by the detectImportOptions function. The opts object contains properties that control the data import process, such as variable properties, data location properties, replacement rules, and others.

selection — Selected variables

character vector | string scalar | cell array of character vector | string array | array of indices | logical array

Selected variables, specified as a character vector, string scalar, cell array of character vectors, string array, array of numeric indices, or a logical array.

Variable names (or indices) must be a subset of the names contained in the VariableNames property of the opts object.

Example: 'Height'

Example: {'Height','LastName'}

Example: [5 9]

Data Types: char | string | cell | uint64

Output Arguments

varOpts — Type dependent options for selected variables

array of variable import options objects

Type dependent options for selected variables, returned as an array of variable import options objects. The array contains an object corresponding to each variable specified in the selection argument. Depending on the data types of the variables, each object in the array is one of these types: numeric, text, logical, datetime, and categorical.

You can modify properties of the individual objects.

• To modify the Type property, use the setvartype function.

• To modify other properties, use the setvaropts function.