Files included in the datastore, resolved as a cell array of character vectors or a string array, where each character vector or string is a full path to a file. The location argument in the spreadsheetDatastore and datastore functions define these files.

The first file specified in the cell array determines the variable names and format information for all files in the datastore.

Example: {'C:\dir\data\file1.xls';'C:\dir\data\file2.xls'}

Data Types: cell | string

Number of lines to skip at the beginning of each sheet when reading, specified as a positive integer. When you also specify the Range property, NumHeaderLines is the number of lines to skip at the beginning of the specified block of data.

Data Types: double

Sheets in files, specified as a character vector, cell array of character vectors, string scalar, or string array containing sheet names, or as a numeric vector of sheet indices. The empty character vector '' indicates that all sheets in the files are included.

Example: {'sheet1','sheet7'}

Example: [3 5 7]

Data Types: char | cell | string | double

Row and column bounds, specified as a character vector or string scalar that defines a rectangular block of data in the sheets. The empty character vector '' indicates that the bounds are the beginning of the file and the end of the data.

Example: 'B1:T7'

Example: 'A:C'

Data Types: char | string

Indicator for reading the first row of the first file in the datastore as variable names, specified as either true (1) or false (0).

Data Types: logical | double

Flag to preserve variable names, specified as the comma-separated pair consisting of VariableNamingRule and either true, or false.

Starting in R2019b, variable names and row names can include any characters, including spaces and non-ASCII characters. Also, they can start with any characters, not just letters. Variable and row names do not have to be valid MATLAB identifiers (as determined by the isvarname function). To preserve these variable names and row names, set the value of VariableNamingRule to 'preserve'.

Data Types: char | string

Names of variables in the datastore, specified as a character vector, cell array of character vectors, string scalar, or string array. Specify the variable names in the order in which they appear in the files. If you do not specify the variable names, the datastore detects them from the first nonheader line in the first file. You can specify VariableNames with a character vector or string scalar, however the datastore converts and stores the property value to a cell array of character vectors. When modifying the VariableNames property, the number of new variable names must match the number of original variable names.

To support invalid MATLAB identifiers as variable names, such as variable names containing spaces and non-ASCII characters, set the value of the VariableNamingRule parameter to 'preserve'.

If ReadVariableNames is false, then VariableNames defaults to {'Var1','Var2', ...}.

Example: {'Time','Date','Quantity'}

Data Types: char | cell | string

Variable types, specified as 'double', 'char', 'string', 'categorical', or 'datetime', which indicates the type of each variable when reading the data.

The list of variable types corresponds with the variables in VariableNames. Types double, char, and datetime can be automatically detected from the data. You can specify VariableTypes as a character vector or string scalar, however spreadsheetDatastore automatically converts it to a cell array of character vectors or a string array.

Example: {'char','categorical'}

Data Types: char | cell | string

Variables to read from the file, specified as a character vector, cell array of character vectors, string scalar, or string array. Each character vector or string contains the name of one variable. You can specify the variable names in any order. You can specify SelectedVariableNames with a character vector or string scalar, however spreadsheetDatastore automatically converts it to a cell array of character vectors or a string array.

To support invalid MATLAB identifiers as variable names, such as variable names containing spaces and non-ASCII characters, set the value of VariableNamingRule parameter to 'preserve'.

Example: {'Var3','Var7','Var4'}

Data Types: char | cell | string

Selected variable types, specified as 'double', 'char', 'string', 'categorical', or 'datetime', which indicates the type of each selected variable when reading the data. The list of variable types corresponds with the variables in SelectedVariableNames. Types double, char, and datetime can be automatically detected from the data. You can specify SelectedVariableTypes as a character vector or string scalar, however it is automatically converted to a cell array of character vectors or string array.

Example: {'double','datetime'}

Data Types: char | cell | string

Amount of data to read in a call to the read function, specified as 'file' or 'sheet', or as a positive integer scalar.

When you change ReadSize from an integer scalar to 'file' or 'sheet', or conversely, the datastore resets using the reset function.

Data Types: char | string | double

Name of row times variable, specified as the comma-separated pair consisting of 'RowTimes' and a variable name (such as "Date") or a variable index (such as 3).

RowTimes is a timetable-related parameter. Each row of a timetable is associated with a time, which is captured in a time vector for the timetable. The variable specified in RowTimes must contain a datetime or a duration vector.

If the value of 'OutputType' is 'timetable', but you do not specify 'RowTimes', then SpreadsheetDatastore uses the first datetime or duration variable as the row times for the timetable.

This property is read-only.

Folders used to construct datastore, returned as a cell array of character vectors. The cell array is oriented as a column vector. Each character vector is a path to a folder that contains data files. The location argument in the spreadsheetDatastore and datastore functions defines Folders when the datastore is created.

The Folders property is reset when you modify the Files property of a SpreadsheetDatastore object.

Data Types: cell

This property is read-only.

List of formats supported for writing, returned as a row vector of strings. This property specifies the possible output formats when using writeall to write output files from the datastore.

Data Types: string

This property is read-only.

Default output format, returned as a string scalar. This property specifies the default format when using writeall to write output files from the datastore.

Data Types: string