MATLAB7 interface with excel

10 次查看（过去 30 天）
Khalid Khan
Khalid Khan 2014-6-3
评论： Guillaume 2015-4-17
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
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更早的评论
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.

请先登录，再进行评论。

类别

在 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