Make a graph with data from all sheets in excel

2 次查看（过去 30 天）
Jamie Shelley
Jamie Shelley 2016-7-21
评论： dpb 2018-3-9
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 个评论
显示 2更早的评论
noname
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
dpb 2018-3-9
Have to show the code that caused the error...post what you've tried and where ran into a problem.

请先登录，再进行评论。

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

采纳的回答

dpb
dpb 2016-7-21
编辑：dpb 2016-7-21
Sure, just use xlsinfo to return the sheet names in the spreadsheet and iterate over that collection. See
doc xlsfinfo
doc xlsread % for details
  2 个评论
Jamie Shelley
Jamie Shelley 2016-7-21
ah Thanks, I've just seen your answer, that seems similar to what I did (although I used xlsfinfo as opposed to xlsinfo), thanks!
dpb
dpb 2016-7-21
"I used xlsfinfo as opposed to xlsinfo"
That was a typo, there is no xlsinfo

请先登录，再进行评论。

更多回答（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