Undefined function or variable 'Sheets'.
14 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!