How can I write multiple sets of data from MATLAB to one sheet in excel?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Alexandra Brian
el 26 de Oct. de 2016
Comentada: Chaya N
el 28 de Oct. de 2016
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 comentarios
Respuesta aceptada
Chaya N
el 26 de Oct. de 2016
Editada: Chaya N
el 26 de Oct. de 2016
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 comentarios
Chaya N
el 28 de Oct. de 2016
Please use the xlswrite() command instead of writetable(). Note the change in the order of the input arguments between the two functions.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!