xlswrite: write values in different columns

5 次查看（过去 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 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by