How to paste matlab table into Excel with headers

Hi,

I have a table in Matlab with many rows. I can copy from Matlab and paste into Excel. But the headers are gone. How to copy the headers into Excel as well? Thanks for any help.

JZ

Answer 1

[Patrick Broughton]

Copy and paste your table. Then run header = string(tableName.Properties.VariableNames); and copy and paste the output into your excel book.

Answer 2

[Matthew Eicholtz]

Try using writetable instead of copy-and-paste.

[JFz]

I see. But That is slower because you have to write it into a file. I would like to just copy it into a spreadsheet that already has some data and I can do some comparison.