Aspose.Cells for Java 1.9.4

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 ResultSet or Array, 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.