Info

此问题已关闭。 请重新打开它进行编辑或回答。

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

1 次查看（过去 30 天）
chlor thanks
chlor thanks 2016-7-27
关闭： chlor thanks 2016-7-27
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 个评论
dpb
dpb 2016-7-27
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.

此问题已关闭。

回答（0 个）

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by