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

1 visualización (últimos 30 días)
MathWorks Support Team
MathWorks Support Team el 27 de Jun. de 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.

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

MathWorks Support Team
MathWorks Support Team el 27 de Jun. de 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.

Más respuestas (0)

Categorías

Más información sobre Introduction to Installation and Licensing en Help Center y File Exchange.

Etiquetas

Aún no se han introducido etiquetas.

Productos


Versión

R14SP1

Community Treasure Hunt

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

Start Hunting!

Translated by