How to convert Excel to PDF using C# and VB.NET?
Syncfusion Essential PDF is a .NET PDF library used to create, read, and edit PDF documents. Using this library, you can convert Excel document to PDF in C# and VB.NET.
Steps to convert excel document to PDF programmatically:
- Create a new C# console application project.
- Install the Syncfusion.ExcelToPdfConverter.WinForms NuGet packages as reference to your .NET Framework application from NuGet.org.
- Include the following namespaces in the Program.cs file.
C#
using Syncfusion.Pdf; using Syncfusion.XlsIO; using Syncfusion.ExcelToPdfConverter;
VB.NET
Imports Syncfusion.Pdf Imports Syncfusion.XlsIO Imports Syncfusion.ExcelToPdfConverter
- Use the following code snippet to convert Excel document to PDF.
C#
using (ExcelEngine excelEngine = new ExcelEngine())
{
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Excel2013;
IWorkbook workbook = application.Workbooks.Open("Sample.xlsx", ExcelOpenType.Automatic);
//Open the Excel document to convert
ExcelToPdfConverter converter = new ExcelToPdfConverter(workbook);
//Initialize PDF document
PdfDocument pdfDocument = new PdfDocument();
//Convert Excel document into PDF document
pdfDocument = converter.Convert();
//Save the PDF file
pdfDocument.Save("ExcelToPDF.pdf");
//This will open the PDF file so, the result will be seen in default PDF viewer
System.Diagnostics.Process.Start("ExcelToPDF.pdf");
}
VB.NET
Using excelEngine As ExcelEngine = New ExcelEngine()
Dim application As IApplication = excelEngine.Excel
application.DefaultVersion = ExcelVersion.Excel2013
Dim workbook As IWorkbook = application.Workbooks.Open("Sample.xlsx", ExcelOpenType.Automatic)
'Open the Excel document to convert
Dim converter As ExcelToPdfConverter = New ExcelToPdfConverter(workbook)
'Initialize the PDF document
Dim pdfDocument As PdfDocument = New PdfDocument()
'Convert Excel document into PDF document
pdfDocument = converter.Convert()
'Save the PDF file
pdfDocument.Save("ExcelToPDF.pdf")
End Using
'This will open the PDF file so, the result will be seen in default PDF viewer
System.Diagnostics.Process.Start("ExcelToPDF.pdf")
A complete working sample can be downloaded from ExcelToPDFSample.zip
By executing the program, you will get the PDF document as follows. 
Take a moment to peruse the documentation for working with document conversion , where you will find various document conversion options like Word, RTF, TIFF, and XPS to PDF.
Refer here to explore the rich set of Syncfusion Essential PDF features.
Starting with v16.2.0.x, if you reference Syncfusion assemblies from trial setup or from the NuGet feed, include a license key in your projects. Refer to link to learn about generating and registering Syncfusion license key in your application to use the components without trail message.
