Effacer les filtres
Effacer les filtres

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

1 vue (au cours des 30 derniers jours)
Samuel
Samuel le 26 Sep 2012
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!

Connectez-vous pour répondre à cette question.

Réponse acceptée

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

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by