MATLAB: Exporting simulation data in Multiple sheets in excel file.

excel sheetsmultiple results in one excel.

Hi
I've been trying to export results data into multiple excel file.
I've 35 variable which are perturbed individually to see their impact ont eh remaing one. For each perturbation the code is making an excel file, which gives me 35 files. Is tehre anyway I can export the data of each perturbation effect on 35 sheets ratehr than 35 files. Follwoing is the code I'm using.
sheet=1;
xlRange='A2';
xlswrite(filename,Results_Values,sheet,xlRange);
sheet=1;
xlRange='A1';
xlswrite(filename,Results_Names,sheet,xlRange);
clear xlRange sheet xlRange sheet Results_Values Results_Names filename str values2 values
winopen('Output.xls');
Thanks.

Best Answer

hello
see example below : 
for k=1:10
     xlswrite('Result.xlsx',rand(k),k);
    writematrix(rand(k),'myData.xlsx','Sheet',k);
end
Related Question