MATLAB7 interface with excel

2014 6 3
1 个回答
更新时间：2015 4 17
3 次查看（30 天）

0 个投票

I have MATLAB 7 (R14) and Excel 2010 on my machine. Is there a way to know which version of Excel is installed on a particular machine from within MATLAB R14?

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

回答（1 个）

Titus Edelhofer
Titus Edelhofer 2014-6-3

0 个投票

Hi,
you can use the ActiveX-Interface to query Excel:
x = actxserver('Excel.Application');
v = get(x, 'version')
delete(x);
Result:
v =
15.0
which translates to Excel 2013 (see e.g. http://en.wikipedia.org/wiki/Microsoft_Excel for the version numbers).
Titus

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Khalid Khan
Khalid Khan 2014-6-10
Titus, Thanks for replying. It does not work for MATLAB R14. Here is the message I get:
>> x = actxserver('Excel.Application');
??? Server Creation Failed: Server execution failed
Thanks Khalid
Mira
Mira 2015-4-17
Khalid, Do you remember how this issue got resolved? I'm getting the same error. Thanks.
Guillaume
Guillaume 2015-4-17
Khalid, for better visibility start your own question even if it's related to this one.
In any case, if actxserver fails, the issue is with Excel, not matlab.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by