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.
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.
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.
You can also select a web site from the following list:
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.