If you are looking for a .NET library to convert Excel workbooks and sheets to PDF, you are in the right place. «Excel to PDF .Net» helps you convert any of .xls or .xlsx documents.
During the conversion process you may: select custom sheets and area of cells for conversion, specify page properties, add page numbers and the version of PDF format.
To illustrate how to easily convert Excel workbook to PDF, let's look at simple code in C#:
Add a reference to the "SautinSoft.Excel.dll":
![How to add the reference to the SautinSoft.Excel.dll]( "How to add the reference to the SautinSoft.Excel.dll")
Type this C# code:
SautinSoft.ExcelToPdf x = new SautinSoft.ExcelToPdf(); x.ConvertFile(@"d:\Table.xlsx", @"d:\Table.pdf");
Download
To see this functionality firsthand, download the freshest «Excel to PDF .Net» with code examples, 34.7 Mb.
NugetLimitations
Excel to PDF .Net The limitations of the free version are: The trial notice "Created by unlicensed version of Excel to PDF .Net" and the random addition of the word "TRIAL".
Some examples to convert Excel to PDF in C# and VB.NET
1. Let us say, to convert an Excel workbook to PDF in memory within C# application:
public static void ConvertExcelAsMemoryStream()
{
// Convert Excel to PDF in memory
ExcelToPdf x = new ExcelToPdf();
// Set PDF as output format.
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf;
string excelFile = @"d:\MyWorkBook.xls";
string pdfFile = Path.ChangeExtension(excelFile, ".pdf");
byte[] pdfBytes = null;
try
{
// Let us say, we have a memory stream with Excel data.
using (MemoryStream ms = new MemoryStream(File.ReadAllBytes(excelFile)))
{
pdfBytes = x.ConvertBytes(ms.ToArray());
}
// Save pdfBytes to a file for demonstration purposes.
File.WriteAllBytes(pdfFile, pdfBytes);
System.Diagnostics.Process.Start(pdfFile);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.ReadLine();
}
}
2. Convert .xlsx file to PDF file in VB.NET application:
Sub Main()
' Specify sheets for converting
Dim x As New ExcelToPdf()
x.PageStyle.PageSize.Letter()
' Set PDF as output format.
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf
' Let's convert only sheets: 1,3.
x.Sheets.Custom(New Integer() {1, 3})
Dim excelFile As String = "d:\Sheets.xlsx"
Dim pdfFile As String = Path.ChangeExtension(excelFile, ".pdf")
Try
x.ConvertFile(excelFile, pdfFile)
System.Diagnostics.Process.Start(pdfFile)
Catch ex As Exception
Console.WriteLine(ex.Message)
Console.ReadLine()
End Try
End Sub
Requirements and Technical Information
«Excel to PDF .Net» can be used on 32 and 64-bits platforms with .NET Framework 4.0, .NET Core 2.0 and higher. The component doesn't require Microsoft Excel or any other software. It's absolutely standalone and independent library.
Our product is compatible with all .NET languages and supports all Operating Systems where .NET Framework and .NET Core can be used. Note that «Excel to PDF .Net» is entirely written in managed C#.
