I already had a GUI which solves formula my problem how do i load and read the excel to my GUI?anyone can help?

I already had a GUI which solves formula for power,h,q,elavation.... my problem how do i read all the data in excel(consider the table of data is already in excel).. and whatever the result in the GUI will match the table of data in excel? anyone can help?

for example result on gui is 750.. then my table(table data below)will read the excel and give result the corresponding equivalent such as 750 equivalent will be 250...

H                  EL
800                300
775                280                
750                250         
725                175
700                100

sample code :

a = get(handles.input1_gamma,'String'); %GAMMA
b = get(handles.input2_h,'String');    %H
c = get(handles.input3_q,'String');     %Q
d = get(handles.input4_power,'String');  %POWER
e = get(handles.input5_eout,'String');

% a and b are variables of Strings type, and need to be converted 
% to variables of Number type before they can be added together

out = str2num(b) + str2num(e);
set(handles.equalel,'String',out);

Answer 1

[Héctor Corte]

I have just uploaded a file into Matlab FileExchange to this kind of questions. You can check it out here:

http://www.mathworks.de/matlabcentral/fileexchange/34631-example-of-how-to-save-or-read-data-to-an-excel-archive

It has almost every function you will need to work with Excel and Itself is an example of how to do it.