How to paste matlab table into Excel with headers

46 views (last 30 days)
JFz
JFz on 5 Oct 2016
Answered: Patrick Broughton on 19 Apr 2022
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

Sign in to answer this question.

Answers (2)

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.
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.

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!