RadPivot Grid Data export

[Mayank]

Hello,

I am trying to export a radPivotGrid into excel as per the documentation

 

 private void radButton1_Click(object sender, EventArgs e)
        {
            SaveFileDialog sf = new SaveFileDialog();
            sf.Filter = "EXCEL | .xls";
            if (sf.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                // Telerik.WinControls.UI.Export.ExportToExcelML htmlexport = new Telerik.WinControls.UI.Export.ExportToExcelML(radPivotGrid_StockPositionPivot);
                //  htmlexport.RunExport(sf.FileName);


                PivotGridSpreadExport spreadExport = new PivotGridSpreadExport(radPivotGrid_StockPositionPivot);
                spreadExport.RunExport(@"..\..\exported-file.xlsx", new SpreadExportRenderer());
            }
        }

 

the red marked position is throwing an exception, and code suggestion is asking to create a new class to implement SpreadExortRenderer I am not sure how it can be done, any help will be appreciated. TIA

[Dess | Tech Support Engineer, Principal]

Hello, Mayank,

The spread export functionality is located in the TelerikExport.dll assembly.You need to include the following namespace in order to access the types contained in TelerikExport:

Telerik.WinControls.TelerikExport

            SaveFileDialog sf = new SaveFileDialog();
            sf.Filter = "EXCEL | .xls";
            if (sf.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                PivotGridSpreadExport spreadExport = new Telerik.WinControls.Export.PivotGridSpreadExport(this.radPivotGrid1);
                spreadExport.RunExport(@"..\..\exported-file.xlsx", new Telerik.WinControls.Export.SpreadExportRenderer());
            }

Since this functionality is using the RadSpreadProcessingLibrary you need to reference the following assemblies as well:

Telerik.Windows.Documents.Core
Telerik.Windows.Documents.Fixed
Telerik.Windows.Documents.Spreadsheet
Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml
Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf
Telerik.Windows.Zip

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik