Add column and row headers to a matrix for export

I have a 46 x 46 matrix and I want to export the data with headers. Currently I am using xlswrite but it doesn't seem very stable and the file takes a long time to open.

RowNames = cellstr(headers);
 col_header= RowNames'; 
 row_header= RowNames;
 
xlswrite('TtestResults.xls',results,'Sheet1','B2');
xlswrite('TtestResults.xls',col_header,'Sheet1','B1');
xlswrite('TtestResults.xls',row_header,'Sheet1','A2'); 

MatLab doesn't recommend to use xlswrite but I don't know another function that will still put the matrix and headers in the correct orientation. Any ideas would be much appreciated

[KSSV]

Convert the matrix, into a table using table and use writetable.

Answer 1

[Ganesh Regoti]

Hi,

I assume that you want to store the data in matrix with headers in .xls file. You could use following functions to achieve it

1. array2table
2. writetable

I found a similar question in MATLAB Answers which you can refer to

https://www.mathworks.com/matlabcentral/answers/430050-how-to-store-matrix-in-a-txt-file-with-row-and-column-name

Hope this helps!