Write results in Excel under multiple If statements

Question

gsourop 2019-3-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/450045-write-results-in-excel-under-multiple-if-statements

编辑： Alex Mcaulley 2019-3-14

Hi there,

I would like to ask how can I use multiple if statements. I have written the following code but I only get results for the first if statements.

for j = 1 : 2
x = randn(10,1)
for k=1:2
y = randn(10,1)
if j == 1 & k == 1
                xlswrite('Test.xls', [x y], 'Test1', 'b2');
                if j == 1 & k == 2
                    xlswrite('Test.xls', [x y], 'Test1', 'p2');
                    if j == 2 & k == 1
                        xlswrite('Test.xls', [x y], 'Test1', 'b20');
                    if j == 2 & k == 2
                            xlswrite('Test.xls', [x y], 'Test1', 'p20');
                    end
                    end
                end
end
end
end

I would appreciate any help. Thank you.

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

请先登录，再进行评论。

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

Answer 1

Alex Mcaulley 2019-3-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/450045-write-results-in-excel-under-multiple-if-statements#answer_365339

编辑：Alex Mcaulley 2019-3-14

在 MATLAB Online 中打开

You need to close every if statement:

for j = 1 : 2
    x = randn(10,1);
    for k=1:2
        y = randn(10,1);
        if j == 1 && k == 1
            xlswrite('Test.xls', [x y], 'Test1', 'b2');
        end
        if j == 1 && k == 2
            xlswrite('Test.xls', [x y], 'Test1', 'p2');
        end
        if j == 2 && k == 1
            xlswrite('Test.xls', [x y], 'Test1', 'b20');
        end
        if j == 2 && k == 2
            xlswrite('Test.xls', [x y], 'Test1', 'p20');
        end
    end
end