<asp:GridView ID="TypeFruit" runat="server">
<Columns>
<asp:TemplateField HeaderText="Type" >
<ItemTemplate>
<asp:DropDownList ID="ddlfruit" runat="server" >
<asp:ListItem Value="0">Select</asp:ListItem>
<asp:ListItem Value="1">Fruit</asp:ListItem>
<asp:ListItem Value="2">Other</asp:ListItem>
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Button ID="BtnExcel" runat="server" OnClick="BtnExcel_Click" />
by using above code i need to export gridview to excel.
my query is if i selected fruit from dropdownlist entire dropdownlist values exported as dropdownlist but i want to export fruit only not entire dropdown list..
if any body understand plz help me..
Thanks in advance