error xlsread import dates

1 visualizzazione (ultimi 30 giorni)
Matteo Pazzaglia
Matteo Pazzaglia il 10 Apr 2020
Risposto: Rajani Mishra il 13 Apr 2020
Hi all,
I have a problem when I import dates from an xls file. It contains a column of dates, one of price, dates, price and so on. If I open the file from the Matlab folder, dates are "dd/MM/yyyy".
[price, dates]=xlsread(filename);
With this command I found a problem in the matrix dates in fact it gives me for example "monday-03-08-2010" instead of the "canonical" format "dd/mm/yyyy" and I don't know why. I've already tried with xlsread(filename, 'mm/dd/yyyy') but without solution. Can someone help me?
Thanks a lot
P.s. Matlab version 2019

Risposta accettata

Rajani Mishra
Rajani Mishra il 13 Apr 2020

Più risposte (0)

Categorie

Scopri di più su Data Preprocessing in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by