ComboBox Values ???

[Aissaoui]

Hi I am new with Syncfusion product,
I need to get the values of combobox created in excel file
I found
IComboBoxShape that contains SelectedValue and SelectedIndex
But not all the values.

Should I use another thing

here is my code
var xlApp = xl.Excel;
var wkbk = xlApp.Workbooks.Open(stream);
var sheet1 = wkbk.Worksheets[0];
var combobox = sheet1.ComboBoxes[0]

and after that????

[Manikandan M]

Hi,

Thanks for using Syncfusion products.

Combobox value could be accessed by getting the range which combobox refers. We have created the samples for accessing values from Combobox and have attached the same.

Code snippet:
IRange range = comboBox2.ListFillRange;

Please let us know if you need any clarifications.

Thanks,
Manikandan.M





102262_aab59bf8.zip