How can I get an Excel with differentes rows each time I write a name in a GUI and I press the buttom "Save" to save the information in a row of an Excel file?
1 view (last 30 days)
Show older comments
I want to write information of patients (name, surname, telephone, etc) and I want to safe that information on an Excel each time I press the buttom Save in a GUI. How can I do that?
0 Comments
Answers (1)
ES
on 26 Jun 2017
in the callback function of the save button, you will do an xlswrite.
Something like this:
function SaveButton_Callback(hObject, eventdata, handles)
persistent rowno;
sPatientName = get(handles.editbox1,'String');edit box with patient name
sPatientAge = num2str(get(handles.editbox2,'String'));edit box with patient age
...all other data you need
xlswrite('PatientData.xlsx', {sPatientName, sPatientAge}, 'Sheet', ['A',num2str(rowno)]);
rowno = rowno+1;
2 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!