Excel spreadsheet file formats processing API for C# .NET

Aspose.Cells for .NET Installation

To set up Aspose.Cells for .NET on your system, please directly download the DLLs or the MSI Installer from the downloads section. Or, you can use the NuGet package for the .NET spreadsheet processing API installation. The package manager command is given below.

PM> Install-Package Aspose.Cells

How to Convert Excel to PDF in .NET and Quickly Merge Excel Workbooks

Convert Excel to PDF in .NET

Upgrade your .NET file converter apps by integrating the Excel to PDF conversion functionality using Aspose.Cells for .NET library. Effortlessly convert XLS and XLSX files to PDF format using a minimum amount of code. Please refer to the following information and sample coding to convert Excel to PDF in the .NET platform:

• Create an instance of the Workbook class and add the Excel document you wish to convert.
• Save the Excel document to PDF format using the Save method. Specify PDF format using the SaveFormat Enumeration.

// Instantiate the Workbook object with the Excel file
Workbook workbook = new Workbook("SampleExcel.xls");
// Save the document in PDF format
workbook.Save("outputPDF.pdf", SaveFormat.Pdf);

Merge MS Excel Workbooks in .NET

Programmatically merge multiple Excel workbooks and combine them into a single Excel file with the help of Aspose.Cells for .NET API. Enhance your .NET document merger apps by injecting MS Excel workbooks merger functionality. Please review the below-given code snippet and the information for combining multiple workbooks:

• Create two instance of the Workbook class, one each for the two workbooks to be combined.
• Merge the two workbooks using the Combine method
• Save the combined Excel workbook using the Save method.

// Define the first source workbook
// Open the first excel file.
Workbook SourceBook1 = new Workbook(dataDir+ "SampleChart.xlsx");

// Define the second source workbook.
// Open the second excel file.
Workbook SourceBook2 = new Workbook(dataDir+ "SampleImage.xlsx");

// Combine the two workbooks
SourceBook1.Combine(SourceBook2);

// Save the target book file.
SourceBook1.Save("Combined.out.xlsx");

GUI controls and advanced formula calculations in .NET