In this blog we will discuss how to convert an existing XSLX file to PDF using MindFusion.Spreadsheet for WinForms.
Introduction
As with all previous blogs we start off by creating a new Windows Forms Application in Visual Studio and adding a WorkbookView control to the main form. The WorkbookView displays a Workbook with a single worksheet.
Importing the XLSX file
In MindFusion.Spreadsheet XLSX files are imported using instances of the ExcelImporter class. For the purposes of this blog we will import an existing report.xlsx file, contained in the zip of the sample. To import this file, use the following code:
var importer = new ExcelImporter(); importer.Import(Path.Combine(path, "report.xlsx"), workbook1);
Creating the PDF
To create a PDF file from the imported worksheet, create an instance of the PdfExprter class and call its Export method:
var exporter = new PdfExporter(); exporter.EnableGridLines = true; exporter.Export(workbook1.Worksheets[0], Path.Combine(path, "report.pdf"));
The following image illustrates the result of the conversion:
The source code of the sample is available for download from here:
https://mindfusion.eu/_samples/SpreadsheetConvertPdf.zip
The trial version of MindFusion.Spreadsheet for WinForms can be downloaded from here:
Download MindFusion.Spreadsheet for WinForms Trial Version
About MindFusion.Spreadsheet for WinForms: A powerful .NET spreadsheet component with great capabilities for editing, styling and formatting large amounts of data.