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?

Answer 1

[Titus Edelhofer]

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

[Khalid Khan]

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]

Khalid, Do you remember how this issue got resolved? I'm getting the same error. Thanks.

[Guillaume]

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.