Can a popup-menu on GUI get an excel file sheet name to use as string?

1 次查看（过去 30 天）

Samuel 2012-9-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/49124-can-a-popup-menu-on-gui-get-an-excel-file-sheet-name-to-use-as-string

Is there a way to make a popup-menu read an excel file an get all the sheet names of this file and use as string? I want to be able to add sheets in the excel file and when i open my GUI, it automatically add the strings in this popup-menu! Please, give me some ideia, i dont know how to start. Thanks!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Tom 2012-9-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/49124-can-a-popup-menu-on-gui-get-an-excel-file-sheet-name-to-use-as-string#answer_60031

在 MATLAB Online 中打开

[~,Sheets]=xlsfinfo(FileName)
set(PopUpHandle,'String',Sheets)

2 个评论
显示无隐藏无

Samuel 2012-9-26

Thanks man, it worked as i wanted! Now, how can i add a new option in the 'case' funtion of the popupmenu for the new strings i added?

Tom 2012-9-26

case?

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 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

Can a popup-menu on GUI get an excel file sheet name to use as string?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

2 个评论
显示无隐藏无

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

Can a popup-menu on GUI get an excel file sheet name to use as string?

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

采纳的回答

2 个评论 显示 无隐藏 无

更多回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

WeChat

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

2 个评论
显示无隐藏无