Available for: UI for ASP.NET AJAX | UI for ASP.NET MVC | UI for WPF | UI for WinForms | UI for Silverlight

Using PdfFormatProvider

PdfFormatProvider is part of SpreadProcessing which allows export to PDF format.

Using PdfFormatProvider

PdfFormatProvider makes it easy to export a Workbook to a PDF format. Each Worksheet exported to PDF is being divided into pages according to its WorksheetPageSetup. More information about paging a Worksheet is available in the Worksheet Page Setup documentation article.


In order to use PdfFormatProvider you need to add references to the assemblies listed below:

  • Telerik.Windows.Documents.Spreadsheet.dll

  • Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf.dll


Example 1 shows how to use PdfFormatProvider to export a Workbook to a file.

Example 1: PdfFormatProvider export example

Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf.PdfFormatProvider pdfFormatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf.PdfFormatProvider(); 
using (Stream output = File.OpenWrite("Sample.pdf")) 
    Workbook workbook = CreateSampleWorkbook(); // The CreateSampleWorkbook() method generates a sample spreadsheet document. Use your Workbook object here. 
    pdfFormatProvider.Export(workbook, output); 

The result from the export method is a document that can be opened in any application that supports PDF documents.

Example 2: Export to RadFixedDocument

Workbook workbook = CreateSampleWorkbook(); 
Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf.PdfFormatProvider provider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.Pdf.PdfFormatProvider(); 
RadFixedDocument fixedDocument = provider.ExportToFixedDocument(workbook); 

RadFixedDocument is the base class of the RadPdfProcessing library. Additional information on the library and its functionality can be found here.

In this article
Not finding the help you need? Improve this article