Save data into excel in standalone app

Question

Oddineus 2019-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/454658-save-data-into-excel-in-standalone-app

回答： BhaTTa 2025-8-14

Hello everyone.

i'm trying to make an app that will generate data then save it in exiting excel file, however in the matlab it works fine with me.

but when i convert it to standalone app the program will always save the data on the same cell in the excel file.

here is the code i used to reach the excel file.

           %% ~.
[~,~, existingData] = xlsread('Results.xlsx');
N = size(existingData,1);
% add the new values (your input) to the end of Excel file
CC0=strcat('A',num2str(N+1));
CC1=strcat('B',num2str(N+1));
CC2=strcat('C',num2str(N+1));
CC3=strcat('D',num2str(N+1));
CC4=strcat('E',num2str(N+1));
CC5=strcat('F',num2str(N+1));
CC6=strcat('G',num2str(N+1));
CC7=strcat('H',num2str(N+1));
CC8=strcat('I',num2str(N+1));
CC9=strcat('J',num2str(N+1));
CC10=strcat('K',num2str(N+1));
CC11=strcat('L',num2str(N+1));
% disp(N);
xlswrite('Results.xlsx',app.NEW3,'Sheet1',CC0);
xlswrite('Results.xlsx',app.NEW1,'Sheet1',CC1);
xlswrite('Results.xlsx',app.AGE1,'Sheet1',CC2);
xlswrite('Results.xlsx',app.Gender,'Sheet1',CC3);
xlswrite('Results.xlsx',app.NEW2,'Sheet1',CC4);
xlswrite('Results.xlsx',app.GDTT1,'Sheet1',CC5);
xlswrite('Results.xlsx',app.GDTT2,'Sheet1',CC6);
xlswrite('Results.xlsx',app.GDTT3,'Sheet1',CC7);
xlswrite('Results.xlsx',app.GDTT4,'Sheet1',CC8);
xlswrite('Results.xlsx',app.GDTT5,'Sheet1',CC9);
xlswrite('Results.xlsx',app.GDTT6,'Sheet1',CC10);
xlswrite('Results.xlsx',app.AVERAGE,'Sheet1',CC11);
 
   closereq