Plot from excel sheet to matlab
659 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hilbrand Swieringa
el 23 de Sept. de 2015
Comentada: Clara Casado-Coterillo
el 13 de Sept. de 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 comentario
OMAR EL MZOURI
el 24 de Mayo de 2023
Hello, I need a help for how can I plot a graph from excel data in real time?
Respuesta aceptada
Jae Song
el 23 de Sept. de 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 comentarios
Clara Casado-Coterillo
el 13 de Sept. de 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
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!