Using a loop to write to excel
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Akzeptierte Antwort
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!