Add column and row headers to a matrix for export

11 次查看（过去 30 天）
GGM
GGM 2020-4-23
回答： Ganesh Regoti 2020-4-29
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

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

回答（1 个）

Ganesh Regoti
Ganesh Regoti 2020-4-29
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!

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by