Convert Excel to PDF Using Aspose.Cells in .NET

Introduction

For .NET developers and businesses working extensively with Excel files, converting spreadsheets to PDF is essential for ensuring secure sharing and preserving data formatting. PDF files maintain document integrity across devices and platforms, making them ideal for business reports, analytics, and archival needs. With Aspose.Cells for .NET, developers can seamlessly convert Excel files to PDF while retaining formatting, styles, and visual integrity. In this guide, we’ll cover all the steps necessary to convert Excel spreadsheets into polished PDF documents using Aspose.Cells for .NET.

Prerequisites

.NET Development Environment

  • Visual Studio: Ensure Visual Studio (any recent version) is installed for a streamlined coding experience.
  • .NET Framework: The code in this guide requires .NET Framework 4.0 or higher.

Aspose.Cells for .NET Library

  • Download Aspose.Cells: Obtain the latest version of Aspose.Cells for .NET here.
  • Trial License: If you’re testing the library, you can get a temporary license here.

With these prerequisites, you’re ready to start transforming your Excel files into PDFs using Aspose.Cells!

Setting Up the Project

Let’s begin by configuring the development environment to enable the functionalities of Aspose.Cells.

Creating a New .NET Project

  1. Open Visual Studio and select “Create a new project.”
  2. Choose the Console App (.NET Framework) template.
  3. Name your project, for example, “ExcelToPDFConverter,” and set the framework to .NET 4.0 or higher.

Adding Aspose.Cells to the Project

  1. Right-click your project in Solution Explorer and select Manage NuGet Packages.
  2. In the NuGet Package Manager, search for “Aspose.Cells” and install it to add it to your project.

Importing Required Namespaces

In your Program.cs, add the following namespaces to access the Aspose.Cells functionalities:

using System.IO;
using Aspose.Cells;

With this setup, you’re now ready to dive into the coding process.

Follow these steps to convert an Excel file to a PDF document, preserving its original formatting.

Step 1: Define the File Path

Set up the path to the directory where your Excel files are stored and where you want to save the PDF output.

// The path to the documents directory.
string dataDir = "Your Document Directory";

Replace "C:\ExcelFiles\" with the directory path on your system.

Step 2: Load the Excel File into a Workbook Object

Create a new Workbook object by loading your Excel file. This Workbook object will hold the data and format of your spreadsheet.

// Instantiate the Workbook object to open the Excel file
Workbook workbook = new Workbook(dataDir + "sample.xlsx");

Make sure sample.xlsx exists in your dataDir.

Step 3: Convert and Save the Excel as PDF

Save the Workbook as a PDF, specifying the file path and save options.

// Save the workbook to PDF format
workbook.Save(dataDir + "Output.pdf", pdfOptions);

The above code converts the sample.xlsx file to Output.pdf in the specified directory, applying the options you set earlier.

Step 4: Confirm Completion

After the conversion, print a message to indicate that the PDF has been created successfully.

// Notify the user of completion
Console.WriteLine("Excel to PDF conversion completed successfully.");

Conclusion

With Aspose.Cells for .NET, converting Excel spreadsheets into PDF documents becomes an efficient process, enabling developers to maintain the quality and integrity of their data. Aspose.Cells is a robust library offering extensive customization options, allowing developers to create tailored PDF documents that meet exact business needs.

FAQ’s

Which versions of .NET does Aspose.Cells support?

Aspose.Cells supports .NET Framework 4.0 and higher, including .NET Core and .NET 5/6.

Can I convert multiple Excel files at once?

Yes, by looping through a list of file paths, you can batch-convert multiple Excel files to PDF.

Is there a free version of Aspose.Cells?

Yes, a free trial version is available for evaluation, which you can download here.

Can I specify specific worksheets to convert?

Yes, by setting OnePagePerSheet in PdfSaveOptions, you can convert specific sheets on single pages in the PDF.

Where can I find more documentation for Aspose.Cells?

Visit the Aspose.Cells documentation for detailed guides and code examples.

Convert Excel Charts to PDF Using Aspose.Cells for .NET