Why does the date format change in MATLAB using XLSREAD in MATLAB 7.1 (R14SP3)?

1 Ansicht (letzte 30 Tage)
MathWorks Support Team
MathWorks Support Team am 27 Jun. 2009
I have created a file in Excel, where one of the columns is a date in 24-hour notation. When I import it into MATLAB, the date is now in an am/pm format.

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

MathWorks Support Team
MathWorks Support Team am 27 Jun. 2009
The ability to import dates in 24-hour format from Excel is not available in MATLAB 7.1 (R14SP3). XLSREAD in MATLAB 7.1 (R14SP3) converts 24-hour date format to am/pm format while reading from Excel to MATLAB.
As a workaround, you can use the DATESTR function to convert the date to any desired date format.

Weitere Antworten (0)

Kategorien

Mehr zu Introduction to Installation and Licensing finden Sie in Help Center und File Exchange

Tags

Noch keine Tags eingegeben.

Produkte


Version

R14SP1

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by