How to paste matlab table into Excel with headers
显示 更早的评论
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
回答（3 个）
Patrick Broughton
2022-4-19
1 个投票
Copy and paste your table. Then run header = string(tableName.Properties.VariableNames); and copy and paste the output into your excel book.
David
2025-4-19
0 个投票
I see this is 3 years old. but I had the same issue, so the solution is to repeat the column names in the first row. then you can easily cut and paste into excel.
% Create table data for selected N_2 values, with headers as first row
data_table = cell(length(plot_indices) + 1, 6); % +1 for header row
% Add headers as first row
data_table{1,1} = 'N_2';
data_table{1,2} = 'P_{shell} (Pa)';
data_table{1,3} = 'P_{cylinder} (Pa)';
data_table{1,4} = 'E_{cylinder} (MeV)';
data_table{1,5} = '% Coulomb';
data_table{1,6} = 'Work (MeV)';
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
