MATLAB7 interface with excel

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 个)

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 个评论

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
Khalid, Do you remember how this issue got resolved? I'm getting the same error. Thanks.
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.

请先登录,再进行评论。

产品

Community Treasure Hunt

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

Start Hunting!

Translated by