Using a loop to write to excel
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a long list of variables in my workspace that I want to write to excel. I am just quoting few here:
List={'B_AfterEmerging','B_Assets1Before','B_Assets2Before','B_Assets3Before'}
I am using the following:
xlswrite('Final.xls',B_AfterEmerging,'BankruptcyData','a2'};
and it is working well. However since I have many sheets and many long lists I thought about writing a loop to export to excel
for i=1:length(List)
xlswrite('Final.xls',eval(sprintf(List{Count{i}})),'BankruptcyData',XX2{Count(i)});
end
I am receiving the following error: Cell contents reference from a non-cell array object.
obviously my second input should be the name of the variable (example B_AfterEmerging) but I am not managing to insert it properly. Any help will be greatly appreciated.
0 commentaires
Réponse acceptée
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!