Plot from excel sheet to matlab

Question

Hilbrand Swieringa 2015-9-23

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/244650-plot-from-excel-sheet-to-matlab

评论： Clara Casado-Coterillo 2023-9-13

Hello everybody,

Yesterday I had the question to get mean gray level value into an excel sheet. After the help I managed to get it work. Now i have the following question.

I can plot in Excel but I know that matlab can do it for me.

I found the following code,

       % [num, txt, raw] = xlsread('mean_gray_level_value.xlsx', 1);
       % plot(num)
       % num = sort(num);
       % for i = 1:numel(num)
       % NumCell(i) = {num2str(num(i))};
       % end
       % set(gca,'Xtick',1:numel(num),'XTickLabel',txt, 'Ytick', num,'YTickLabel',NumCell)

Can someone help me to plot from data of an excel sheet? the y axis must be from 0 to 255 the x axis must be the number of the analysis.

I hope you can help me,

Kind regards

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

OMAR EL MZOURI 2023-5-24

Hello, I need a help for how can I plot a graph from excel data in real time?

请先登录，再进行评论。

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

Answer 1

Jae Song 2015-9-23

6
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/244650-plot-from-excel-sheet-to-matlab#answer_193472

在 MATLAB Online 中打开

testData.xlsx

You can simply read data in an Excel file using the readtable function.

Then, read the column data as X and Y variables into Matlab. ( Use the column header names in the Excel file to extract values. Please see the example below)

Use the plot function to create a plot.

%: Read the excel file using readtable function
rawTable = readtable('testData.xlsx','Sheet','Sheet1');
x = rawTable.Header1; %: get the excel column, Header1 (header name)
y = rawTable.Header2; %: get the excel column, Header2 (header name)
figure;
plot(x,y);