How do I write in different cell locations each time xlswrite function is executed in a for loop?

2011 2 8
2 个回答
回答已采纳
4 次查看（30 天）

 采纳的回答

Oleg Komarov
Oleg Komarov 2011-2-8

0 个投票

Specify the range in Excel format:
xlswrite(filename, M, range)
To help specifying the range I use XLSrange
An example (really basic, and optimizable):
for ii = 1:4
% Create random matrix
A = rand(ii);
% toplefts
toplefts = cumsum(0:ii-1)+1;
% Range
range = XLSrange(size(A),[toplefts(ii),1]);
xlswrite('C:\Users\Oleg\Desktop\trial.xlsx',A,'Sheet1',range)
end
Oleg

更多回答（1 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by