Reading excel file in MATLAB (GUI)
4 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
更多回答(2 个)
Vishnu Swaroop
2012-6-4
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 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!