Info

Diese Frage ist geschlossen. Öffnen Sie sie erneut, um sie zu bearbeiten oder zu beantworten.

Is there a way for matlab to detect which sheet the plot is using in excel?

1 Ansicht (letzte 30 Tage)
chlor thanks
chlor thanks am 27 Jul. 2016
Geschlossen: chlor thanks am 27 Jul. 2016
This may sounds confusing, so here is an example.
I have an excel file with hundreds of sheets, each sheet has a unique name.
I have a sheet named "plot1" with nothing but a plot inside the sheet, the plot is created from another sheet named "sheet104" from the same excel file.
I would like to recreate this plot in excel, and I know nothing more than the fact that the plot is in a sheet called "plot1", is there a way for matlab to automatically detect which sheet the plot is made from? In this case, if I tell matlab I would like to recreate "plot1", it will automatically detect that the data is from sheet "sheet104"?
I am not sure if this is possible or is there a way to do so. But any advice is appreciated. Thank you!
  2 Kommentare
dpb
dpb am 27 Jul. 2016
That's actually an Excel question, not Matlab. You'd have to find some VBA or other property within Excel that could be queried through and ActiveX connection that can find out what is the data source for the plot on the given sheet in the workbook at the time you query it. Undoubtedly the facility exists, but it'll take delving thru the Excel doc to figure out how...or post the question to an Excel group or search MSDN.

Antworten (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by