Aspose.Cells for Java 8.1.0

An XLS Java Spreadsheet SDK for spreadsheet reporting.
Aspose.Cells will demonstrate three major services: reliability, quality and performance.

Aspose.Cells is a Java component for spreadsheet reporting without using Microsoft Excel. Other useful features include spreadsheet creation, formula settings, macros, VBA, unicode, hyperlinks, pivot tables, open encrypted excel files, importing data from JDBC ResultSet and supports all advanced features of data management, formatting, worksheet, charting and graphics.

Main features:

  • Ability to save and open Excel files to and from streams
  • Send output to a client browser
  • Save and open ODS format files
  • Import and export data from an Array, ArrayList and Recordset
  • Import images and charts
  • Create images and charts through the product API
  • Import formulae from a designer spreadsheet
  • Configure page setup through the product API
  • Support of the CSV format
  • Add a copy of an existing worksheet (with full contents, images and charts etc.) to a new file
  • Creat comments
  • Auto-filters and page breaks through the product API
  • Set complex formulae
  • Support conditional formatting
  • Support protection options introduced in Microsoft Excel XP
  • Manipulate named ranges
  • Create PivotTables through the product API
  • Process data in Excel files in Event driven mode
  • Save as HTML files or streams
  • Support custom charts through the product API
  • Formula calculation engine
  • Platform Independence:
  • Aspose.Cells for Java together with Aspose.Cells for .NET cover the main development environments and deployment platforms in common use today.
  • Aspose.Cells for Java is available for Java 1.4 or 1.5 and will run wherever Java is installed. You can also use Aspose.Cells for Java with PHP.
  • Flexible Display Options:
  • Aspose.Cells for Java gives you complete control over page setup and allows you to manipulate a wide range of display options such as; preview page breaks and set default zoom level for the Worksheet, control data visibility using Freeze Panes, set page orientation, scaling, paper size, headers/footers, and print area etc.
  • Security features:
  • Aspose.Cells for Java offers a wide range of security features such as; support for Excel 2007 XLSX file encryption and decryption, protect Contents, Objects and Scenarios of a Worksheet and hide or unhide a Worksheet.
  • Manipulate Rows and Columns:
  • Aspose.Cells for Java allows you to manipulate Rows and Columns in many different ways. You can easily adjust Row height and Column width as required, auto size the width/height of cells according to contents, insert or delete, hide or unhide and group or ungroup Rows and Columns.
  • Data Management:
  • Aspose.Cells for Java provides extensive support for data management. You can easily manipulate any Cell in the Worksheet at runtime, import data into Worksheets from different data sources and export cells data to a DataTable.
  • Comprehensive Formatting Support:
  • Aspose.Cells for Java gives you absolute control over how your data is presented by offering advanced formatting features. You can apply formatting to a Worksheet, Row, Column and Cell. You can also add Rich Text to a Single Cell and apply different Borders, Background Patterns and Fonts. Conditional formatting can also be applied to Cells.
  • Creating Charts:
  • Aspose.Cells for Java comes with complete support for charting and supports all standard chart types. You can easily add customized charts using the products API and dynamically set data for the charts. Aspose.Cells for Java also allows you to convert charts to images.
  • Graphics Capabilities:
  • Aspose.Cells for Java provides extensive graphical capabilities, allowing you to easily convert Worksheets to images as well as the ability to add images to Worksheets at runtime.

last updated on:
June 7th, 2014, 18:10 GMT
file size:
27.7 MB
license type:
developed by:
Aspose Pty Ltd
operating system(s):
Windows All
C: \ Programming \ Components & Libraries
Aspose.Cells for Java

In a hurry? Add it to your Download Basket!

user rating 6



Rate it!
What's New in This Release:
  • Enhancements:
  • Restrict the API to use the fonts directory specified using CellsHelper.setFontDir method
  • lines of diagram are not crisp/sharp
  • Get display color defined in custom number format
read full changelog

Add your review!