Writing results in excel from matlab

1 次查看（过去 30 天）

显示更早的评论

Ananya Malik 2017-3-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/332684-writing-results-in-excel-from-matlab

评论： Ananya Malik 2017-3-30

采纳的回答： KSSV

scr.png

在 MATLAB Online 中打开

I need to write a string value in an excel cell, followed by array values of A and B (each value in a different cell) like in the figure. But when I try the following code, only string is written and numeric values are lost. Any help appreciated.

 function_name = 'F2';
  A={[1 2 3 4]};
  B= {[ 5 6 7 8]};
filename = 'testtest.xlsx';
xlswrite(filename,[{Function_name},A B])

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

请先登录，再进行评论。

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

采纳的回答

KSSV 2017-3-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/332684-writing-results-in-excel-from-matlab#answer_260971

在 MATLAB Online 中打开

F = 'F2';
A=[1 2 3 4];
  B= [ 5 6 7 8];
filename = 'testtest.xlsx';
xlswrite(filename,[{F} num2cell(A) num2cell(B)])

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

Ananya Malik 2017-3-30

Thanks a lot..

请先登录，再进行评论。

类别

Computational Finance Spreadsheet Link Data Import from MATLAB

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by