Thread Subject:

xlswrite in varying cells

Dear matlab users,

I want to make an xlswrite in a varying area, specifically, I want to write some outputs on B1:D1, then B2:D2 unit B3000:D3000. I think I can do this with a loop but I don't know how exactly I should insert the "time varying" writing areas (B{i}:E{i}) in the xlswrite command,

An example which does not seem to work:

[res]=jump(y,3)

for i=1:3000
B{i}=strcat('B',num2str(i));
E{i}=strcat('E',num2str(i));
xlswrite('RESULTS',res,'ResultsSheet','B{i}:E{i}');
end

Thank you for your help


PS. the res variable is time varying too but I didn't show that in order to keep things simple, so in the above example the same output is written each time.