Create a Menu From Excel Data

2011 4 18
1 个回答
回答已采纳
1 次查看（30 天）

0 个投票

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?

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

 采纳的回答

Laura Proctor
Laura Proctor 2011-4-18

1 个投票

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)

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Julie
Julie 2011-4-18
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
Laura Proctor 2011-4-19
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
Julie 2011-4-27
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?

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by