Add column and row headers to a matrix for export

37 views (last 30 days)
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;
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 Comment
KSSV on 23 Apr 2020
Convert the matrix, into a table using table and use writetable.

Sign in to comment.

Answers (1)

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


Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by