RadGrid. Client Side Export.

[Den]

Hi!
I have a RadGrid. The grid gets data from a webservice. I want to export data to Excel. I am trying to use exportToExcel method, but it doesn't work.
How can I export data to Excel?
Thanks for your help!

[Shinu]

Hi,

Please make sure that you consume the webservice on the server and not on the client. When bound on client RadGrid does not persist data that will be used when export on server.

Thanks,
Shinu

[Den]

Hi.

The grid uses client binding. Is there any workaround to do export?

Thanks.

[Shinu]

Hi Den,

You have to bind RadGrid on the server only when exporting. Try this approach:

ASPX:

<asp:Button ID="Button1" runat="server" Text="Export" OnClick="Button1_Click" />
<telerik:RadGrid  ID="RadGrid2" AllowSorting="true"  AllowPaging="true"
     ...
     <ClientSettings>
         <DataBinding Location="~/MyWebService.asmx"  EnableCaching="true"
             SelectMethod="GetData"  />
     </ClientSettings>
</telerik:RadGrid>

C#:

protected void Button1_Click(object sender, EventArgs e)
{
    RadGrid1.DataSource = MyWebService.GetData();
    RadGrid1.Rebind();
    RadGrid1.MasterTableView.ExportToCSV();
}

Thanks,
Shinu.

[Den]

Thanks for your help. It works.