how to load dates from xlsx files into matlab
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Ida Lunde Hygum
el 27 de Mzo. de 2018
Respondida: Star Strider
el 27 de Mzo. de 2018
Hi guys,
I am trying to load dates from an excel file into matlab, but it loads it as numbers and when I use "datestring" it turns it into dates, but starting from one day a head of original data and the year "114" instead of "2014", for example I have the original date "12/03/2014", but matlab reads it as "13-Mar-0114". My code looks like this:
datoreading=xlsread('dato.xlsx');
date_data=datestr(datoreading);
I checked that the cell in excel is in the format "Date", so this should not be the problem.
Hope somebody can help me out here! Cheers, Ida
0 comentarios
Respuesta aceptada
Star Strider
el 27 de Mzo. de 2018
Without your data to work with, we cannot troubleshoot the problem.
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!