Export to Excel - Drop Down List/TextBox

[Meena]

Hi,
   I have GridTemplateColumn with dropdownlist and text box in a Rad Grid and I have set ExportOnlyData="False".

 

<telerik:GridTemplateColumn HeaderText="Answer" UniqueName="AnswerOptions">

 

 

<HeaderStyle HorizontalAlign="Left" Width="150px"/>

 

 

<ItemTemplate>

 

 

<asp:dropdownlist id="ddloptions" runat="server" >

 

 

</asp:dropdownlist>

 

 

</ItemTemplate>

 

 

</telerik:GridTemplateColumn>

 

 
When I do "ExporttoExcel", it opens up a excel file, with dropdown and textbox.  I select some values from dropdown and enter values for textbox and then save as ExcelWorkbook. Till that no problem.
   Now I am trying to import the entered values into database. I tried different possible ways. I tried to save the file as csv/tab delimited, but the value selected in dropdown or entered in textbox doesn't get copied to the csv/text. I tried to just copy the cells and paste it into a notepad. But the selected dropdown value doesn't get copied. I could not figure out how this dropdownlist/textbox is stored in the excel workbook. Can you please let me know how I can retrieve the dropdown/textbox values ?
Appreciate your help.
Thanks
Meena

[Prangadj]

Suppose dropdown select/textbox text saving may not supported by Excel. Try pasting the html of dropdown (select element) or textbox (input type="textbox") in Excel cell and do same to check that.

Prangadj