Reading excel file in MATLAB (GUI)

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 ?

Answer 1

[Samer Husam]

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);

Answer 2

[Samer Husam]

any suggestions please ?

Answer 3

[Vishnu Swaroop]

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.