MATLAB Answers

Undefined function or variable 'Sheets'.

33 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)

Community Treasure Hunt

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

Start Hunting!