RadGridView + RadContextMenu + Export to Excel

[Meehir]

Hi,

We are using Telerik RadGridView controls for my Silverlight application and we need to have export to excel functionality by implementing context menu.  So, when user right clicks the grid, context menu should appear and on clicking on one menu item, it should export the grid data to excel.  We are following MVVM models.

Below is my code snippets:
View:
<Telerik:RadGridView x:Name="Grid1" ...>
  <Telerik:RadContextMenu.ContextMenu>
    <Telerik:ContextMenu Name="Menu1">
      <Telerik:MenuItem Header = "Export to Excel" Command="{Binding ExportCommand}" CommandParameter="{Binding ElementName=Grid1}">
      </Telerik:MenuItem>
    </Telerik:ContextMenu>
  </Telerik:RadContextMenu.ContextMenu
</Telerik:RadGridView>

In ViewModel, I have created the ICommand variable "ExportCommand" as below

public ICommand ExportCommand
{
  get

  {

      _exportCommand = new DelegateCommand<object>(

                commandParameter => {
                         var grid = commandParameter as RadGridView;
                          .... put all the code to show dialog for exporting to excel which is working in other forms perfectly
                          ..... but with CommandButton
                         grid.Export()

                 }

      );
     return _exportCommand;

  }
}

I am not getting the grid to export.  On executing below line, the grid variable becomes null.  So no data to export to excel.
var grid = commandParameter as RadGridView;

Kindly help.

Thanks,
Meehir Jha

[Vlad]

Hello,

 ElementName binding will not work in this case. I've attached example project to illustrate you how to achieve your goal.

All the best,
Vlad
the Telerik team

[Ricardo]

Hola, quiero exportar mi RadGridview desde un comando Command="{Binding ComandoExportar}" CommandParameter="{Binding ElementName=gdvILI}" pero al exportarlo sólo me exporta la página actual del Gridview y yo quiero exportar todo el Gridview sin importar el paginado.

[Dimitrina]

Hello,

You can check the "Export FAQ" article in our online documentation on how to achieve your goal.
Basically, you need to:

• Save the PageSize and the PageIndex of RadDataPager

• Set the PageSize of RadDataPager to 0

• Export the data (you can use the (IEnumerable) dataPager.PagedSource as GridViewExportOptions.Items)

• Set the PageSize and the PageIndex back

You can also export data with RadSpreadProcessing. The model is completely independent from UI. You can check our new example Export with RadSpreadProcessing on how to do so.

Regards,
Didie
Telerik