Plot from excel sheet to matlab
1.316 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hilbrand Swieringa
am 23 Sep. 2015
Kommentiert: Clara Casado-Coterillo
am 13 Sep. 2023
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 Kommentar
OMAR EL MZOURI
am 24 Mai 2023
Hello, I need a help for how can I plot a graph from excel data in real time?
Akzeptierte Antwort
Jae Song
am 23 Sep. 2015
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 Kommentare
Clara Casado-Coterillo
am 13 Sep. 2023
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
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!