Aspose.Cells for Java 1.9.1.0

Easy to use APIs that support a wide variety of features with opening and saving native Excel files as its core feature Aspose.Cells 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.
Moreover, there are also a number of other advanced features including: the support of CSV and SpreadsheetML format, adding a copy of an existing worksheet (with fully formatted contents, images and charts etc.) to a file, combining two workbooks, copying a workbook, setting gradient background for charts through API, 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, locating APIs, supporting custom chart API and formula calculation engine etc.
Main features:
Document Features
- Open Plain or Encrypted Excel files of different format types (Excel97~Excel2003) from different sources
- Save Excel files in different formats types (Excel97~Excel2003)
- Open Excel files to Streams
- Sending output to the Client Browser
- Save Excel files from Streams
- Load and Save SpreadsheetML files
- Load and Save CSV file
- Load and Save Tab Delimited files
- Protect a whole Workbook
- Find and Replace data in a Workbook
- Set a default style to the whole Workbook
- Access and Modify the Document Properties of Excel files
- Preserve Pictures, Charts, Macros and PivotTables in a Template file
Worksheet Features – Management
- Create and access Worksheet
- Copy a Worksheet’s data
- Move a Worksheet to a specific location in the Workbook
- Set a specific Worksheet as an active sheet
Worksheet Features - Display Options
- Hide or Unhide a Worksheet
- Display or Hide Tabs, Scroll Bars, Gridlines & Row/Column Headers
- Preview Page Breaks
- Set Zoom Level for the Worksheet
- Make selected data remain visible while scrolling using Freeze Panes
- Unfreeze panes in the Worksheet
Worksheet Features - Protection Options
- Protect Contents, Objects and Scenarios of a Worksheet
- Unprotect a Worksheet
Worksheet - Page Setup Options
- Set Page Orientation, Scaling, Paper Size, Print Quality etc.
- Set Page Margins like Top, Left, Right, Bottom, etc.
- Set Headers and Footers
- Insert Graphics in Header and Footer
- Set Header and Footer Margins
- Set Print Area, Print Title etc.
- Page Breaks and Setting
- Insert Horizontal and Vertical Page Breaks at a specified cell
- Auto-Fit Pages Horizontally and Vertically
- Repeat Printing Title rows and columns on every page
Rows & Columns Features
- Adjust Row Height according to your desire
- Adjust Column Width as required
- Insert or Delete Rows and Columns
- Hide or Unhide Rows and Columns
- Group or Ungroup Rows and Columns
- Copy Rows and Columns
Data Management Features
- Access any Cell in the worksheet
- Add data to desired Cells at runtime
- Import data from JDBC Resultset
- Retrieve data from cells according to their data types
- Create and Insert Range of Cells
- Deleting Range of Cells
- Clearing Contents in the Range
- Find or Search specific data in Cells
- Set Formulae with Built-in or Add-in Functions
- Search Formula in the Cells
- Set Array and R1C1 reference style Formula
- Add different kinds of Hyperlinks to link data
- Create or Access Named Ranges
- Lock the Cells
- Apply Data Validation and Auto-Filtering
Formatting Features
- Apply different Styles on the Cells
- Copy Styles
- Apply Number Format Settings for the Cells
- Format Cell as a Date
- Custom Formatting of the Cells
- Set Text Alignment
- Set Text Rapped, Rotation and Direction in the Cells
- Shrink Text to fit in the Column
- Merge multiple Cells into single one
- Unmerge the Cells
- Apply different kinds of Font Settings for the Cells
- Apply different Colors to Cells, Fonts, Gridlines, Graphical Objects etc.
- Set Rich Text in a Single Cell
- Apply different Border Settings on Cells
- Apply different Background Patterns on Cells
- Apply Format Settings on a Worksheet, Row or Column etc.
- Apply Conditional Formatting on Cells
Charting & Graphics Features
- Supports all Chart Types like Column, Bar, Line, Pie, Scatter, Area, Doughnut, Radar, Surface, Stock, Cylinder, Cone, Pyramid, etc.
- Create Different kinds of Charts easily
- Customize Charts by setting their different properties
- Set Data for the Charts dynamically
- Add Custom Charts to Worksheets using API
- Add Pictures to Worksheets at runtime
- Create Comments to cells
- Create CheckBoxes and TextBoxes
Advance Features
- Supports Designer Spreadsheets and Smart Markers
- Supports Formula Calculations using robust Formula Calculation Engine
- Supports accessing Aspose.Cells from COM Clients
- Create and Format Pivot Table
- Change Source Data of a Pivot Table at runtime
- Supports Add-Ins
- Supports VBA
- Supports Macros
Platforms Supported
- Desktop Application Support
- Web Application Support
- Linux
- Unix
System requirements:
- Java version 1.4 or higher