Reading excel file in MATLAB (GUI)
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Hi, I want to read two values in an excel sheet and sum these values by pressing (Push_button) but I am getting an (??? XLSREAD unable to open file Data_sheet.xls.) and stating that the file is not found. my code is :
a=xlsread(‘G:\Master\Program\Calculator\Data_sheet.xls’,'B5′);
b=xlsread(‘G:\Master\Program\Calculator\Data_sheet.xls’,'B6′);
c=a+b;
set(handles.text1,'string',c);
why I am having this error? and how can I come over it ? please help ?
0 Kommentare
Akzeptierte Antwort
Weitere Antworten (2)
Vishnu Swaroop
am 4 Jun. 2012
put the file in your matlab folder and say : a=xlsread('Data_sheet.xls')
This should work out fine, but using 'B5' like that won't help. Try instead: a=xlsread('Data_sheet.xls','B5:B6')
This should give 'a' as an array with the two elements that you want to add as : c=a(1)+a(2)
Hope this helps.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets 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!