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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

ComboBox Values ???

Thread ID:





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

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 04:31 PM UTC


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon