How to save gui data in excel

Question

nur iman athilah 2021-3-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/759189-how-to-save-gui-data-in-excel

评论： nur iman athilah 2021-3-3

How can i save the gui data into excel? and I want it to be save into new row everytime i click the save button. I tried this but it just in same row everytime.

rownumber=xlsread('COLONPOLYPS.xlsx');
%code code code
%then, in the end:
rownumber=rownumber+1;
xlswrite('COLONPOLYPS.xlsx',arr);

2 个评论
显示无隐藏无

Mathieu NOE 2021-3-3

hello

no surprise , as it seems you don't specify the range where to write the data, so xlswrite keeps overwritting in the first row

you have to specify the range : xlswrite(FILE,ARRAY,SHEET,RANGE)

also xlswrite is outdated, please consider using writetable

nur iman athilah 2021-3-3

在 MATLAB Online 中打开

i changed the code. But why the data didnt save in new row when i click the save button.

   xlworkbook = xlApp.Workbooks.Open('colon.xlsx');
   xlsheet = xlworkbook.ActiveSheet;
   mydata=arr;
   data=xlsread('colon.xlsx');
   %Determine last row
   last=size(data );
   newRange=last+1;
   xlCurrRange = xlsheet.Range(['A', num2str(newRange),':J', num2str(newRange)]);
   xlCurrRange.Value2 = mydata;
   %Save and Close the Excel File
   invoke(xlworkbook,'Save');
   invoke(xlApp,'Quit');
   xlApp.delete;