plot excel data in MATLAB

115 次查看（过去 30 天）

Samer Husam 2012-7-14

2
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/43605-plot-excel-data-in-matlab

评论： Image Analyst 2017-5-15

hi all, I have two column in excel I want to plot them by using matlab, lets say I have first column from A1-A10 and second column from B1-B10. how could I plot them in MATLAB ?? please help..

采纳的回答

Azzi Abdelmalek 2012-7-14

7
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/43605-plot-excel-data-in-matlab#answer_53520

在 MATLAB Online 中打开

[v,T,vT]=xlsread('name.xls') 
% 'xlsx' for exell 2007
%v: Double
%T and vT : cell
%use v containing numbers 
t=v(:,1);y=v(:,2)
%if u have to plot second colone depending on first:
plot(t,y)

11 个评论
显示 9更早的评论隐藏 9更早的评论

Azzi Abdelmalek 2012-7-18

maby you are ploting num(6:16,1) wich is false,you must use num(:,1)) for the first row and num(:,2) for the second. i don't think you will have an error message

Samer Husam 2012-7-20

thanks a lot Azzi, walter and image analyst for your help... this is the correct answer, another request how to show the value of the cell if I have time value in my excel file ?? like the excel value is 12.30 ?? how to put in the graph ?

请先登录，再进行评论。

更多回答（2 个）

Image Analyst 2012-7-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/43605-plot-excel-data-in-matlab#answer_53506

编辑：Image Analyst 2012-7-14

在 MATLAB Online 中打开

Use xlsread() to get the entire contents of your workbook into a cell array.

[num,txt,raw] = xlsread(filename); % From the help

Then use cell2mat or something to extract out columns into an x array and a y array.

x = cell2mat(num(1:10, 1)); % Untested
y = cell2mat(num(1:10, 2)); % Untested

Then, to plot, use

plot(x,y);

9 个评论
显示 7更早的评论隐藏 7更早的评论

Walter Roberson 2012-7-17

What does size(num) show? And please show your xlsread() command so we are sure we are talking about the same options.

andhavarapu lokesh 2017-3-6

I wanted to plot a excel sheet in matlab is there any method to scale the xaxis and yaxis commonly to all the sheets

请先登录，再进行评论。

arif hussain 2017-5-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/43605-plot-excel-data-in-matlab#answer_266976

Hello; Can someone please help me matlab doesn't plot my excel data it show the axis only.i have attested the excel file as well.

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

dpb 2017-5-15

Almost certainly a spellcheck miss from a non-English speaker attempting "attached".

Image Analyst 2017-5-15

I guess that makes sense, instead of "verified". However the file was NOT attached - only a screenshot was displayed, no Excel file was attached. Use the paperclip icon.

请先登录，再进行评论。

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