Export RadGrid data to Excel

[Jared]

I'm having a problem exporting data from radgrid to excel format. As i export the data from the grid, the button is also attached inside the excel file which is not that way. The thing is that, I have to export the data from the radgrid to excel with its exact format (colors of grid, font style), but not including object like buttons. Kindly advice.

[Princy]

Hello Jared,

You can set ExportOnlyData="true" to achieve this.
ASPX:

<telerik:RadGrid ID="RadGrid1"  runat="server" OnItemDataBound="RadGrid1_ItemDataBound">
    <ExportSettings ExportOnlyData="true">
    </ExportSettings>
    <MasterTableView >
         .   .   .   .   .
    </MasterTableView>
</telerik:RadGrid>

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
           e.Item.Style["font-size"] = "x-large";
     }

Thanks,
Princy.