Excel date column export into Matlab and plot

2 次查看（过去 30 天）

Isa Isa 2013-9-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/87415-excel-date-column-export-into-matlab-and-plot

Hi, Please I have excel file that conntains a date column and another column. I wish to plot the date on x axis and the second column on y axis. I have problem with date column in matlab. Please assist.

3/1/2014  7080.351
4/1/2014  6489.479
5/1/2014  5848.211
6/1/2014  5275.638
7/1/2014  4875.981
8/1/2014  4461.803
9/1/2014  4113.059
10/1/2014  3840.401
11/1/2014  3629.337
12/1/2014  3466.029
1/1/2015  3315.5
2/1/2015  3187.037

Please assist on how to plot this using Matlab. Thanks Isa

6 个评论
显示 4更早的评论隐藏 4更早的评论

Jan 2013-9-17

编辑：Jan 2013-9-17

No, this does not help. Do you have a computer? Is an OS installed? Do you have Matlab and Excel installed? Which OS are you using? Are you able to use XLSREAD already? Did you implement it and how do the imported data look like? Is "2/1/2015" a string in the imported data or the display of a serial date number inside Excel? Did you manage the import successfully already and need the plot() command only? Or does the plotting work and you are looking for the datetick() function to show the date in a nicer format?

Please take into account, that the readers in the forum do not have the faintest idea about the current status of your program. So show us, what you have done so far and ask for one specific problem. The need to guess a detail reduces the chance to get a useful answer by 95% (the remaining 5% belong to Walter, who has a crystal ball like power to guess, what the people want).

Please avoid to post multiple questions about one problem. This wastes the time of the readers only. See http://www.mathworks.com/matlabcentral/answers/67342-excel-date-column-plot-in-matlab.

Isa Isa 2013-9-17

Thanks Jan. This is my code. data=xlsread('DataTest','Sheet1'); q=data(:,2); time=data(:,1);

Error message

Attempted to access data(:,2); index out of bounds because size(data)=[193,1].

Matlab is not reading the first column of the excel file that contains the date so it takes the second column as the first column as a result it could not find second column. Please help

Isa Isa 2013-9-18

Hi, I have this code wt=xlsread('DataTest','sheet1'); datecol = 1; wt(:,datecol) = wt(:,datecol) + datenum('30-Dec-1899'); x=wt(:,1); qo=wt(:,2); plot(x,qo);

How do I use datetick to get the x (date axis) in day-month-year ('dd-mmm-yyyy') format? Thanks Isa

请先登录，再进行评论。

请先登录，再回答此问题。