Aspose.Cells for Java Publisher's description
from Aspose Pty Ltd
Aspose.Cells for Java is an award-winning Spreadsheet component that allows Java developers to embed the ability to read
Aspose.Cells for Java is an award-winning Spreadsheet component that allows Java developers to embed the ability to read, write and manipulate ExcelВ® spreadsheets into their own applications without needing to rely on Microsoft ExcelВ®.
Aspose.Cells for Java is a mature, scalable and feature rich component that offers many functions that are way beyond the simple data exporting capabilites of other vendors. With Aspose.Cells for Java developers can export data, format spreadsheets to the most granular level, import images, import charts, create charts, apply and calculate complex formulas, stream ExcelВ® data, save in various formats and much more - all this without the need of Microsoft ExcelВ® or Microsoft Office Automation.
Unlike similar products from other vendors, Aspose.Cells for Java not only supports spreadsheet generation and other basic file formatting features, it also supports a number of advanced features. These advanced features make it much easier for developers to manipulate spreadsheet contents, cell formatting and file protection. Aspose.Cells for Java includes the following 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
Aspose.Cells for Java also supports Addins, VBA and macros. As well as this, there are also a number of unique features that developers will only find in Aspose.Cells for Java such as:
Support of the CSV format
Add a copy of an existing worksheet (with full contents, images and charts etc.) to a new file
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
Many many more!
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.
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.
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.
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.
What's New in This Release:В· Supports to import/export XLSB file format.
В· Includes ShapeTextFrame class to auto-size the frame to fit its contents.
В· Dotted lines are supported in Chart-to-Image feature.
В· Fixes internal bugs of reading/saving Excel 2007 files.
В· Fixes internal bugs of reading/saving ODS files.
В· Fixes bugs of reading/saving Excel 97-2003 files.
В· Chart-to-Image feature is enhanced.
В· Direct Excel-to-PDF feature is enhanced.
В· Sheet-to-Image and Sheet-to-Print features are enhanced.
В· Formula Calculation Engine is enhanced.
В· 11 fixes and enhancements.
System Requirements:В· Java
Program Release Status: Major Update
Program Install Support: Install and Uninstall