App Designer User edit/update table
13 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
ted yao
el 23 de Dic. de 2019
Comentada: Kojiro Saito
el 7 de Jul. de 2021
Hello,
I am new to app designer so forgive me for asking silly questions:
I have loaded an cell array data from excel into my app design table:
and I would like to know how can a user update the value in cell?
I have created a call back function below that It's supposed to responde to user commond whenever the table is clicked
function CBICDispCellEdit(app, event)
indices = event.Indices;
newData = event.NewData;
app.table.ColumnEditable=[false,false,false,false,false,false,true];
app.table.Cmd=categorical({'open';'close'});
But nothing happened when I clicked on the table...
Is there anything I am missing here? Thanks
0 comentarios
Respuesta aceptada
Kojiro Saito
el 24 de Dic. de 2019
Editada: Kojiro Saito
el 6 de En. de 2020
CellEditCallback is triggered when the value of cell has changed. If you want to trigger an event when clicking the cell of table, you need to add callback of CellSelectionCallback.
Updated on 2020 Jan 6th.
In order to make drop down list in your Cmd column of the table, first you need to change import options of your excel file.
function LoadTableButtonPushed(app, event)
opts = detectImportOptions('test1.xlsx'); % For importing Cmd column as char not double
opts.VariableTypes{8} = 'string'; % For importing Cmd column as string
t = readtable('test1.xlsx', opts);
app.Table1.Data = t;
app.Table1.ColumnName = t.Properties.VariableNames;
end
And here is a code to make Cmd column as categorical.
function Table1CellSelection(app, event)
app.UITable.Data.Cmd = categorical(app.UITable.Data.Cmd, {'open', 'close'});
end
Screenshot is as the follows.
2 comentarios
Más respuestas (1)
John K. George
el 6 de Jul. de 2021
Hi Kojiro,
I'm trying to implement your solution after reading an excel file. Please see attached. I have taken a slightly different approach due to my contraints but I'm hoping I can still use your implementation - w/modification. thx.
John
2 comentarios
John K. George
el 6 de Jul. de 2021
What am I missing? The dropdowns are still not working when I run from AppDesigner. I can only highlight the column values - no dropdowns.
Kojiro Saito
el 7 de Jul. de 2021
Could you post your question in a new thread, please?
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!