Loop to spit out consecutive values into excel
显示 更早的评论
So I have a loop, that sifts through data, and every round of the loop, a new piece of data is calculated. I know with xlswrite I can put the data into an excel spreadsheet each time by specifying the sheet and cell, but every time I run the loop the new data will replace the old data. How do I make it so that the first time the loop runs it puts it in the first cell, and the second round it'll put it in next cell underneath it (and so on...)?
Thanks!
回答（1 个）
Sean de Wolski
2011-7-6
The easiest way would just to keep a counter
count = 1;
for ii = 1:10;
%generate stuff
xlswrite(stuff,sprintf('A%i:A%i',count,count+length(stuff)));
count = count+length(stuff)+1;
end
3 个评论
Michael
2011-7-6
Sean de Wolski
2011-7-6
Try running just this:
count = 1;
for ii = 1:10;
stuff = rand(ceil(rand*10),1);
sprintf('A%i:A%i',count,count+length(stuff))
count = count+length(stuff)+1;
end
stuff will be a vector somewhere between 1 and 10 elements long. The output from sprintf is telling it what cells to put it in A1:A2,A3:A11 etc..
Ashish Uthama
2011-7-8
How large is your data? I would strongly recommend building up the cell array in the loop and then calling xlswrite just once after the loop.
类别
在 帮助中心 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
