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!

 採用された回答

Tom
Tom 2012 年 9 月 26 日

0 投票

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

2 件のコメント

Samuel
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
Tom 2012 年 9 月 26 日
case?

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

質問済み:

2012 年 9 月 26 日

Community Treasure Hunt

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

Start Hunting!

Translated by