OLEObjects ComboBox (ActxServer Matlab Excel)

13 次查看（过去 30 天）
Arezki
Arezki 2014-7-2
回答： Arezki 2014-7-2
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

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

采纳的回答

Arezki
Arezki 2014-7-2
Param.OLEObjects.Item('ComboBox1').Object.Value= 'b'
It's work, i had just problem with Excel :)

更多回答（0 个）

类别

在 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