I already had a GUI which solves formula my problem how do i load and read the excel to my GUI?anyone can help?
1 次查看(过去 30 天)
显示 更早的评论
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);
0 个评论
回答(1 个)
Héctor Corte
2012-1-17
I have just uploaded a file into Matlab FileExchange to this kind of questions. You can check it out here:
It has almost every function you will need to work with Excel and Itself is an example of how to do it.
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!