Aspose.Cells for Java

What’s new in Aspose.Cells Java V7.0?

• Separate compiled versions of the product for different JDKs, e.g. 1.4, 1.5, 1.6
• Set formulas with external references
• Support for ListObjects / Tables
• Support for AutoShapes Objects
• Enhancements made to Shape-to-Image feature
• Enhancements made to Chart-to-Image feature
• Enhancements made to Sheet-to-Image feature
• Enhancements made to Excel-to-PDF feature
• Enhancements made to Auto-Fit Rows/Columns feature

What’s new in Aspose.Cells Java V2.5.2?

• Now supports the ability to read Pivot Tables from template files
• You can now add LineShape to Excel 2007 XLSX files
• Now provides support for setting the series name when setting a chart's data source
• Now supports the ability to get/set gridlines' visibility of different Worksheets in ODS files
• Enhancements made to Chart-to-Image, Sheet-to-Image and Excel-to-PDF features
• Enhancements made to parsing Formulas functionality
• Enhancements made to copying Cells functionality

What’s new in Aspose.Cells Java V2.4.0?

• Includes Sheet to Image, Sheet to Print and Workbook to Print features
• Supports Conditional formatting for Excel to Pdf features
• Provides support for grouping pivot table fields in Excel 2007 files
• Keeps macros when converting Excel 97-2003 files to Excel 2007 files
• Renders Shapes when converting to Pdf files, e.g. TextBox, Rectangle, Oval, Arc
• Supports to get/set full name of the source file for the Ole Object
• Enhancement is made for reading/saving Conditional formatting
• Enhancement is made for Chart to Image feature
• Enhancement is made for direct Excel to Pdf feature
• Enhancement is made for formatting of cell values
• Enhancement is made for removing header/footer of PageSetup
• Enhancement is made for copying cells
• 22 other fixes and enhancements

What’s new in Aspose.Cells Java V2.3.0?

• Nowe supports saving PDF files directly without using Aspose.Pdf for Java
• Includes EMF image format support for Chart-to-Image features
• Now imports the CalculationMode attribute from MS Excel 2007 template files
• Worksheet's Copy operation enhanced
• Copying Formulas enhanced
• Improved reading ODS files with ODF 1.2
• Improved reading Charts with gradient fill effect
• Reading XLS template files optimized
• 31 other fixes and enhancements

What’s new in Aspose.Cells Java V2.1.1?

• Provides Chart-to-Image feature.
• Imports RichText from SpreadSheetML template file.
• Supports to export Name object with external references for SpreadSheetML file.
• Exports Pictures in PageSetup for Excel 2007 files.
• Imports TextBox controls from Excel 2007 files.
• Provides support to set record limit when importing data from ResultSet for Smart Markers.
• Sets the position of a Shape to the center of given range.
• Supports to add calculated field for a PivotTable.
• Supports to get/set VeryHidden property for a Worksheet.
• Adds new formula to the supported formulas list: FREQUENCY
• Recognizes the file format automatically for LightCells API.
• Enhances style’s model for performance consideration.
• Improves the API regarding Comment for performance consideration.
• Enhances the performance of reading large Excel 2007 files.
• Boosts the performance of LightCells API for large Excel 2007 files.
• Reading operation for a document’s properties is enhanced.
• Importing CSV files operation is enhanced.
• 67 fixes and enhancements.

What’s new in Aspose.Cells Java V2.1.1?

• Imports Excel spreadsheets that are in HTML format.
• Provides support for ResultSet with type TYPE_FORWARD_ONLY for Smart Markers.
• Supports to get the relative GroupBox that a RadioButton is in.
• Changes the controls’ status according to their Linked Cell value, or changes the Linked Cell value according to controls’ status.
• Shifts rows upward/downward for cells or range of cells.
• Supports to apply given style on a cell or a range of cells by a specified StyleFlag.
• Provides support to import/export an array formula for Excel 2007 file.
• Imports Document Properties when reading Excel 2007 file.
• Provides support to import/export controls, such as, CheckBox, ComboBox, ListBox etc. for Excel 2007 file.
• Parses fill settings when reading Chart from xls file.
• Supports formula for the text of ChartFrame related objects such as Title, DataLabels.
• Improved the model for Line and Area (Fill) to support new properties that are imported by Excel 2007 file format.
• Improved the model for Markers to support new properties that are imported by Excel 2007 file format.
• Workbook.save() method is enhanced for saving large Workbooks to remote file system on the network.
• The performance of reading large XLSX files has been enhanced.
• The performance of autoFitRows/Columns has been optimized.
• Enhancements for saving file as HTML format: exports images to customized destination; handles images when saving HTML file; improves performance by cutting off string values that cross multiple cells.

What’s new in Aspose.Cells Java V2.1?

• Added new features for Open Document Spreadsheet files (ODS): Hyperlink, Page Setup options, Group outline, Conditional formatting, Data validation, AutoFilter, Page Break, PrintTitleRows/Columns, Shapes related objects(Comment, Arc, Button, CheckBox, ComboBox, GroupBox, GroupShape, Label, Line, ListBox, OleObject, Oval, Picture, RadioButton, Rectangle, ScrollBar, Spinner, TextBox), Chart.
• Provided new features for MS Excel 2007 file format: Inserting Pictures, Adding Charts.
• You can now apply Subtotals to worksheet tables.
• 48 fixes and other enhancements

What’s new in Aspose.Cells Java V2.0.1?

• Introduced support for importing / exporting spreadsheets in ODS (OpenDocument Spreadsheet) format in this version
• Setting a shared formula is now supported and strong encryption type is now available
• You may manipulate advanced controls (e.g. Check box, Button, Radio button, Combo box, List box, Group box, Scroll bar, Label etc.)
• The component now has the ability to get image data from Pictures and Ole Objects
• Now support the ability to create pivot charts

What’s new in Aspose.Cells Java V2.0?

• Supported added to manipulate charts in Excel 97-2003 template files
• Supported added to read and save Excel 2007 XLSM, XLTX, XLTM file
• Now supporta drawing objects such as Shapes, Charts, etc. in Excel 2007 format
• Supported added to set outline border for a range
• Supported added to read OleObject from template file
• Supported added to insert AVI file as OleObject
• Supported addedto copy Macros when copying Workbook
• Now supports images in xls2pdf
• Now supports new Excel formula functions: MROUND, FDIST, NEGBINOMDIST

Aspose.Cells for Java is a Java spreadsheet creation engine. It can read, modify and write Excel files compatible with different platforms such as Windows, Linux and Unix. With this component, your Java programs will have the ability to present data a most popular and way.

Common Features

• Create native excel files
• Read excel files
• Supports file formats of Microsoft Excel 97-2007 Editions
• Supports unicode
• Supports Multi-worksheets
• Easy to use APIs
• Supports to configure sheet display options settings
• Supports cell data access and manipulation
• Provides total control of cell formattings
• Supports rich text settings in a cell
• Supports to configure Row/Column settings
• Supports to configure Range settings
• Import data from JDBC Resultset
• Formula settings
• Hyperlinks
• Preserving Pictures, charts, macros and pivottables in template file
• Page Setup support
• Pagebreaks settings
• Validations settings
• Worksheet Protection
• Freeze Panes

Advanced Features

• Open excel files and save to streams
• Send output to a client browser
• Import/Export data from different data sources, such as a DataTable, DataView, DataGrid or an Array
• Import images and charts
• Create images and charts at runtime through API
• Import formula from a designer spreadsheet
• Supports add-ins
• Supports VBA
• Supports macros
• Supports page setup through API