Info
Questa domanda è chiusa. Riaprila per modificarla o per rispondere.
Is there a way for matlab to detect which sheet the plot is using in excel?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
dpb
il 27 Lug 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.
Risposte (0)
Questa domanda è chiusa.
Vedere anche
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!