.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 Microsoft Excel programming and conversion tasks.

Aspose.Cells for .NET gives developers powerful tools for performing simple tasks such as file format conversion or complex processes like report generation through Smart Markers. It also gives the developers full control over the page layout, formatting, charts and formulas. Developers can read and write spreadsheet files as well as render the spreadsheets to a variety of image & fixed-layout file formats.

 

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

Rendering & Printing Excel Spreadsheets

Aspose.Cells for .NET allows you to convert whole spreadsheets or even individual worksheets to a number of image & fixed-layout formats. The Excel programming API is also capable of printing the spreadsheets using physical printers while customizing the printing process.

Aspose.Cells for .NET has its own rendering engine specially designed for rendering & printing with highest of fidelity to the Microsoft Excel. Developers find it easy to print or preview spreadsheets from within their own applications, this is due to Aspose.Cells for .NET's integration with the .NET printing infrastructure and the ability to completely customize the process.

Flexible Worksheet Display Options

Aspose.Cells for .NET gives you complete control over the worksheet's page setup thus allowing you to manipulate a wide range of Excel worksheet display options such as page breaks & zoom level. You may also control the data visibility using freeze panes, set page orientation options, scaling, paper size, headers/footers and print area.

Excel Security Options for Protecting Worksheets

Aspose.Cells for .NET offers a wide range of security features including support for Excel 2007 XLSX file encryption/decryption, content, object & scenario protection and the ability to hide and un-hide rows, columns & worksheet.

Manipulate Rows & Columns

Aspose.Cells for .NET allows you to manipulate rows and columns in many different ways. You can easily adjust row height & column width or auto resize the cell dimensions according to the contents in it. The API also offers the means to insert & delete, hide & un-hide as well as group & un-group rows and columns.

Worksheet Data Management

Aspose.Cells for .NET provides extensive support for data management. You can easily manipulate any cell in a worksheet at runtime, import data onto the worksheets from different data sources and export data to a number of data structures.

Comprehensive Spreadsheet Formatting

Aspose.Cells for .NET gives you complete control over how you wish to present your data onto the worksheet, by offering advanced formatting features. You can apply formatting to individual row, column, cell, or you can create a range of cells and apply formatting to it. You can also add rich text to a cell, apply borders, set background patterns or tweak font related styling aspects.

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.

Aspose.Cells Grid Suite

Aspose.Cells for .NET also prodvides GUI controls for desktop and web applications having the following capabilities:

  • Desktop control for Windows Forms applications
  • Web control for ASP.NET Web applications
  • Apply formatting and formulae
  • Import and export data
  • Open, save and edit the Excel files from within the control

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

 
 

Aspose.Cells offers individual Excel APIs for other popular development environments as listed below: