How to export headers from uitable to excel sheet

1 次查看（过去 30 天）
Adam Taher
Adam Taher 2015-7-15
评论： Adam Taher 2015-7-15
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
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更早的评论
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 个）

类别

在 Help Center 和 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