Grid export PDF/EXCEL

[balaji]

Hi,

I'm working on export rad grid data to pdf/excel.

I have a custom filter for all the columns with dropdown,datetime and checkbox filter. while i export i dont want this filter template to populate either pdf/excel.(bcoz its putting 0(zero) instead of filter column). and i used Office2007 skin so i need to have same while export pdf.

Please help me on this and thanx in advance.

Balaji

[Princy]

Hello Balaji,

If you want to hide filter item in exported file, try the following code snippet.

C#:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)

   {

       if (e.CommandName == RadGrid.ExportToExcelCommandName)//when exporting to Excel


       {

             GridFilteringItem filterItem = (GridFilteringItem)RadGrid1.MasterTableView.GetItems(GridItemType.FilteringItem)[0];

             filterItem.Visible = false;

             RadGrid1.ExportSettings.OpenInNewWindow = true;

       }

   }

Thanks,
Princy.

[balaji]

thanx princy it worked charm... do u've any idea about apply skin (i.e office2007) /style for export PDF.

[Princy]

Hello Balaji,


RadGrid do not export any external styles. That means that your skins will not appear in the generated file. Still, the inline styles are preserved and should be used instead.

The documentation describes more:
PDF export
Word/Excel export (HTML-based)


Thanks,
Princy.