How to export headers from uitable to excel sheet

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);

Answer 1

[Brendan Hamm]

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);

[Brendan Hamm]

You may need to transpose the result of

get(handles.uitable,'ColumnName')

[Adam Taher]

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]

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]

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.