xlswrite: write values in different columns

1 次查看（过去 30 天）
pavlos
pavlos 2014-8-3
评论： pranav kumar 2018-4-28
Hello,
Please help me with the following:
Consider a column vector, say "x", with dimension 1000x1.
The values of x are changing after a each iteration.
Consider for example N iterations, say "i=1:N".
How can I write the values of vector x in different column in an excel file during the iterations?
The first iteration should store the values in A1:A1000,
the second iteration should store the values in B1:B1000,
and so on.
Thank you very much.
Best,
Pavlos

请先登录，再回答此问题。

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2014-8-3
编辑：Azzi Abdelmalek 2014-8-3
You can save your data at the end of your iterations
ni=10 % number f iterations
out=zeros(1000,ni]
for k=1:ni
% calculate x
out(:,k)=x % store a column x in a matrix out
end
xlswrite('your_file.xlsx',out)
%If you want to save the value each iteration, which will take more time
w='A':'Z'
N=10
for k=1:N
range=[w(k) '1:' w(k) num2str(10)]
x=rand(10,1);
xlswrite('your_file.xlsx',x,range)
end
  1 个评论
pranav kumar
pranav kumar 2018-4-28
i have an excel sheet with 360000 values. I want to take 1000 samples at a time and compute using loop. there are 14 outputs and i want to store the 14 outputs in 14 different columns for each of 1000 samples. how can i do it.

请先登录，再进行评论。

更多回答（1 个）

Honey Moradi
Honey Moradi 2017-6-6
编辑：Honey Moradi 2017-6-6
Hello, Please help me for this; I have 3 loop in my program, I want to save the result of them all in a excel sheet in different rows. for example from A1:Z1 for a loop, then from A2:Z2 and so on, for another loop with a gap like ----------- save them to next row.
for j=1:12:n
for Q=1:K
Z(j)=V(Q)
for i=j:j+10
calculate Z%
end
end
end
how can I do this???

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by