Plot from excel sheet to matlab

854 次查看（过去 30 天）
Hilbrand Swieringa
Hilbrand Swieringa 2015-9-23
评论： 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 个评论
OMAR EL MZOURI
OMAR EL MZOURI 2023-5-24
Hello, I need a help for how can I plot a graph from excel data in real time?

请先登录，再进行评论。

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

采纳的回答

Jae Song
Jae Song 2015-9-23
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);
  3 个评论
显示 1更早的评论
Markus M.
Markus M. 2022-12-12
This was so helpful, thank you
Clara Casado-Coterillo
Clara Casado-Coterillo 2023-9-13
And if you only need a few cells of the sheet in the Excel, how can you extract them with readtable function?
Former xlsread used the last argument ['B' num2str(i+2) ':C' num2str(i+2)] to tell Matlab to search from cell B3...
THANKS

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by