MATLAB: Do I receive the error message of “Unknown Parameter ‘DateTimeLocale’ ” while using ‘readtable’

countrydatelocaledatesdatetimelocalelocaleMATLABreadtabletext;us

I receive the following error message while trying to read the dates in the US-Format using 'readtable' function:

Error using readtable (line 198)
Unknown Parameter 'DateTimeLocale'.

Best Answer

The error message is due to the invalid parameter 'DateTimeLocale'.

In order to read the dates of a specific Locale and Country, the Name-Value pair 'DateLocale' can be used in the 'readtable' function.

Example: 'DateLocale','en_US' for United States format dates.

The following documentation provides more information on 'DateLocale' Name-Value pair:

https://www.mathworks.com/help/releases/R2020a/matlab/ref/readtable.html#d120e1047037

Refer to the following documentation that provides a list of some common values of Locale:

https://www.mathworks.com/help/releases/R2020a/matlab/ref/datetime.html#namevaluepairarguments

NOTE: The Name-Value pair is only applicable for Text Files.

Related Solutions

MATLAB: For ‘readtable’ func parameter ‘Format’ is not recognized although importing from a text

As documented...

T = readtable(filename,opts,Name,Value) creates a table using the import options and with 
additional options specified by one or more of these name-value pair arguments: ReadVariableNames, 
ReadRowNames, DateLocale, Encoding, Sheet, and Basic.

'Format' is not one of the allowed name-value pair arguments when using an opts object; if you wish to use other than the detected variable type/format must change the opts object itself with the get/setvaropts pair.

MATLAB: How to read and work with a csv file (.csv)

Or, more easy way is to use Import tool, especially the data file contains not only numbers like your case.

Import tool:

https://www.mathworks.com/help/matlab/ref/importtool-app.html

Best Answer

Related Solutions

MATLAB: For ‘readtable’ func parameter ‘Format’ is not recognized although importing from a text

MATLAB: How to read and work with a csv file (.csv)

Related Question