.NET APIs to manipulate Excel spreadsheets

Develop high performance applications to Create, Edit, Convert or Print Excel spreadsheet file formats without requiring Microsoft Excel.

  Download Free Trial
Aspose.Cells for .NET

Aspose.Cells for .NET


Aspose.Cells for .NET is an Excel Spreadsheet Programming API allowing software developers to manipulate and convert spreadsheet files from within their own applications. A combination of APIs and GUI controls - Aspose.Cells for .NET speeds up the spreadsheet processing and conversion tasks.

Aspose.Cells for .NET contains APIs to be used with .NET Framework, .NET Core & Xamarin platform, empowering you to build cross-platform applications having the ability to generate, modify, convert, render and print spreadsheets without using Microsoft Excel.


Advanced Excel Spreadsheet API Features

Aspose.Cells for .NET includes the following features:


Ability to save and load Excel files to and from streams


Send output to a client browser


Import and export data to and from DataTable, DataView or Array


Configure page setup through the product API


Create charts through the product API


Import formulae from a designer spreadsheet

Aspose.Cells for .NET also supports a number of unique features that developers can only find in this API:


Support for CSV, Tab-delimited & HTML formats


Support for Office Open XML (OOXML) formats


Create copies of existing worksheets


Set the gradient background for charts


Create & manipulate comments


Set auto-filters & page breaks


Set complex formulae


Specify conditional formatting rules


Set protection options introduced in Microsoft Excel XP


Create & manipulate named ranges


Create & render sparklines


Add Digital Signatures


Create & render custom charts


Formula calculation engine


Export worksheets to SVG format


Read & write large spreadsheets in light-weight mode


Re-sample images in Excel-to-PDF conversion


Trace Precedents and Dependents


Create and manipulate Scenarios


Modify VBA code or Macros in the template file


Save ODS file in ODF 1.1 and 1.2 specifications


Optimize memory usage while working with large files


Populate spreadsheets via Smart Markers


Dynamically create & manipulate Pivot Tables

Convert Excel Spreadsheets to PDF, XPS & HTML Formats

Aspose.Cells for .NET is capable of converting spreadsheets to PDF, XPS & HTML formats while maintaining the highest visual fidelity. The conversion process is simple yet reliable, thus making Aspose.Cells a perfect choice for the organizations which require to exchange documents in any of the industry standard formats.

Save spreadsheet in different formats - C#

// load file to be converted
var workbook = new Aspose.Cells.Workbook(dir + "template.xlsx");

// save in different formats
workbook.Save(dir + "output.pdf", Aspose.Cells.SaveFormat.Pdf);
workbook.Save(dir + "output.xps", Aspose.Cells.SaveFormat.XPS);
workbook.Save(dir + "output.html", Aspose.Cells.SaveFormat.Html);

Visualize Data with Formatting, Charts & Graphics

Aspose.Cells for .NET gives you complete freedom and flexibility to furnish your spreadsheets with all kinds of visual effects. The API allows you to apply different fonts with attributes, cell styles (alignment, indentation, rotation, borders, shading and coloring, protection, text wrapping and shrinking) and all types of number formats.

Similarly, charts and graphics are visually appealing and can give your spreadsheet a professional look. Aspose.Cells for .NET provides a comprehensive set of APIs for creating and manipulating all of the standard and custom chart types. Moreover, you may add different types of drawing objects, such as comments, pictures, OLE objects, shapes and controls to the cells

Efficient, Robust & Reliable Formula Calculation Engine

Aspose.Cells for .NET has a powerful Formula Calculation Engine that supports almost all of the standard and advanced Microsoft Excel formulas and functions. You can read, set and calculate the results of the built-in, add-in, array & R1C1 reference style formulas.

Summarize Data with Pivot Tables, Charts & Smart Markers

A Pivot Table can help you quickly summarize the flat data and to get the desired information according to your needs. Aspose.Cells for .NET allows you to create Pivot Tables and Pivot Charts programatically. You can dynamically change the source data of a Pivot Table and refresh it. Moreover, Aspose.Cells for .NET offers Smart Markers which is a great feature to populate worksheets based on some data source and to create visually effective reports.

Render Excel Worksheets & Charts as Images

Aspose.Cells for .NET has its own rendering engine specially designed for rendering & printing with highest of fidelity to the Microsoft Excel. It offers distinctive features such as rendering Excel worksheets & charts to images & printing worksheets to any connected physical printer. The process is flexible thus allowing you to choose a number of options, such as controlling the resultant image dimensions when rendering worksheets & charts to images.

Convert worksheet to image - C#

// load spreadsheet file
var workbook = new Aspose.Cells.Workbook(dir + "template.xls");
// access the first worksheet from the collection
var worksheet = workbook.Worksheets[0];
// define parameters for resultant image
var options = new Aspose.Cells.Rendering.ImageOrPrintOptions()
    OnePagePerSheet = true,
    ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg
// convert worksheet to image in JPEG format
var renderer = new Aspose.Cells.Rendering.SheetRender(worksheet, options);
renderer.ToImage(0, dir + "output.jpeg");

Chart Creation & Manipulation

Aspose.Cells for .NET comes with complete support for charting. You can easily add standard or customized charts using the product API, and dynamically set the data in order to refresh the charts. Aspose.Cells for .NET also allows you to convert charts to a number of image formats.

Graphical Interfaces for Web & Desktop Applications

Aspose.Cells for .NET provides GUI controls for web & desktop applications. End user can use these controls to open, save & edit Excel files, import & export data, manage formatting & formulas and convert between several supported spreadsheet formats, right from your application's front-end.

Microsoft Office Automation – Not Needed

Aspose.Cells for .NET is built using managed code that never needs Microsoft Office or Microsoft Excel to be installed on the machine to work with Excel document formats. It is a perfect Microsoft Office automation alternative in terms of supported features, security, stability, scalability, speed and price.


Support and Learning Resources