Export to Excel - Drop Down List/TextBox

2 posts, 0 answers
  1. Meena
    Meena avatar
    11 posts
    Member since:
    Jul 2008

    Posted 28 Aug 2009 Link to this post

       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.
  2. Prangadj
    Prangadj avatar
    174 posts
    Member since:
    Jan 2008

    Posted 02 Sep 2009 Link to this post

    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.

Back to Top