I hope you have created a template column and added dropdown to that.
Fine.

Whatever data you want to load to the dropdown, capture them in different rows(and first column) of a datatable say 'dtbSiteType'

Now , In the item command function of the datagrid, find that drop down list for each row of the datagrid in this way-
Note: 0 is the template cell number.

cmbSiteType = CType(e.Item.Ce lls(0).FindCont rol("cmbSiteTyp e"),...

Response.Conten tType Excel

I am trying to export a datagrid into an excel sheet.
What it now does is the entire page is saved as an excel sheet in XlHtml file format. I want it in xlWorkbookNorma l format and also have to delete that extra blank space in the excel sheet. Please help out if somebody knows.



Dim dt As DataTable = GetDataTableFro mDatabase()
GridView2.DataS ource = dt...

I got this much information regarding excel file I want to display.
strFileName contains the entire file path.


Dim theWorkbook As Excel.Workbook
theWorkbook = excelobj.Workbo oks.Open(strFil eName, 0, True, 5, "", "", True, Excel.XlPlatfor m.xlWindows, "\t", False, False, 0, True)
Dim sheets As Excel.Sheets = theWorkbook.Wor ksheets


...