- First load the data from excel sheet into workspace, inorder to achieve this use function like readtable, readmatrix, readcell
- In order to prompt user to select data, use listdlg function which create a list selection dialogue box. listdlg function only takes strings so convert the numeric data into string format using string function
Put workspace data into menu and prompt someone to select it
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Azola Feni
el 14 de Nov. de 2020
Respondida: Monisha Nalluru
el 17 de Nov. de 2020
How do I numeric prompt the user to select which data that must be displayed from an excel file?
0 comentarios
Respuesta aceptada
Monisha Nalluru
el 17 de Nov. de 2020
Inorder to prompt user to select data from excel sheet.
As an example
data=readtable('mydata.xlsx'); % contains date, day, temperature
% is you want user to select temperature then convert temperature values into string datatype
temperature = string(data.temperature);
[indx,tf] = listdlg('ListString',temperature); %prompts user to select data
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!