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"/>
<asp:dropdownlist id="ddloptions" runat="server" >
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.