MATLAB Answers

Undefined function or variable 'Sheets'.

21 views (last 30 days)
Adriano
Adriano on 9 May 2017
Commented: Adriano on 20 Feb 2018
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!

  6 Comments

Show 3 older comments
Jan
Jan on 9 May 2017
Dear dpb, I need some time to understand terms like "know nuthink!"
Guillaume
Guillaume on 9 May 2017
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 on 20 Feb 2018
Excel doesn't open any pop up but the problem persist.

Sign in to comment.

Answers (0)