error xlsread import dates

조회 수: 1 (최근 30일)
Matteo Pazzaglia
Matteo Pazzaglia 2020년 4월 10일
답변: Rajani Mishra 2020년 4월 13일
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

채택된 답변

Rajani Mishra
Rajani Mishra 2020년 4월 13일

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Data Preprocessing에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by