[Solved] Export to excel with Validation Choices

[aung maw]

Hi All, Excel export feature works fine, but would like to add a Listbox values in one of the columns during the export.  For example, There is a column called category and when exported this column should not only have category value but also choice for other categories (Apple, Orange, Grape) in a drop down list.  Please let me know.

Thanks,

[Shinu]

Hi,

Try adding a DropDownList with desired categories in a GridTemplateColumn and while exporting set the ExportOnlyData property to false.

ASPX:

 <telerik:GridTemplateColumn UniqueName="TempCol"  HeaderText="Category" >
            <ItemTemplate>
            <asp:DropDownList ID="DropDownList1" runat="server" >
                  <asp:ListItem Text="Apple" ></asp:ListItem>
                <asp:ListItem Text="Orange" ></asp:ListItem>
               <asp:ListItem Text="Grape" ></asp:ListItem>
            </asp:DropDownList>
            </ItemTemplate>
          </telerik:GridTemplateColumn>

CS:

 protected void Button2_Click(object sender, EventArgs e)
    {
        RadGrid1.ExportSettings.ExportOnlyData = false;
        RadGrid1.MasterTableView.ExportToExcel();
    }

Thanks
Shinu