[Solved] How to export grid to MS Excel?

[Goran]

Hi,

We use Telerik grid for VS2008, version 2011.3.1115.0.

We load grid dynamically into our user control that wrapped Telerik grid. There are master and content pages and our user control is placed on content page.

I need to export grid data to MS Excel file and save it to web server. There are 2 options. I can choose between exporting whole grid or selected rows.

How can I do that?

Thank you in advance.

Goran

[Princy]

Hi Goran,

You can have a condition before exporting that whether you want to export entire grid or selected rows. Please have a look into the following code which is doing exporting based on these condition. [Here I am using an external button for exporting]

ASPX:

<asp:RadioButtonList ID="RadioButtonList1" runat="server">
           <asp:ListItem Text="Export All" Selected="True"></asp:ListItem>
           <asp:ListItem Text="Export Selected"></asp:ListItem>
       </asp:RadioButtonList>
       <asp:Button ID="Button1" Width="150px" Text="Export to Excel" runat="server" OnClick="ExporttoExcel_Click">
       </asp:Button>

C#:

protected void ExporttoExcel_Click(object sender, EventArgs e)
   {
       if (RadioButtonList1.Items[1].Selected)
       {
           foreach (GridDataItem item in RadGrid1.Items)
           {
               if(!item.Selected)
                 item.Visible = false;
           }
       }
       RadGrid1.ExportSettings.ExportOnlyData = true;
       RadGrid1.ExportSettings.OpenInNewWindow = true;
       RadGrid1.MasterTableView.ExportToExcel();
   }

Thanks,
Princy.