Skip to content

Latest commit

 

History

History
114 lines (88 loc) · 5.33 KB

export-charts-to-pdf-radspreadprocessing.md

File metadata and controls

114 lines (88 loc) · 5.33 KB
title description type page_title slug tags res_type ticketid
Exporting Spreadsheets with Charts to PDF with RadSpreadProcessing and WinForms RadChartView
Learn how to export charts from Excel files to PDF format using RadSpreadProcessing, including handling chart images with the WinForms ChartView control.
how-to
How to Export Charts from Excel to PDF with RadSpreadProcessing and WinForms RadChartView
export-charts-to-pdf-radspreadprocessing
spreadprocessing, document, processing, export, chart, pdf, excel, image, winforms, sheet, worksheet, xslx
kb
1659898

Environment

Version Product Author
2024.2.426 RadSpreadProcessing Desislava Yordanova

Description

When converting an Excel file with charts to PDF format using the Telerik Document Processing libraries, the charts may not display as expected in the PDF document. This may occur when exporting charts to PDF in .NET Framework applications. This KB article shows a sample approach how to utilize the chart engine that WinForms RadChartView control offers and ensure charts are properly exported from Excel files to PDF.

Solution

To export charts from Excel files to PDF format using RadSpreadProcessing, follow these steps:

  1. Implement a Custom IPdfChartRenderer: The export process requires providing an [IPdfChartRenderer]({%slug radspreadprocessing-features-charts-pdf-export%}) implementation. This renderer is responsible for converting the chart shapes from the Excel file into images that can be inserted into the PDF.

  2. Use the WinForms RadChartView control: The WinForms RadSpreadsheet control (that supports charts) internally uses the WinForms RadChartView for visualization and it provides a convenient API for image creation having the [FloatingChartShape]({%slug radspreadprocessing-features-charts-using-charts%}) from the SpreadProcessing model.

  3. Export the Excel to PDF: Use the [PdfFormatProvider]({%slug radspreadprocessing-formats-and-conversion-pdf-pdfformatprovider%}) to export the workbook to PDF, setting the ChartRenderer property to your custom renderer implementation.

Below is a sample implementation using the WinForms RadChartView for chart visualization:

using System.IO;
using Telerik.Windows.Documents.Fixed.Model.Editing;
using Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf.Export;
using Telerik.Windows.Documents.Spreadsheet.Model.Shapes;

public class WinFormsPdfChartImageRenderer : IPdfChartRenderer
{
    public WinFormsPdfChartImageRenderer()
    {
    }

    public void RenderChart(FixedContentEditor editor, FloatingChartShape chartShape)
    {
        string filePath = @"exportedChart.png";

        System.Drawing.Size size = new System.Drawing.Size((int)(chartShape.Width), (int)(chartShape.Height + 10));
        System.Drawing.Image chartImage = Telerik.WinForms.Controls.Spreadsheet.Layers.ChartModelToImageConverter.GetImageFromFloatingChartShape(chartShape, size);

        chartImage.Save(filePath);
        using (FileStream fs = new FileStream(filePath, FileMode.Open))
        {
            editor.DrawImage(fs);
        }
        File.Delete(filePath);
    }
}

Using the custom chart renderer:

            Workbook workbook;
            IWorkbookFormatProvider xlsxFormatProvider = new XlsxFormatProvider();

            using (Stream input = new FileStream("spreadsheetWithChart.xlsx", FileMode.Open))
            {
                workbook = xlsxFormatProvider.Import(input);
            }
            
            WorksheetPageSetup pageSetup = workbook.ActiveWorksheet.WorksheetPageSetup;
            pageSetup.PaperType = PaperTypes.A4;

            PdfFormatProvider pdfFormatProvider = new PdfFormatProvider();
            pdfFormatProvider.ExportSettings.ChartRenderer = new WinFormsPdfChartImageRenderer(); // new WpfPdfChartImageRenderer();

            string outputFilePath = "spreadsheetWithChart.pdf";
            File.Delete(outputFilePath);
            using (Stream output = File.OpenWrite(outputFilePath))
            {
                pdfFormatProvider.Export(workbook, output);
            }

            var psi = new ProcessStartInfo()
            {
                FileName = outputFilePath,
                UseShellExecute = true
            };
            Process.Start(psi);

Required Assemblies

  • Telerik.WinControls.RadSpreadsheet
  • Telerik.WinControls
  • Telerik.WinControls.ChartView
  • Telerik.WinControls.UI
  • TelerikCommon
  • Telerik.Windows.Documents.Core
  • Telerik.Windows.Documents.Fixed
  • Telerik.Windows.Documents.Spreadsheet
  • Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml
  • Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf

See Also