How to paste matlab table into Excel with headers

69 views (last 30 days)
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

Answers (2)

Matthew Eicholtz
Matthew Eicholtz on 5 Oct 2016
Try using writetable instead of copy-and-paste.
  1 Comment
JFz
JFz on 6 Oct 2016
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.

Sign in to comment.


Patrick Broughton
Patrick Broughton on 19 Apr 2022
Copy and paste your table. Then run header = string(tableName.Properties.VariableNames); and copy and paste the output into your excel book.

Tags

Products

Community Treasure Hunt

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

Start Hunting!

Translated by