Hello, Could anyone please help me with this issue. In this code, I want to save the output results after each increment in excel and I am unable to do it. Thanking you .

Question

SAHOO Sudeep Kumar 2022-5-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1725430-hello-could-anyone-please-help-me-with-this-issue-in-this-code-i-want-to-save-the-output-results

编辑： Voss 2022-5-23

f=0;
t=0;
a11=0;
a22=1;
a33=0;
X=[a11; a22; a33];
a11=0;
a22=1;
a33=0;
V=[]
for f=0:15:180
    M=[cosd(f) -sind(f) 0; sind(f) cosd(f) 0; 0 0 1];
    K=[1 0 0; 0 cosd(t) -sind(t); 0 sind(t) cosd(t)];
    V=M*K*X
 writematrix(V,'V.xls')
end

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Voss 2022-5-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1725430-hello-could-anyone-please-help-me-with-this-issue-in-this-code-i-want-to-save-the-output-results#answer_969960

编辑：Voss 2022-5-23

在 MATLAB Online 中打开

V is a 3-by-1 column vector in each iteration of the for loop, so one way to save them all is to make V a matrix instead, calculate one column of V each time, and save the entire matrix V to file once after the loop.

f=0:15:180;
t=0;
a11=0;
a22=1;
a33=0;
X=[a11; a22; a33];
a11=0;
a22=1;
a33=0;
V=zeros(numel(X),numel(f));
for ii = 1:numel(f)
    M=[cosd(f(ii)) -sind(f(ii)) 0; sind(f(ii)) cosd(f(ii)) 0; 0 0 1];
    K=[1 0 0; 0 cosd(t) -sind(t); 0 sind(t) cosd(t)];
    V(:,ii)=M*K*X;
end
writematrix(V,'V.xls')

2 个评论
显示无隐藏无

SAHOO Sudeep Kumar 2022-5-23

Thank you for your quick response. It is working now.

Voss 2022-5-23

编辑：Voss 2022-5-23

You're welcome!

请先登录，再进行评论。

Answer 2

Jon 2022-5-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1725430-hello-could-anyone-please-help-me-with-this-issue-in-this-code-i-want-to-save-the-output-results#answer_969965

编辑：Jon 2022-5-23

在 MATLAB Online 中打开

You don't really explain exactly what your problem is (you just say you "can't do it"). I assume your problem you are complaining of is that you keep overwriting the result in your Excel file, so all you end up with in Excel is the final answer. This happens because you call to writematrix is inside of the loop, and since you just keep writing to the same file, you just overwrite the values with each iteration.

I assume you don't want a different file or different sheet for each iteration,but rather to see all of the results in a single sheet of V.xlsx.

To solve this I would suggest you save the data from all of the iterations in a single 3 by number of iterations matrix, where each column holds a result. Then save this one matrix. Like this:

% % % f=0;
t=0;
a11=0;
a22=1;
a33=0;
X=[a11; a22; a33];
% % % a11=0;
% % % a22=1;
% % % a33=0;
f = 0:15:180;
numPoints = numel(f);
V = zeros(3,numPoints); % preallocate array to hold your answer
for k = 1:numPoints
    M = [cosd(f(k)) -sind(f(k)) 0; sind(f(k)) cosd(f(k)) 0; 0 0 1];
    K = [1 0 0; 0 cosd(t) -sind(t); 0 sind(t) cosd(t)];
    V(:,k) = M*K*X; % store results in columns of V
end
% save the final V matrix in an Excel file
 writematrix(V,'V.xls')

I have commented out some of your code which doesn't seem to be used for anything

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

Jon 2022-5-23

For future reference, it is better to have a short general description of your problem in the title. Then put the detailed description of your problem in the body of the question.

SAHOO Sudeep Kumar 2022-5-23