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?

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?

Answer 1

[ES]

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;

[Collegue]

I HAVE THIS FUNCTION AND IT DOESN'T WORK. WHAT CAN I DO?

function Guardar_Callback(hObject, eventdata, handles)

global numero
% hObject    handle to Guardar (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
numero=0;
numero=numero+1;
persistent rowno;
data.nombre=get(handles.edit1,'String');
data.apellido=get(handles.edit2,'String');
data.registro=get(handles.edit3,'String');
data.fecha=get(handles.dateEditBoxHandle,'String');
xlswrite('D:\interfaz\DATOS_PACIENTES.xlsx',{'Nº','Nombre','Apellido','Registro','Fecha'} ,'Hoja1','A1');

xlswrite('D:\interfaz\DATOS_PACIENTES.xlsx', {numero,data.nombre,data.apellido,data.registro,data.fecha}, 'Hoja1', ['A',num2str(rowno)]); rowno = rowno+1;

[ES]

What is the error u get?