Aspose Cells for Java
Details
| Size: | 11.4 MB |
| Last Update: | 2008-01-30 10:01:59 |
| Version: | Aspose.Cells for |
| OS Support: | Windows 2K/XP/2003 |
| License/Program Type: | Shareware |
| Publisher: | Aspose Pty Ltd |
| Price: | $599.00 |
Description:
Aspose Cells for Java description
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.
Here are some key features of "Aspose Cells for
Java":
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
Requirements:
· Java version 1.4 or higher
0 comments
Add to
Aspose Cells for Java Version History
Related Software
|
|
From category: Components-Libraries |
| X360 Multi-page Tiff Converter OCX helps programmers view and create multi-page TIFF image within their applications... |
|
|
From category: SDK-DDK |
| With the SDK/DLL,you can encode more than 1100 bytes, 1800 ASCII characters, or 2700 digits to image such as BMP,PNG,JPG,GIF image using C/C++/Delphi/VB with several lines of code. It support 9 error... |
|
|
From category: File-Editors |
| TX Text Control .NET is a royalty-free word processing control that offers developers a broad range of word processing features.... |
|
|
From category: SDK-DDK |
| With the SDK/ASP Control,you can encode up to 2,335 text, 3116 digits or 1556 bytes to image using ASP or C/C++/Delphi/VB with several lines of code. It support 4 encoding modes , Reed-Solomon error c... |
|
|
From category: SDK-DDK |
| A useful and lightweight integrated development environment for creating, compiling and executing Java application... |
|
|
From category: Other-Programming-Files |
| A cross platform compatible GUI for several code formatter, beautifier and indenter... |
|
|
From category: Components-Libraries |
| a Delphi Component that you can use to display an OSD into your applications.... |
|
|
From category: Components-Libraries |
| Get all embed image information including EXIF tags, TIFF tags and GPS tags... |
|
|
From category: Components-Libraries |
| An inherited toolbar which can be assigned a RichTextBox that allows simple editing of the rich text.... |
|
|
From category: SDK-DDK |
| Easily integrates PDF creation support in your applications... |
|
|
From category: Components-Libraries |
| Introduces an advanced file / folder explorer and a drive explorer controls... |
|
|
From category: Other-Programming-Files |
| This software\'s task is to generate native makefiles, so that people can keep using their favorite tools.... |
Leave a comment