Plot from excel sheet to matlab
1.297 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Hilbrand Swieringa
il 23 Set 2015
Commentato: Clara Casado-Coterillo
il 13 Set 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 Commento
OMAR EL MZOURI
il 24 Mag 2023
Hello, I need a help for how can I plot a graph from excel data in real time?
Risposta accettata
Jae Song
il 23 Set 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 Commenti
Clara Casado-Coterillo
il 13 Set 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
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Data Import from MATLAB in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!