How can I add chart in a specific sheet in an excel workbook via Matlab?

2 次查看（过去 30 天）
George Kouskoulis
George Kouskoulis 2016-10-4
评论： George Kouskoulis 2016-10-6
I would like to add a chart in a specific sheet in an excel workbook via Matlab? Is this possible?

请先登录，再回答此问题。

采纳的回答

Gareth Thomas
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 个评论
显示 2更早的评论
George Kouskoulis
George Kouskoulis 2016-10-6
Thank you very much Thomas!
I saw the thread and my problem is solved.
Another question is that whether you can create a chart in a excel workbook with many sheets and the data for your chart come from more than one sheets of the workbook?
Thank you in advance!

请先登录，再进行评论。

更多回答（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!

Translated by