Aspose.Cells for .NET/Java
Aspose.Cells strives to demonstrate three major services:
quality, reliability and performance. Aspose.Cells offers easy to use APIs that
support a wide variety of features with opening and saving native Excel files as
its core feature. It has many common features including worksheet management,
manipulating rows and columns, data formats, manipulating cells, formatting
cells, shaping borders, setting colors, setting fonts and inserting/deleting
range of cells.
Besides supporting common features, Aspose.Cells also supports
many advanced features such as opening and saving Excel files to and from
streams, sending output to a client browser, importing and exporting data from a
variety of data sources, importing images and charts,
creating images and charts through API, importing formulae from a designer
spreadsheet and configuring page setup through API. Aspose.Cells also supports
Add-ins, VBA and macros.
Moreover, there are also a number of other advanced features
including: the support of CSV and SpreadsheetML format, adding a copy of an
existing worksheet (with fully formatted contents, images and charts etc.) to a
file, combining two workbooks, copying a workbook, setting gradient background
for charts through API, creating comments, auto-filters and page breaks through
API, setting complex formulae, supporting conditional formatting, supporting
protection options introduced in Microsoft Excel XP, manipulating named ranges,
locating APIs, supporting custom chart API and formula calculation engine etc.
Some features available in Aspose.Cells for .NET are not available in Aspose.Cells for Java. For a detailed comparison of features, please review Edition Types.