can use xlswrite in for loop without overwriting?

Question

sandy 2013-8-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84631-can-use-xlswrite-in-for-loop-without-overwriting

评论： Anand Ganesan 2020-4-6

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?

2 个评论
显示无隐藏无

SANDEEP KUMAR 2018-6-20

编辑：SANDEEP KUMAR 2018-6-20

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 2018-6-20

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 2013-8-13

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84631-can-use-xlswrite-in-for-loop-without-overwriting#answer_94195

在 MATLAB Online 中打开

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

2 个评论
显示无隐藏无

sandy 2013-8-13

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 2020-4-6

在 MATLAB Online 中打开

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 2013-8-13

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84631-can-use-xlswrite-in-for-loop-without-overwriting#answer_94219

编辑：Image Analyst 2018-6-20

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.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Image Analyst 2013-8-14

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 2013-8-14

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...?

请先登录，再进行评论。