Undefined function or variable 'Sheets'.

2017 5 9
0 个回答
更新时间：2024 3 6
3 次查看（30 天）

0 个投票

Hello! I'm using this code to get formulas from excel sheet:
excel = actxserver('Excel.Application');
excel.DisplayAlerts = false;
ibsex = excel.Workbooks.Open(filename);
pause(5)
ibssheet = ibsex.Sheets.Item('DATA');
line = strcat('B',num2str(today_row+1),':FP',num2str(today_row+1));
formulas = ibssheet.Range(line).Formula;
ibsex.Close
pause(5)
excel.Quit
pause(5)
the problem is that i recive the error "Undefined function or variable 'Sheets'" when Matlab is executing the line:
ibssheet = ibsex.Sheets.Item('DATA');
How Can I fix the problem? many thanks!

7 个评论
显示 5更早的评论 隐藏 5更早的评论

Walter Roberson
Walter Roberson 2017-5-9
What happens if the Open fails?
Adriano
Adriano 2017-5-9
编辑：Adriano 2017-5-9
The Open never fails. The Item code fails. Sometimes I recive also this error:
Undefined function 'Item' for input arguments of type 'Interface.000208D7_0000_0000_C000_000000000046'.
dpb
dpb 2017-5-9
I "know nuthink!" about Excel macro language syntax, but is 'DATA' extant or correct argument? Should single be double quotes?
Just throwing out stuff...
Jan
Jan 2017-5-9
Dear dpb, I need some time to understand terms like "know nuthink!"
Guillaume
Guillaume 2017-5-9
编辑：Guillaume 2017-5-9
I would recommend commenting out the DisplayAlerts = false in case excel actually shows an alert and instead having
%excel.DisplayAlerts = false; %leave on for debugging
excel.Visible = true;
Does anything pop up in excel?
Adriano
Adriano 2018-2-20
Excel doesn't open any pop up but the problem persist.
I have found this problem. Do you have the solution

请先登录，再进行评论。

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

回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 ActiveX 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by