plot date from excel file

2012 7 26
2 个回答
5 次查看（30 天）

0 个投票

hi all, I am trying to plot power vs time in my program, these values are taking from excel file, but I am having different values for the time compare with values in excel, the time format is (HH:MM)and my code is:
[num,T,vT] = xlsread(excle.xls,'Sheet1'); % reading excel
x = num(:,1); % Time column
y = num(:,4); % power column
plot(handles.axes,x,y);
how can I over come this issue ??? please help and advice...

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Conrad
Conrad 2012-7-26
Can you give a concrete example of what the time looks like in Excel and then in Matlab?
Sumit Tandon
Sumit Tandon 2012-7-26
Not sure if I understand the question correctly. Are you having issues with the FORMAT of date in Excel vs MATLAB? You could use functions like DATENUM or DATEVEC to change the format and then plot as per your requirements.
Samer Husam
Samer Husam 2012-7-26
conrad: the time value is read from MATLAB it something like: 12:00, 12:15, 12:30 and so on. when I use the code that I post above, I get numeric values like 0.5, 0.51... so how can I display the time values from the excel ??
LukeS: I have tried to use the datenum but what I couldn't get it correctly, can you please show me how to use it ?

请先登录，再进行评论。

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

回答（2 个）

Thomas
Thomas 2012-7-26

0 个投票

Something like this
x={'12:00','12:15','12:30','12:45'}; %time
y=[0.5 0.8 0.3 0.6] % values
time_out=datenum(x,'HH:MM'); %convert time to datenum
plot(time_out,y)
datetick('x','HH:MM') % show datetick on xaxis

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Samer Husam
Samer Husam 2012-7-26
the values of x and y is not in array, so when i am using your answer i am getting an error, this what I am doing:
[num,T,vT] = xlsread(excle.xls,'Sheet1'); % reading excel
x = num(:,1); % Time column
y = num(:,4); % power column
x1= datenum(x,'HH:MM'); %convert time to datenum
plot(x1,y)
but I am getting an error.. so how can I over come this??? and thanks for your answer
Thomas
Thomas 2012-7-26
what error are you getting and can you show how x is in MATLAB?
Samer Husam
Samer Husam 2012-7-26
the error i am getting is:
The input to DATENUM was not an array of strings.
Thomas
Thomas 2012-7-26
so what is your 'x'? Can you show an example of 'x' as it is imported in matlab. also what is the output of
whos x
Samer Husam
Samer Husam 2012-7-26
编辑：Samer Husam 2012-7-26
x is the time values to be read from excel (ex: 12:00 and 12:15)
y is the power values also to be read from excel.

请先登录，再进行评论。

Samer Husam
Samer Husam 2012-7-28

0 个投票

is it possible to use datetick function is this ?? please help...

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by