Creating a drop down/combo box

Nov 11, 2010 at 8:44 AM


I am using C# and ASP.NET and I need to export data to an Excel spreadsheet.

I have a list of applications that contains Application objects.  Each Application object has a status ID.  When I export these applications to Excel then I need a column with a drop down/combo box in it.  In this drop down/combo box should be a list of all the statuses from the database.  And then I need the status to be selected to that of the application's status ID.

Another question is also with regards to the above scenario.  When the user downloads the Excel document then the user can change the status of each application by selecting a different value in the drop down.  I will need to upload this spreadsheet and loop through the rows and get the values of the columns and the value of the selected item in the drop down/combo box.  How would you do this?

Is this possible?  If so, can someone please help provide some sample code for me?



Mar 10, 2011 at 2:34 PM

you need to use DataValidations,they allow you to use dropdownlist in excel,the way they are used in extremeML for me are impossible to know by the moment.Check my new post in the forum about it,maybe you get some help.Regards