can use xlswrite in for loop without overwriting?

i need to write values of every iteration from loop and get saved in excel file one by one order..its like appending..is it possible in matlab?

[SANDEEP KUMAR]

Yes it is possible. follow the code, Here objective is writing these variables value in excel sheet.%%CODE START FROM HERE%%

x1=[1,2,3,4,5]; x2=[5,6,7,8,9];

for ii=1:5 X1=x1(1,ii); X2=x2(1,ii); filename = 'Results.xlsx'; Variables= {X1,X2}; sheet = 1; xlRange= sprintf( 'A%s',num2str(ii) ); xlswrite(filename,Variables,sheet,xlRange) end %% Arranging row wise

[Image Analyst]

Sandeep, can you put your answer (to this 5 year old question) down in the Answers section below (so you can get credit for it)? Though please format your code first.

Answer 1

[David Sanchez]

With xlswrite, you can define the cell where your data will be written, like in the following example, that write mixed text and numeric data to testdata2.xls, starting at cell E1 of Sheet1:

d = {'Time','Temperature'; 12,98; 13,99; 14,97};
xlswrite('testdata2.xls', d, 1, 'E1')

Change the destination cell dynamically in your for-loop. Example:

for k=1:20
 x = rand;
 my_cell = sprintf( 'A%s',num2str(k) );
 xlswrite('my_xls.xls',x,my_cell);
end

[sandy]

thanks David...,,,see this link..have another question where i stucked.. http://www.mathworks.in/matlabcentral/answers/84633-how-to-save-in-specific-row-and-column-with-this-code-in-excel

[Anand Ganesan]

To get it to write into one column:

for k=1:3

x = rand;

my_cell = sprintf( 'A%s',num2str(k) )

my_cell=[my_cell ':' my_cell];

xlswrite('my_xls.xls',x,my_cell);

end

for k=1:3
    x=rand
    my_cell=sprintf('A%s,num2str(k)')
    my_cell=[my_cell ':' my_cell]
    xlswrite('my_xls.xls',x,my_cell)
end

Answer 2

[Image Analyst]

You definitely don't want to use xlswrite() in a loop of more than about 3 iterations unless you are willing to wait forever. Use xlswrite1() in the File Exchange, where you can use ActiveX - it will be so much faster.

[sandy]

is xlswrite1() can save each iteration values without overwriting them? can you see this link and help me with my code..

. http://www.mathworks.in/matlabcentral/answers/84633-how-to-save-in-specific-row-and-column-with-this-code-in-excel

[Image Analyst]

Yes it can, if you specify different destination cells. If you specify cells with entries in them already then, of course, those would get overwritten. The problem with your code is that you are not specifying the destination cell(s) location in the workbook so they all get written starting at cell A1 - the upper left.

[sandy]

I use s (k,:) instead of s in my code..showing error as, variable s appears to change size on every loop iteration.consider preallocating for speed..how to come over this error...?