Aspose.Cells for Java 1.9.2

Aspose.Cells for Java 1.9.2 is a flexible and fast program which will strive to demonstrate three major services: reliability, quality 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.

Major Features:

1. No Microsoft Excel Automation: Aspose.Cells for Java is the most flexible component that allows developers to create and manage Excel Spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system. All Aspose components are totally independent and are not affiliated with, nor authorized, sponsored, or otherwise approved by Microsoft Corporation. In short, Aspose.Cells for Java is a better alternative to automation in terms of security, stability, scalability/speed, price and features.
2. Advanced Features: Unlike similar products from other vendors, Aspose.Cells for Java not only supports spreadsheet generation and other basic file formatting features, but also supports a number of advanced features. These advanced features make it much more convenient for the developers to manipulate spreadsheet contents, cells formatting and files protection. Aspose.Cells for Java supports features such as:
   • Saving and opening Excel files to and from streams
   • Sending output to a client browser
   • Saving and opening ODS format files
   • Importing and exporting data from an Array, ArrayList and Recordset
   • Importing images and charts
   • Creating images and charts through API
   • Importing formula from a designer spreadsheet
   • Configuring page setup through API
   • Aspose.Cells for Java also supports Addins, VBA and macros. Moreover, there are also a number of unique features that developers can only find in Aspose.Cells for Java such as:
   • The support of CSV format
   • Adding the copy of an existing worksheet (with full contents, images and charts etc.) to a file
   • 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
   • Creating PivotTables through API
   • Processing data in Excel files in Event driven mode
   • Saving as Html files or streams
   • Supporting custom chart API
   • Formula calculation engine etc.
3. Platform Independence: Aspose.Cells for Java cover most of the popular development environments and deployment platforms. Aspose.Cells for Java is available for Java 1.4 or 1.5 and will run in any place where Java is installed. You can also use Aspose.Cells for Java with PHP.
4. Support for many Different File Formats: Using Aspose.Cells for Java, developers can easily open and save a multitude of file formats. These include Excel 97 / 2000 / XP / 2007 (XLSX), SpreadSheetML, Tab Delimited and CSV documents. Using Aspose.Cells for Java you can also open encrypted Excel files. It is even possible to convert Excel documents into PDF format by using another Aspose product (that is Aspose.Pdf for Java) alongwith Aspose.Cells for Java. Aspose.Cells for Java also supports to open and save ODS(Open Document Spreadsheet) format files.

Enhancements:

• Includes supports to iterate all cells of one worksheet by one Iterator
• Removed the 64K rows and 256 columns limitation for Excel2007
• Fixed a bug of losing merged style when copy row and column
• And other improvement.