Clear Filters
Clear Filters

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

1 view (last 30 days)
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!

Accepted Answer

Tom
Tom on 26 Sep 2012
[~,Sheets]=xlsfinfo(FileName)
set(PopUpHandle,'String',Sheets)
  2 Comments
Samuel
Samuel on 26 Sep 2012
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?

Sign in to comment.

More Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!