How can I export the results to Excel for all loop steps ?
1 view (last 30 days)
Show older comments
I used this xlswrite('D:\data.xlsx','SINR'); to save the result in excel file but I couldn't save it for all loop steps its always save the last step's result. i would appreciate your help if you could help me with this
thanks in advance
1 Comment
Sulaymon Eshkabilov
on 30 Apr 2022
First of all, it is advised to use writematrix() instead of xlswrite due to high efficiency.
Second, if possible, avoid using a loop for efficiency purposes again. If not avoidable, then 'append' option has to be employed - see this simple example code:
for ii = 1:10
x = ii+1;
writematrix([x,ii], 'LOOP_Data.xlsx', 'writemode', 'append');
end
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!