How can I add chart in a specific sheet in an excel workbook via Matlab?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
George Kouskoulis
il 4 Ott 2016
Commentato: George Kouskoulis
il 6 Ott 2016
I would like to add a chart in a specific sheet in an excel workbook via Matlab? Is this possible?
0 Commenti
Risposta accettata
Gareth Thomas
il 4 Ott 2016
There are a few ways of doing this:
- If you use MATLAB Spreadsheet link Spreadsheet link this will enable you from Excel to call MATLAB and bring in MATLAB plots
- Some people like using Excel graphs and use MATLAB to refresh the data. So if have the data in MATLAB, and writetable or xlswrite to a specific sheet, then you can have the Excel create a chart based on that range, all you need is to update the chart.
- It is also possible to control Excel from MATLAB via the COM interface, however this takes a little more work.
- It is also possible to create an excel add-in with MATLAB Compiler SDK, that takes your MATLAB function and embeds it in Excel.
4 Commenti
Gareth Thomas
il 4 Ott 2016
I believe you are looking for something like this. See this thread.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!