Export uitable's data to a spreadsheet Excel

Question

Julián Francisco 2011-11-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/20819-export-uitable-s-data-to-a-spreadsheet-excel

评论： 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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Fangjun Jiang 2011-11-9

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/20819-export-uitable-s-data-to-a-spreadsheet-excel#answer_27491

在 MATLAB Online 中打开

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 个评论
显示 1更早的评论隐藏 1更早的评论

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 2015-1-1