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

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

Answer 1

[Oleg Komarov]

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

Answer 2

[vish]

Can you pleas elucidate on XLSrange with a small example. Thank you.