Creating a pop up menu from a spreadsheet

2 views (last 30 days)
Currently have the following code to create a pop up menu using UI control features
MaterialInput = uicontrol('Style','popupmenu','string',{'Select Material','Alpha Titanium','Aluminium','Beta Titanium','Calcium','Carbon','Carbon (diamond)','Carbon (monoxide)','Chromium','Cobalt (face-centred-cubic)','Cobalt (hexagonal)','Copper','Hydrogen','Iron','Iron Oxide','Magnesium','Magnetite','Manganese','Nickel','Silicon','Zinc'},'Position', [500,600,330,25],'Callback',{@MaterialInput_Callback});
Each of the listed items in the pop up menu can be found in the same column in a spreadhsheet, can i generate this pop up menu straight from the spreadsheet

Answers (1)

Srijith Kasaragod
Srijith Kasaragod on 26 Oct 2021
Assuming the items lie in the spreadsheet as a single column, 'readcell' function can be used to return the items as a cell array. The output of 'readcell' function can be passed as the value of 'string' parameter.
Hope this helps!

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!