TreatAsMissing must be a character vector or a cell array of character vectors containing nonnumeric text

spreadsheetDatastore
Datastore for spreadsheet filesexpand


Description
Use a SpreadsheetDatastore object to manage large collections of spreadsheet files where the collection does not necessarily fit in memory. You can create a SpreadsheetDatastore object using the spreadsheetDatastore function, specify its properties, and then import the data using object functions.





TreatAsMissing — Text to treat as missing values
'' (default) | character vector | cell array of character vectors | string scalar | string array
Text to treat as missing values, specified as a single character vector, cell array of character vectors, string scalar, or string array. Values specified as TreatAsMissing are substituted with the value defined in the MissingValue property. For instance, if MissingValue is defined to be a NaN, and the TreatAsMissing is specified as 'NA'. Then, in the imported data, all occurrences of 'NA' are replaced by NaN.

This option only applies to numeric fields. Also, this property is equivalent to the TreatAsEmpty name-value pair argument for the textscan function.

When you change the value of this property, the datastore function reevaluates the values of the TabularTextDatastore properties.

Example: 'NA'

Example: {'-',''}

Data Types: char | cell | string





For more information,

https://www.mathworks.com/help/matlab/ref/matlab.io.datastore.tabulartextdatastore.html