Exporting simulation data in Multiple sheets in excel file.
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Mustafa Pasha
el 2 de Feb. de 2021
Comentada: Mustafa Pasha
el 4 de Feb. de 2021
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.
0 comentarios
Respuesta aceptada
Mathieu NOE
el 2 de Feb. de 2021
hello
see example below :
for k=1:10
xlswrite('Result.xlsx',rand(k),k);
writematrix(rand(k),'myData.xlsx','Sheet',k);
end
3 comentarios
Mathieu NOE
el 3 de Feb. de 2021
hllo
this is an example using either xlswrite or writematrix to store data in separates sheets in one single excel file
xlswrite is older , so use writematrix if you have a recent release
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!