How to paste matlab table into Excel with headers

45 次查看（过去 30 天）
JFz
JFz 2016-10-5
回答： Patrick Broughton 2022-4-19
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

请先登录，再回答此问题。

回答（2 个）

Patrick Broughton
Patrick Broughton 2022-4-19
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 2016-10-5
Try using writetable instead of copy-and-paste.
  1 个评论
JFz
JFz 2016-10-6
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.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by