How can I write multiple sets of data from MATLAB to one sheet in excel?

Question

Alexandra Brian 2016-10-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/309317-how-can-i-write-multiple-sets-of-data-from-matlab-to-one-sheet-in-excel

评论： Chaya N 2016-10-28

I'm running a linear regression test in MATLAB from data I have in excel.

A = xlsread('excel_report.xlsx', sheet, 'ColumnA:ColumnA');
B = xlsread('excel_report.xlsx', sheet, 'ColumnB:ColumnB');

After using the xlsread built-in function to download the data I ran a linear regression test using fitlm:

md2 = fitlm(A,B);

I then pulled data from the fitlm:

coeff2 = md2.Coefficients;

And added this to same excel workbook I originally pulled the data from:

writetable(coeff2, 'excel_report.xlsx', 'Sheet', 2);

My problem is I'd like to add more variables from fitlm to the excel_report.xlsx's corresponding sheet.

Specifically the Rsquared value and the number observations.

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

请先登录，再进行评论。

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

Answer 1

Chaya N 2016-10-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/309317-how-can-i-write-multiple-sets-of-data-from-matlab-to-one-sheet-in-excel#answer_240868

编辑：Chaya N 2016-10-26

在 MATLAB Online 中打开

You could simply call the same function a couple more times to write your required variables into the same sheet.

I would also suggest using the 'Range' option of the function to specify the cell(s) you would be writing your data into. Try

writetable(md2.Rsquared.Ordinary, 'excel_report.xlsx', 'Sheet', 2, 'Range', 'B2');
writetable(md2.Rsquared.Adjusted, 'excel_report.xlsx', 'Sheet', 2, 'Range', 'B4');
writetable(md2.NumObservations, 'excel_report.xlsx', 'Sheet', 2, 'Range', 'B6');
writetable(md2.Coefficients, 'excel_report.xlsx', 'Sheet', 2, 'Range', 'D2');

2 个评论
显示无隐藏无

Alexandra Brian 2016-10-27

在 MATLAB Online 中打开

The following error occurred when I added the range:

Undefined function 'write' for input arguments of type 'double'.
Error in writetable (line 116)
write(a,filename,varargin{:})
Error in correlAnalysis (line 47)
writetable(md2.Rsquared.Ordinary, 'RB4Indicators_Report.xlsx', 'Sheet', 2, 'Range', 'B2');