How can I add chart in a specific sheet in an excel workbook via Matlab?
1 次查看(过去 30 天)
显示 更早的评论
I would like to add a chart in a specific sheet in an excel workbook via Matlab? Is this possible?
0 个评论
采纳的回答
Gareth Thomas
2016-10-4
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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!