Copy graphs from Excel to GUI
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
chlor thanks
le 7 Juil 2016
Commenté : chlor thanks
le 7 Juil 2016
My task involves to copy an excel plot from say... worksheet3 named "X_Plot" of an excel file (D:\Files\Excel Plots.xlsx) directly to a GUI axes for display.
I wonder if this is possible? If so, what steps can I take and what syntax can be used?
If not, what should be done?
Thank you for reading my concern and I will really appreciate any guidance on this :)
2 commentaires
Geoff Hayes
le 7 Juil 2016
chlor - are the Excel graphs generated using data from the Excel worksheets?
Réponse acceptée
Guillaume
le 7 Juil 2016
Modifié(e) : Guillaume
le 7 Juil 2016
Excel charts and matlab figures are two very different beasts. There is no easy way to convert one to the other.
As per Geoff's question, you could copy the source data of the chart and regenerate the plots in matlab instead. If you really wanted to, you could query the properties of the chart and its subobjects (lines, axes, etc.) and try to match that with their nearest equivalent in matlab, but it's probably a lot more work than you just recreating the graph from scratch.
Alternatively, you could copy the chart as a picture and display that as an Image in matlab but that would not be editabla and is probably not what you want.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!