Undefined function or variable 'Sheets'.

26 views (last 30 days)
Adriano
Adriano on 9 May 2017
Commented: Nuttaphon Magteppong on 6 Mar 2024 at 5:20
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 Comments
Adriano
Adriano on 20 Feb 2018
Excel doesn't open any pop up but the problem persist.
Nuttaphon Magteppong
Nuttaphon Magteppong on 6 Mar 2024 at 5:20
I have found this problem. Do you have the solution

Sign in to comment.

Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!