Add column and row headers to a matrix for export

16 vues (au cours des 30 derniers jours)
GGM
GGM le 23 Avr 2020
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 commentaire
KSSV
KSSV le 23 Avr 2020
Convert the matrix, into a table using table and use writetable.

Connectez-vous pour commenter.

Réponses (1)

Ganesh Regoti
Ganesh Regoti le 29 Avr 2020
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
Hope this helps!

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by