How to paste matlab table into Excel with headers

44 vues (au cours des 30 derniers jours)
JFz
JFz le 5 Oct 2016
Réponse apportée : Patrick Broughton le 19 Avr 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

Connectez-vous pour répondre à cette question.

Réponses (2)

Patrick Broughton
Patrick Broughton le 19 Avr 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 le 5 Oct 2016
Try using writetable instead of copy-and-paste.
  1 commentaire
JFz
JFz le 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.

Connectez-vous pour commenter.

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by