Loop to spit out consecutive values into excel
4 ビュー (過去 30 日間)
古いコメントを表示
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!
0 件のコメント
回答 (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 件のコメント
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.
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!