5 pts.
 Populate an Excel drop down list from ASP.NET using VB.NET
How do you populate an Excel spreadsheet that contains drop down list using ASP.NET with VB.NET code behind. I can easily populate or update the cells by name because the headers are not on the first row but when I am trying to populate a cell that has a drop down list attached to it, even though I am sending a value that is in the drop down list, nothing happens. Any tips would be greatly appreciated.

Software/Hardware used:
ASKED: February 28, 2013  8:30 PM
UPDATED: February 28, 2013  8:33 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,400 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _