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

3 次查看（过去 30 天）

显示更早的评论

George Kouskoulis 2016-10-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305654-how-can-i-add-chart-in-a-specific-sheet-in-an-excel-workbook-via-matlab

评论： George Kouskoulis 2016-10-6

采纳的回答： Gareth Thomas

I would like to add a chart in a specific sheet in an excel workbook via Matlab? Is this possible?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Gareth Thomas 2016-10-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305654-how-can-i-add-chart-in-a-specific-sheet-in-an-excel-workbook-via-matlab#answer_237271

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更早的评论隐藏 2更早的评论

Gareth Thomas 2016-10-4

I believe you are looking for something like this. See this thread.

See this

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!

请先登录，再进行评论。