Reading excel file in MATLAB (GUI)

5 views (last 30 days)
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 ?

Accepted Answer

Samer Husam
Samer Husam on 29 May 2012
a=xlsread(G:\Master\Program\Calculator\Data_sheet.xls,'Sheet1','B5′);
b=xlsread(G:\Master\Program\Calculator\Data_sheet.xls,'Sheet1','B6′);
c=a+b;
set(handles.text1,'string',c);

More Answers (2)

Samer Husam
Samer Husam on 29 May 2012
any suggestions please ?

Vishnu Swaroop
Vishnu Swaroop on 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.

Tags

Community Treasure Hunt

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

Start Hunting!