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

1 visualizzazione (ultimi 30 giorni)
MathWorks Support Team
MathWorks Support Team il 27 Giu 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.

Accedi per rispondere a questa domanda.

Risposta accettata

MathWorks Support Team
MathWorks Support Team il 27 Giu 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.

Più risposte (0)

Categorie

Scopri di più su Introduction to Installation and Licensing in Help Center e File Exchange

Tag

Non è stata ancora inserito alcun tag.

Prodotti


Release

R14SP1

Community Treasure Hunt

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

Start Hunting!

Translated by