- 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 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Azola Feni
le 14 Nov 2020
Réponse apportée : Monisha Nalluru
le 17 Nov 2020
How do I numeric prompt the user to select which data that must be displayed from an excel file?
0 commentaires
Réponse acceptée
Monisha Nalluru
le 17 Nov 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!