writing multiple 2D matrices in 1 excel file

Question

Ananya Malik 2017-8-28

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354290-writing-multiple-2d-matrices-in-1-excel-file

编辑： KL 2017-8-28

I have multiple variables containing 2D data that I want to write in either xls or txt file.

Suppose in each iteration I get A = [50x2], B=[10x2], C=[13x2], D=[11x2], E=[15x2], I want to write all this data in the same excel sheet. Is it possible. Any help appreciated. TIA.

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

请先登录，再进行评论。

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

Answer 1

KL 2017-8-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354290-writing-multiple-2d-matrices-in-1-excel-file#answer_279431

编辑：KL 2017-8-28

在 MATLAB Online 中打开

sheetA = 1;
sheetB = 2;
xlswrite(filename,A,sheetA)
xlswrite(filename,B,sheetB) %and so on

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

请先登录，再进行评论。

Answer 2

KSSV 2017-8-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/354290-writing-multiple-2d-matrices-in-1-excel-file#answer_279426

在 MATLAB Online 中打开

A = rand(10,3) ;
B = rand(3,3) ;
dlmwrite('test.txt',A,'-append')
dlmwrite('test.txt',B,'-append')

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

Ananya Malik 2017-8-28

编辑：Ananya Malik 2017-8-28

Thank you. This code appends everything without clear distinction. I would prefer the data to be in columns. Hence maybe excel sheet would be a better choice right?

请先登录，再进行评论。