save variables of different dimension in the same excel file

1 次查看（过去 30 天）

antonet 2012-7-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42916-save-variables-of-different-dimension-in-the-same-excel-file

Hi,

I want to save in the same excel file variables of different dimension that I create. Foe example say that a variable A is of dimension 1000 by 45 And a variable B is of dimension 40 by 1

I can not use

      m = [A  B ];
  xlswrite('sugar.xlsx',m);

I want to save both A and B in the same excel file

thanks

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

请先登录，再进行评论。

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

采纳的回答

F. 2012-7-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42916-save-variables-of-different-dimension-in-the-same-excel-file#answer_52733

在 MATLAB Online 中打开

xlswrite(filename,A,sheet,range)

so did you try this ?

   xlswrite('sugar.xlsx',A, 'Sheet01', 'A1'); 
   xlswrite('sugar.xlsx',B, 'Sheet01', 'A50');

I let you define ranges with your data ;-)

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

antonet 2012-7-6

thank you

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by