How to paste matlab table into Excel with headers

Question

JFz 2016-10-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305939-how-to-paste-matlab-table-into-excel-with-headers

回答： 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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Patrick Broughton 2022-4-19

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305939-how-to-paste-matlab-table-into-excel-with-headers#answer_945980

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Matthew Eicholtz 2016-10-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/305939-how-to-paste-matlab-table-into-excel-with-headers#answer_237599

Try using writetable instead of copy-and-paste.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

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.

请先登录，再进行评论。