MATLAB Answers

Using a loop to write to excel

3 views (last 30 days)
joseph Frank
joseph Frank on 26 Aug 2013
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 Comments

Sign in to comment.

Accepted Answer

Leah
Leah on 26 Aug 2013
Count is not a cell array but you reference it as one using {i}

  0 Comments

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!