Write 3x1 matrix to excel file in for loop. How do I write with a for loop in every 3rd cell

Question

Michael Whipple 2019-3-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/452074-write-3x1-matrix-to-excel-file-in-for-loop-how-do-i-write-with-a-for-loop-in-every-3rd-cell

评论： Michael Whipple 2019-3-25

I'm using a for loop to determine the stress state on each layer of a laminate. I need to write each vector in a column of an excel file.

I would like to wirte the first one in B32:B34 and the next in B35:B37 and so on for each layer.

for i=1:NumLayers
    
    LaminaSress = Qs*(Strain+z(i)*Curve);
    
    xlswrite(Filename,LaminaStress,1,'B32')
end

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2019-3-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/452074-write-3x1-matrix-to-excel-file-in-for-loop-how-do-i-write-with-a-for-loop-in-every-3rd-cell#answer_367121

在 MATLAB Online 中打开

One way:

LaminaSress = zeros(3, NumLayers); %assuming that the result of your equation is a 3 elements vector
for layer = 1:NumLayers
    LaminaSress(:, layer) = Qs*(Strain+z(layer)*Curve);
end
xlswrite(Filename, LaminaStress, 1, 'B32');

Note that assuming that z is a vector and Qs or Strain and Curve are also vectors , your loop is not even needed. You can get the whole matrix in one go:

LaminaSress = Qs.*(Strain + z .* Curve);  %some tranposition may be needed to make sure the vectors are along different dimensions
xlswrite(Filename, LaminaStress, 1, 'B32');

2 个评论
显示无隐藏无

Michael Whipple 2019-3-24

I need the for loop because Qs and the z value change for each layer. I think the first part will work to make it all one matrix and write it all at once.

Michael Whipple 2019-3-25