Export uitable's data to a spreadsheet Excel

4 ビュー (過去 30 日間)
Julián Francisco
Julián Francisco 2011 年 11 月 9 日
コメント済み: Vito Marangelli 2015 年 1 月 1 日
I have designed a GUI which has an uitable and a push button which, when is pressed, allows to export the uitable's data to an Excel spreadsheet. My problem is that I want to add the uitable's headers to the matrix Select which has the numeric values. This matrix is used by the pushbutton callback, as seen below:
htable = uitable(...);
...
SelecY = get(htable,'Data');
Callback of the pushbutton
function hExpExcelCallback(src,evt)
FileName = uiputfile('*.xls','Save as');
xlswrite(FileName,SelecY),
end

採用された回答

Fangjun Jiang
Fangjun Jiang 2011 年 11 月 9 日
You need to do some processing in the case that the table data is all numerical, because the column header is returned in a cell array. The following example uses a uitable, but should apply to the table you have in your GUI as long as you have the handle.
h=uitable('Data',rand(2,3),'ColumnName',{'a','b','c'});
Data=get(h,'Data');
ColumnName=get(h,'ColumnName');
NewData=mat2cell(Data,ones(size(Data,1),1),ones(size(Data,2),1));
CombData=[ColumnName';NewData];
xlswrite(FileName,CombData);
  3 件のコメント
Hector Prieto
Hector Prieto 2014 年 2 月 2 日
Dear @Fangjun Jiang,
I tried your example, but unfortunately it only works on Windows pc and I am using Macintosh. Can you please tell me how to implement this code on Macintosh?
Cheers
Héctor
Vito Marangelli
Vito Marangelli 2015 年 1 月 1 日
I have the same problem and I would like to know if Excel for Mac can be used with the command xlswrite

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeDevelop 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