Export column name along with data in excel file in GUI
2 ビュー (過去 30 日間)
古いコメントを表示
Helo,
I am builing a GUI and inside my GUI I have a table data named Results_table that contains a numerical values columnwise (n,1) stored in different columns with their respective names.
Now, I was able to export these values from the table Results_table in an excel file, but I could not find a solution to export the column names too with those values.
My code for this section is:
M=get(handles.Results_table, 'Data'); % I get values from table Results_table but it only exports values, and not their respective column names
FileName = uiputfile('*.xls','Save as');
xlswrite(FileName, M); %I save stored data in M
Is there a solution to this problem? How can I export column names that are associated with those numerical values inside table Results_table?
Thanks!
0 件のコメント
採用された回答
Jan
2017 年 8 月 7 日
M = get(handles.Results_table, 'Data');
Head = get(handles.Results_table, 'ColumnName');
Data = cat(1, Head, num2cell(M));
xlswrite(FileName, Data)
5 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Migrate GUIDE Apps についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!