xlswrite: write values in different columns
13 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
采纳的回答
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
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
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???
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!