Undefined function or variable 'Sheets'.

7 次查看（过去 30 天）
Adriano
Adriano 2017-5-9
评论： Nuttaphon Magteppong 2024-3-6
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更早的评论
Adriano
Adriano 2018-2-20
Excel doesn't open any pop up but the problem persist.
Nuttaphon Magteppong
Nuttaphon Magteppong 2024-3-6
I have found this problem. Do you have the solution

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 ActiveX 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by