- 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 views (last 30 days)
Show older comments
Azola Feni
on 14 Nov 2020
Answered: Monisha Nalluru
on 17 Nov 2020
How do I numeric prompt the user to select which data that must be displayed from an excel file?
0 Comments
Accepted Answer
Monisha Nalluru
on 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 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!