Creating a pop up menu from a spreadsheet

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

Answer 1

[Srijith Kasaragod]

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!