Create a Menu From Excel Data

Is there a way in which you can create a menu that will take text strings from an Excel file and place them as the options for the menu, and if so how do I do that?

Answer 1

[Laura Proctor]

You can read the strings from the cells using XLSREAD, then use MENU to create the menu.

For example:

 [num,txt,raw] = xlsread('myfile.xls');
 choice = menu('Choose an item',txt)

[Julie]

Thank you so much! Do you know of any way in which to delete the first item in the list since it is only the header and I do not need it in my menu.

[Laura Proctor]

In that case, you can just use:

choice = menu('Choose an item',txt(2:end))

Or, redefine txt and use the same syntax as above:

txt = txt(2:end)

[Julie]

I am now trying to do the same thing with numerical values, but I cannot get it to work. Do I have to do something different?