App design UI figure How to Add Excel like Sort & filter selection

Question

Life is Wonderful 2020-1-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/501212-app-design-ui-figure-how-to-add-excel-like-sort-filter-selection

编辑： Life is Wonderful 2020-1-24

采纳的回答： Adam Danz

在 MATLAB Online 中打开

I want to add filter to my app design as shown in attachment

I have added my source *.mlapp file. For below code, I want to add excel like Sort & filter for all Columns Variables and Row Name data

                TableCellData1                  = timetable2table(joinedtimetable);
                app.UITable.Data                = TableCellData1;
                t_table                         = app.UITable.Data(:,app.UITable.Data.Properties.VariableNames);
                app.UITable.ColumnName          = t_table.Properties.VariableNames;
                app.UITable.RowName             = 'numbered';
                app.UITable.ColumnSortable      = true;
                app.UITable.BackgroundColor     = [1 1 .9; .9 .95 1;1 .5 .5];
                get(app.UITable);
                
                % ui figure for viewing full logs
                f_table = app.UITable.Data(:,app.UITable.Data.Properties.VariableNames);
                fig = uifigure;
                uit = uitable(fig,'Data',f_table,...
                    'ColumnName',f_table.Properties.VariableNames,...
                    'RowName',f_table.Properties.RowNames,...
                    'ColumnWidth',{100});
                uit.RowName = 'numbered';
                uit.ColumnSortable = true;
                uit.BackgroundColor = [1 1 .9; .9 .95 1;1 .5 .5];
                uit.Data = f_table;
                styleIndices = ismissing(f_table);
                [row,col] = find(styleIndices);
                s = uistyle('BackgroundColor','black');
                addStyle(uit,s,'cell',[row,col]);
                uit.DisplayDataChangedFcn = @updatePlot;
                set(uit, 'CellSelectionCallBack',[])
                set(uit, 'CellSelectionCallBack',@selectionChangeCallBack);

Add Sort & Filter

                    'ColumnName',f_table.Properties.VariableNames,...
                    'RowName',f_table.Properties.RowNames,...

2 个评论
显示无隐藏无

Adam Danz 2020-1-21

编辑：Adam Danz 2020-1-21

There's currently no built-in methods of sorting and filtering UITables. You'll have to create these features manually.

sortrows may come in handy for simple alphanumeric sorting of the entire table based on a selected column.

For filtering, you can use logical indexing to select which rows should be displayed on the table. It won't be a very difficult task but it will take a bit of an investment of time. I'm sure you can find related questions within this forom on both filtering and sorting of UItables to get you started.

Life is Wonderful 2020-1-24

编辑：Life is Wonderful 2020-1-24

Thanks a lot Adam for the suggestion. We can close this link . I am fine with your answer. I don't see accept answer button.

请先登录，再进行评论。

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

Answer 1

Adam Danz 2020-1-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/501212-app-design-ui-figure-how-to-add-excel-like-sort-filter-selection#answer_411737

My comment moved here to close out the question.

----------------------------------------------------------------

There's currently no built-in methods of sorting and filtering UITables. You'll have to create these features manually.

sortrows may come in handy for simple alphanumeric sorting of the entire table based on a selected column.

For filtering, you can use logical indexing to select which rows should be displayed on the table. It won't be a very difficult task but it will take a bit of an investment of time. I'm sure you can find related questions within this forom on both filtering and sorting of UItables to get you started.