In case anyone is interested, I worked out a way (although it's insanely inefficient as you shouldn't plot graphs inside loops but I couldn't find another way) I used: [~,sheets]=xlsfinfo('sheets.xlsx'); then used a for loop going between one and length(sheets), which I used to index the page number on xlsread and plot each graph, turning hold on, then ending so the next sheet can be plotted until the loop finishes.
Make a graph with data from all sheets in excel
2 次查看(过去 30 天)
显示 更早的评论
Every day I carry out a new experiment, each one corresponds to a seperate sheet on the same excel file. Is there a way of finding the data from each sheet to plot it all on one graph? Thanks
4 个评论
noname
2018-3-8
It gave me an error if I used xlsfinfo. I want to read all the spreadsheet in the same excel file and plot each spreadsheet, not plot them in one graph. Can anyone give an example how to do it? Thanks alot.
dpb
2018-3-9
Have to show the code that caused the error...post what you've tried and where ran into a problem.
采纳的回答
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!