Creating a pop up menu from a spreadsheet

2 次查看（过去 30 天）
Samuel Harding
Samuel Harding 2021-2-10
回答： Srijith Kasaragod 2021-10-26
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

请先登录，再回答此问题。

回答（1 个）

Srijith Kasaragod
Srijith Kasaragod 2021-10-26
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!

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by