How to paste matlab table into Excel with headers

44 visualizaciones (últimos 30 días)
JFz
JFz el 5 de Oct. de 2016
Respondida: Patrick Broughton el 19 de Abr. de 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

Iniciar sesión para responder a esta pregunta.

Respuestas (2)

Patrick Broughton
Patrick Broughton el 19 de Abr. de 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 el 5 de Oct. de 2016
Try using writetable instead of copy-and-paste.
  1 comentario
JFz
JFz el 6 de Oct. de 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.

Iniciar sesión para comentar.

Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by