This is a migrated thread and some comments may be shown as answers.

Export to Excel - Drop Down List/TextBox

1 Answer 67 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Meena
Top achievements
Rank 1
Meena asked on 28 Aug 2009, 01:59 PM
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

1 Answer, 1 is accepted

Sort by
0
Prangadj
Top achievements
Rank 1
answered on 02 Sep 2009, 03:49 PM
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
Tags
Grid
Asked by
Meena
Top achievements
Rank 1
Answers by
Prangadj
Top achievements
Rank 1
Share this question
or