How can i store the two variable in an excel sheet in every iteration of the loop ?

Question

Surendra Ratnu 2023-5-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1976214-how-can-i-store-the-two-variable-in-an-excel-sheet-in-every-iteration-of-the-loop

评论： Surendra Ratnu 2023-6-1

Suppose We have two variables, y and z. In every iteration of a loop, y and z change their values. We must store the y and z values column-wise for every iteration in an Excel sheet. I attached an example of the code. So We need to store data in a D matrix(50 by 100 (Row by column)). Can you provide a solution to this problem? Your help will be appreciated.

Thank you for your help.

clc 
clear
close all
x = rand(1,50).';
n = length(x);
for i = 1:n
    y = sin(x);
    z = cos(x);
    D = [y,z];
end 

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

Dyuman Joshi 2023-5-31

Use writematrix

请先登录，再进行评论。

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

Answer 1

Rahul 2023-5-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1976214-how-can-i-store-the-two-variable-in-an-excel-sheet-in-every-iteration-of-the-loop#answer_1247804

编辑：Rahul 2023-6-1

在 MATLAB Online 中打开

Assuming that you simply need to arrange the values of D (x, y column-wise concatenated) of each iteration column-wise, without labelling the columns, we could append 50 'D' values of each iteration to an initially empty matrix T to form a 50x100 matrix, and finally insert this matrix 'T' into an excel spreadhseet with fileName, say 'sample.xlsx' (or .xls), which will be created on the currently open folder, by appending two lines on your provided code snippet:

A good tip form @Walter Roberson, to pre-allocate dimensions for the 'T' matfrix for better efficiency:

clc 
clear
close all
% Initializing Random variable x
x = rand(1,50).';
n = length(x);
T = zeros(n, 2*n);
% Looping over 50 iterations
for i = 1:n
    y = sin(x);
    z = cos(x);
    
    % Storing current iteration values
    T(:, 2*i - 1) = y;
    T(:, 2*i) = z;
end 
% Writing to an excel spreadhseet
fileName = 'sample.xlsx';
writematrix(T, fileName);

You can even refer to the writematrix function documentation, to read further about the function or customize it as per your needs.

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

Walter Roberson 2023-5-31

在 MATLAB Online 中打开

You can improve the efficiency by pre-allocating:

x = rand(1,5).';
n = length(x);
T = zeros(n, 2*n);
for i = 1:n
    y = sin(x);
    z = cos(x);
    T(:,2*i-1) = y; T(:,2*i) = z;
end 
fileName = 'sample.xlsx';
writematrix(T, fileName);
1     0.568145684426796,0.822927992759517,0.568145684426796,0.822927992759517,0.568145684426796,0.822927992759517,0.568145684426796,0.822927992759517,0.568145684426796,0.822927992759517
2     0.242327805174217,0.97019443146178,0.242327805174217,0.97019443146178,0.242327805174217,0.97019443146178,0.242327805174217,0.97019443146178,0.242327805174217,0.97019443146178
3     0.693053230538969,0.720886412439227,0.693053230538969,0.720886412439227,0.693053230538969,0.720886412439227,0.693053230538969,0.720886412439227,0.693053230538969,0.720886412439227
4     0.599422412715991,0.800432864851101,0.599422412715991,0.800432864851101,0.599422412715991,0.800432864851101,0.599422412715991,0.800432864851101,0.599422412715991,0.800432864851101
5     0.720471825782418,0.693484209087524,0.720471825782418,0.693484209087524,0.720471825782418,0.693484209087524,0.720471825782418,0.693484209087524,0.720471825782418,0.693484209087524

Walter Roberson 2023-6-1

在 MATLAB Online 中打开

T(:, 2*n - 1) = y;

wrong index. n is constant relative to that loop, so you are always writing to the same locations in the loop.

Surendra Ratnu 2023-6-1

Thank you for your suggestions. it works well.

请先登录，再进行评论。

Answer 2

Diwakar Diwakar 2023-5-31

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1976214-how-can-i-store-the-two-variable-in-an-excel-sheet-in-every-iteration-of-the-loop#answer_1247899

在 MATLAB Online 中打开

% Initialize the matrix D
D = zeros(50, 100);
% Loop for 50 iterations
for i = 1:50
    % Calculate random values for y and z
    y = rand();
    z = rand();
    
    % Store y and z values in matrix D
    D(i, 1) = y;
    D(i, 2) = z;
end
% Save the matrix D to a CSV file
filename = 'data.csv';
csvwrite(filename, D);