- 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
조회 수: 1 (최근 30일)
이전 댓글 표시
How do I numeric prompt the user to select which data that must be displayed from an excel file?
댓글 수: 0
채택된 답변
Monisha Nalluru
2020년 11월 17일
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!