How to export headers from uitable to excel sheet

2015 7 15
1 个回答
回答已采纳
更新时间：2015 7 15
4 次查看（30 天）

0 个投票

Hello, I have a uitable using GUI with 7 columns (number of rows doesn't matter) and I'm able to import data to xls extension with a pushbutton. But I realized that the 7 headers are not imported. Thanks for your help! Here is my code:
data = get(handles.uitable, 'data');
filename = 'something.xls';
xlswrite(filename,data);

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

 采纳的回答

Brendan Hamm
Brendan Hamm 2015-7-15

0 个投票

Well the column names are stored in the 'ColumnName' of the uitable.
data = [get(handles.uitable,'ColumnName');get(handles.uitable, 'data')];
filename = 'something.xls';
xlswrite(filename,data);

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Brendan Hamm
Brendan Hamm 2015-7-15
You may need to transpose the result of
get(handles.uitable,'ColumnName')
Adam Taher
Adam Taher 2015-7-15
Hi, when I type in your suggestion, I get this error:
Error using vertcart Dimensions of matrices being concatenated are not consistent.
Any idea?
Brendan Hamm
Brendan Hamm 2015-7-15
It may be that your data is all numeric? If this is the case then you need to convert it to a cell array to concatenate:
[get(handles.uitable,'ColumnName')';num2cell(get(handles.uitable,'Data'))]
If not please provide more information.
Adam Taher
Adam Taher 2015-7-15
Finally I tried something like this and it worked. Thanks for you help:
data = get(handles.uitable, 'data');
datax = get(handles.uitable, 'ColumnName');
filename = 'something.xls';
xlswrite(filename,data);
xlswrite(filename,datax,1,'A2:G2');
That way, I don't overwrite my headers.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Develop Apps Using App Designer 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by