Write and retrieve text box values to/from excel file

6 views (last 30 days)
ahmed obaid
ahmed obaid on 14 Mar 2016
Commented: Geoff Hayes on 3 Nov 2020
Dear users ,
i would like to store the values of two text box in GUI the first text box1 values are number ( i.e. 1 , 2 , 3 , 4 , ..etc) and the second text box2 values are string like ( i.e. wilyam staling , john park , ..etc ) the value of number 1 of text box 1 correspond to text values name of wilyam staling and so on ..
my question .. i need when i inter number 1 in first text box for example and press (botton) then name wilyam staling will appear in second text box .. thanks for help
  2 Comments
ahmed obaid
ahmed obaid on 14 Mar 2016
Sir , x= values of text box 1 value , y= text box 2 value , xlwrite ( Exl file , cellA , 'x value ' , ' cell B ' , 'y value '); A = A+1 , B = B+1 , then ..
after i inter some value after clear text box 1 for example if i inter 1 , then command will read the values of A columns when value match inter number then values of B will appear in text box2

Sign in to comment.

Accepted Answer

Geoff Hayes
Geoff Hayes on 14 Mar 2016
Ahmed - can you post some of your code? It seems as if you are using your GUI to write and read from an Excel spreadsheet. If that is the case and you know how to write to the file, then is it the reading from file that is causing a problem? Suppose the user has entered a number into the edit1 text control and pressed a button whose callback is
function pushbutton1_Callback(hObject, eventdata, handles)
% read from the Excel file
[~,~,rawData] = xlsread(handles.excelFileName);
% get the value from edit1
id = str2num(char(get(handles.edit1,'String')));
% get the index of id in the first column of rawData
rowIndex = find(rawData(:,1) == id);
if ~isempty(rowIndex)
% get the name
userName = rawData(rowIndex,2);
% set the name
set(handles.edit2,'String',userName);
end
The above is untested, but I think that you can use it for your purposes. I've made some assumptions concerning the names of your controls, the name of the Excel file (presumably stored as a string within the handles structure), and the fact that the data is stored as two columns.

More Answers (1)

Md Iqbal
Md Iqbal on 30 Oct 2020
Errer using ==>fecal Error<a Error in ==>guidefunc at 15
  1 Comment
Geoff Hayes
Geoff Hayes on 3 Nov 2020
Please remove this as an "answer" and post as either a comment (to the above) or as a new question.

Sign in to comment.

Tags

Products

Community Treasure Hunt

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

Start Hunting!