importing data with dates from excel

4 visualizaciones (últimos 30 días)
Robert Booth
Robert Booth el 21 de Ag. de 2016
Comentada: Azzi Abdelmalek el 21 de Ag. de 2016
How to import data from excel spread sheet and preserve date format and time of day format

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Azzi Abdelmalek
Azzi Abdelmalek el 21 de Ag. de 2016
[~,~,data]=xlsread('yourfile')
  1 comentario
Azzi Abdelmalek
Azzi Abdelmalek el 21 de Ag. de 2016
Robert commented
Thank you.Unfortunately does not work. If I use 'import data' facility, the table is imported but under date column the title 'date' is replaced by NaN and the actual dates are converted to [Type:Number,value:nnnnn.0]. However, the other information in the table is imported and tabulated correctly.

Iniciar sesión para comentar.

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by