Matlab GUI displaying output based on user input
2 views (last 30 days)
Show older comments
i want to create one gui with two prompt messages 1. enter semester - I marks 2. enter semester - II marks
After entering marks & pressing OK button . it has to verify one excel file (having three columns of data). When the input data matches with the A column and B column values in excel file then the output is the corresponding C Column value. Display the output of C column's value.
any one help me to write the code for this
0 Comments
Accepted Answer
David Sanchez
on 20 Aug 2013
M = xlsread('my_file.xls'); % matrix with data
x=find(M(:,1) == in_1); % in_1 is your first input
y=find(M(:,2) == in_2); % in_1 is your second input
c=find(x==y); % c returns where x==in_1 and y ==in_2
output = M(x(c),3);
3 Comments
David Sanchez
on 20 Aug 2013
In your case:
in_1 = str2num(ans{1});
in_2 = str2num(ans{2});
M = a;
More Answers (1)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!