OLEObjects ComboBox (ActxServer Matlab Excel)

조회 수: 9 (최근 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 CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by