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

1 view (last 30 days)
How do I write in different cell locations each time xlswrite function is executed in a for loop?

Accepted Answer

Oleg Komarov
Oleg Komarov on 8 Feb 2011
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

More Answers (1)

vish
vish on 8 Feb 2011
Can you pleas elucidate on XLSrange with a small example. Thank you.

Tags

Community Treasure Hunt

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

Start Hunting!