GUIDE uitable saved to excel WITH column headings

1 次查看（过去 30 天）

Jason 2019-10-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/485029-guide-uitable-saved-to-excel-with-column-headings

评论： Jalaj Gambhir 2019-10-16

Whats the best way to save a GUIDE uitable to an excel file. The uitable consists of doubles and I need to include the headings in the excel file. I used to use xlswrite but the documentation suggest to use writematrix or write table but i cannot get the headings. I would also need to be able to then read in the excel data as well as the headings.

Thanks

Jason

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

Jason 2019-10-16

Hello. Yes i used to do this as per link but the recomnendation now is NOT to use xlswrite Thanks

Jalaj Gambhir 2019-10-16

在 MATLAB Online 中打开

In the example cited in the above link, writecell works correctly as well, because 'CombData' is a cell array (the reason why writematrix and writetable does not work). You can combine your column headings (character data) and double data in a cell array, and you can use writecell.

LastName = {'Smith';'Johnson';'Williams';'Jones';'Brown'};
Age = [38;43;38;40;49];
Height = [71;69;64;67;64];
Weight = [176;163;131;133;119];
BloodPressure = [124 93; 109 77; 125 83; 117 75; 122 80];
T = table(LastName,Age,Height,Weight,BloodPressure);
writetable(T,'myData.xls');