How to export headers from uitable to excel sheet

1 vue (au cours des 30 derniers jours)
Adam Taher
Adam Taher le 15 Juil 2015
Commenté : Adam Taher le 15 Juil 2015
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);

Réponse acceptée

Brendan Hamm
Brendan Hamm le 15 Juil 2015
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 commentaires
Brendan Hamm
Brendan Hamm le 15 Juil 2015
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 le 15 Juil 2015
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.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Develop Apps Using App Designer dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by