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. 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?