Hello Michel,
Consider you have GUI " Test.m" and " Test.fig" files, along with your template " ABC.xlsx" file.
Keep all files in current directory of matlab. Now, for your GUI, there is pushbutton called ' OK'.
Consider, the template Excel file have three column ' Sr_No', ' Name', ' Age', which you want to update when you click on ' OK' push button.
so you need to update the following code into callback of pushbutton ' OK':
% --- Executes on button press in OK_.
function OK__Callback(hObject, eventdata, handles)
% hObject handle to OK_ (see GCBO)
% eventdata reserved - to be defined in a future version of MATLAB
% handles structure with handles and user data (see GUIDATA)
Sr_No = {'1';'2';'3';'4';'5'};
Name = {'A';'B';'C';'D';'E'};
Age = {'10';'11';'12';'13';'15'};
final_Data = [Sr_No,Name,Age];
xlswrite('ABC.xlsx',final_Data,'Sheet1','A2');
winopen('ABC.xlsx');
