Screenshot Preview

Aspose.Cells for Java - Summary

by Aspose - Product Type: Component / Java Class

Summary

Aspose.Cells for Java by Aspose

URLs: aspose-cells-java, aspose cells java, asposecellsjava, aspose

Create and manage Excel Spreadsheets without requiring Microsoft Excel. Aspose.Cells for Java delivers real Excel spreadsheets in a desktop or web server environment without Microsoft Excel installed on either server or user's computer. Aspose.Cells for Java supports spreadsheet generation and other basic file formatting features. Aspose.Cells for Java also supports a number of advanced features. These advanced features make it much more convenient for developers using Aspose.Cells for Java to manipulate contents, format cells and protect files.

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

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

Create and manage Excel Spreadsheets without requiring Microsoft Excel.

Pricing: Aspose.Cells for Java V7.0 1 Developer with Deployment to 1 Physical Location - Small Business Subscription License - Includes Maintenance and Support (1 Year) , Aspose.Cells for Java V7.0 1 Developer with Deployment to Unlimited Physical Locations - OEM Subscription License - Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 10 Developer with Deployment to 10 Physical Locations - Site Small Business Subscription License - Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 10 Developer with Deployment to Unlimited Physical Locations - Site OEM Subscription License - Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 - Subscription Renewals Post Expiry 1 Developer Small Business Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 - Subscription Renewals Post Expiry 1 Developer OEM Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 - Subscription Renewals Post Expiry 1 Site Small Business Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 - Subscription Renewals Post Expiry 1 Site OEM Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 - Subscription Renewals Pre Expiry 1 Developer Small Business Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 - Subscription Renewals Pre Expiry 1 Developer OEM Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 - Subscription Renewals Pre Expiry 1 Site Small Business Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose.Cells for Java V7.0 - Subscription Renewals Pre Expiry 1 Site OEM Subscription License Subscription Renewal – Includes Maintenance and Support (1 Year), Aspose Priority Support Developer Small Business 1 Year Priority Support License, Aspose Priority Support Developer OEM 1 Year Priority Support License, Aspose Priority Support Site Small Business 1 Year Priority Support License, Aspose Priority Support Site OEM 1 Year Priority Support License

Evals & Downloads: View the Aspose.Cells for Java Documentation, Read the Aspose License Agreement - Requires Acrobat Reader, Download the Aspose.Cells Java V7.0 evaluation on to your computer - Output Displays Evaluation Label

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows 2000

Architecture of Product: 32Bit

Product Type: Component

Component Type: Java Class

Keywords: aspose.cells for java, aspose.cells java, aspose cells for java, aspose cells java, aspose.cell for java, aspose.cell java, aspose cell for java, aspose cell java, aspose excel java, aspose.cells for java distributor, aspose cells java distributor, aspose.cells for java reseller, aspose cells java reseller, aspose.cells for java developer, aspose cells java developer, aspose.cells for java license, aspose cells java license, aspose.cells for java site, aspose cells java site, aspose.cells for java subscription, aspose cells java subscription, aspose.cells for java oem, aspose cells java oem, aspose.cells for java renewal, aspose cells java renewal, aspose.cells for java upgrade, aspose cells java upgrade

Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl

Part numbers: PC-516645-400191 516645-400191 PC-516645-400193 516645-400193 PC-516645-400195 516645-400195 PC-516645-400197 516645-400197 PC-516645-400183 516645-400183 PC-516645-400184 516645-400184 PC-516645-400185 516645-400185 PC-516645-400186 516645-400186 PC-516645-400187 516645-400187 PC-516645-400188 516645-400188 PC-516645-400189 516645-400189 PC-516645-400190 516645-400190 PC-516645-400199 516645-400199 PC-516645-400200 516645-400200 PC-516645-400201 516645-400201 PC-516645-400202 516645-400202

Mfr. Part No: APJVCEDE APJVCEDO APJVCESE APJVCESO