We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

ComboBox Values ???

Thread ID:





102262 Jan 13,2012 03:58 PM Jan 17,2012 11:31 AM ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Asked On January 13, 2012 03:58 PM

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 [Syncfusion]
Replied On January 17, 2012 11:31 AM


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.




This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.