OLEObjects ComboBox (ActxServer Matlab Excel)
13 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hellow
How can i change the current selected item of an ComboBox in Excel by Matlab For example i have a CamboBox in Excel with 3 elements (a,b,c), the current selected element is "b" so i would like select the first Element "a" i tried this:
Excel=actxserver('Excel.application');
Excel.Application.DisplayAlerts=0;
File=Excel.Workbooks.Open('MyExcelFile');
Param=File.Sheets.Item('Param');
Param.OLEObjects.Item('ComboBox1').Object.List % to get the list of element
Param.OLEObjects.Item('ComboBox1').Object.Value % to get the current selected item
................................................ % how to select ather element of list?
Param.OLEObjects.Item('ComboBox1').Object.Value= 'b' % does'nt work
Thenk yo
0 commentaires
Réponse acceptée
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!