How to add headers to Excel.

Question

Daniel Boateng 2019-6-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/467038-how-to-add-headers-to-excel

回答： Are Mjaavatten 2019-6-14

I am trying to add headers name and age to the excel i create for c but its not working.

Any help please?

filename = 'testdata.xlsx';
header = {'name', 'Age'};
A = [12.7;5.02;-98;63.9;0;-.2;56];
B= [12.7;5.02;-98;63.9;0;-.2;56];
c= [A,B];
xlswrite(filename,header,c)

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

请先登录，再进行评论。

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

Answer 1

Are Mjaavatten 2019-6-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/467038-how-to-add-headers-to-excel#answer_379174

filename = 'testdata.xlsx';
header = {'name', 'Age'};
A = [12.7;5.02;-98;63.9;0;-.2;56];
B= [12.7;5.02;-98;63.9;0;-.2;56];
c = cell(8,2);
c(1,:) = header;
c(2:8,:) = num2cell([A,B]);
xlswrite(filename,c);