Java Excel Spreadsheets API
Get full control of spreadsheets manipulation without any Microsoft Excel dependencies within Java-based applications.Download Free Trial
Aspose.Cells for Java
Aspose.Cells for Java is an award-winning Excel Spreadsheet Processing API that allows the developers to embed the ability to read, write and manipulate spreadsheets in their own Java applications without needing to rely on Microsoft Excel.
Aspose.Cells for Java is a mature, scalable and feature-rich API, offering many functions that are way beyond the simple data exporting capabilities of other components available on the market. API provides the capabilities to export data, format spreadsheets to the most granular level, import & export images, create charts & Pivot Tables, apply & calculate complex formulas, stream Excel data & save the result in various formats.
At A Glance
An overview of Aspose.Cells for Java capabilities.
- Chart to Image
- Worksheet to Image
- Spreadsheet to PDF
- Apply Formatting
- Create Charts
- Apply Formulas
- Smart Markers
- Supports JSP Web Application
- Supports Loading Excel Files
- Supports Saving Excel Files
- Porvides Editing Capabilities
- Compatible with Modern Browsers
Aspose.Cells for Java fully supports Java based applications developed in Windows Unix/Linux and Mac platforms.
- JSP/JSF Application
- Desktop Application
Supported File Formats
Aspose.Cells for Java supports the popular spreadsheet formats along with most commonly used image & fixed-layout formats.
- Microsoft Excel: XLS, XLT, XLSX, XLSB, XLTX, XLTM, XLSM, XML
- OpenOffice: ODS
- Text: CSV, TSV
- Web: HTML, MHTML
- Numbers: Apple's iWork office suite Numbers app documents
- Fixed Layout: PDF, PDF/A, XPS
- Data Interchange: DIF
- Images: JPEG, PNG, BMP, SVG, TIFF, GIF, EMF
Advanced Java Excel API Features
Ability to save & load Excel files to and from streams
Send output to client browser
Load & save ODS format files
Import & export data from Array, ArrayList & Recordset
Import images & charts
Create images & charts through the product API
Import formulas from a designer spreadsheet
Configure page setup
Print spreadsheets to physical printer
Export custom document properties to PDF File
Get XML path from List Object/Table
Truncate long sheet name at run-time
Replace invalid characters in sheet name at run-time
Retrieve query table result range
Applying text alignment to partial text inside the TextBox
Content Copying for accessibility
Disable Pivot Table Ribbon
Pasting rows/columns with advanced paste option
Populate worksheets through Smart Markers
Create & manipulate comments
Set auto-filters & page breaks
Set & calculate complex formulas
Create & manipulate conditional formatting rules
Set protection options introduced in Microsoft Excel XP
Create & manipulate named ranges
Create, manipulate & refresh Pivot Tables
Save as HTML files or streams
Create & render sparklines
Create, manipulate & render charts
Formula calculation engine
Export worksheets as SVG files
Read & write large spreadsheets in light-weight mode
Re-sample images in Excel-to-PDF conversion
Trace Precedents & Dependents
Create & manipulate Scenarios
Modify VBA code or Macros in the template file
Save ODS files in ODF 1.1 and 1.2 specifications
Optimize memory usage while working with large files
Convert Excel Files to Multiple Formats
The Excel Java API provides the ability to convert Excel spreadsheets to PDF, XPS & HTML formats while maintaining the highest visual fidelity. The conversion process is simple yet reliable, thus making Aspose.Cells a perfect choice for the organizations which require to exchange documents in industry standard formats.
Save spreadsheet in different formats - Java
// load file to be converted Workbook workbook = new Workbook(dir + "template.xls"); // save in different formats workbook.save(dir + "output.pdf", SaveFormat.PDF); workbook.save(dir + "output.xps", SaveFormat.XPS); workbook.save(dir + "output.html", SaveFormat.HTML);
Styling excel spreadsheets
Aspose.Cells for Java gives you complete freedom and flexibility to furnish your spreadsheets with all kinds of visual effects. The Java Spreadsheet API allows you to apply formatting to a worksheet, row, column or cell, set fonts with attributes, define cell styling & number formats, add Rich Text and define conditional formatting rules.
Similarly, charts and graphics are visually appealing and can give your spreadsheet a professional look. Aspose.Cells for Java provides a comprehensive set of APIs for creating and manipulating all types of standard and custom chart. Moreover, you may add different types of drawing objects, such as comments, pictures, OLE objects, shapes and controls to the cells.
Excel API Formula Calculation Engine
Aspose.Cells for Java is equipped with a powerful Formula Calculation Engine that supports almost all of the standard and advanced Microsoft Excel formulas and functions. You can read, set and calculate the results of built-in or add-in type, array and R1C1 reference style formulas.
Convert Excel Objects to Image & PDF Formats
Aspose.Cells for Java offers some distinctive features such as converting charts to images & PDF, converting worksheets to images, printing worksheets and converting spreadsheets to PDF file format. The conversion process is greatly flexible thus allowing you to choose a number of options for the conversion, such as re-sampling of images while converting spreadsheets to PDF or controlling the resultant image dimensions when rendering worksheets & charts to images.
Render Excel chart as image & PDF - Java
// load spreadsheet containing the chart Workbook book = new Workbook(dir + "template.xlsx"); // get the chart present in first worksheet Chart chart = book.getWorksheets().get(0).getCharts().get(0); // render chart as PNG chart.toImage(dir + "output.png", ImageFormat.getPng()); // render chart as PDF chart.toPdf(dir + "output.pdf");
Manipulate Rows & Columns
Aspose.Cells for Java allows you to manipulate rows and columns in many different ways. You can easily adjust row height & column width, auto size the width/height of cells according to contents, insert & delete, hide & un-hide as well as group & un-group rows and columns.
Summarize Data with Ease
It can be difficult to get summarized information with very large spreadsheets. A Pivot Table can help you quickly summarize the flat data and to get the desired information according to your needs. Aspose.Cells for Java allows you to dynamically create Pivot Tables and Pivot Charts. You can also dynamically change the source data of a Pivot Table and refresh it. Moreover, Aspose.Cells for Java offers Smart Markers which is a great feature to populate worksheets based on some data source and to create visually effective reports.
Visual Control for Spreadsheet Manipulation
Aspose.Cells for Java also provide a UI control which can be be embedded in JSP web applications, and is compatible with all modern web browsers like Chrome, FireFox, Internet Explorer and Opera. End user can use it to load, edit and save Excel files from your web application's front-end.
What People Are Saying
Don't just take our word for it. See what users have to say about Aspose.Cells APIs.
We would recommend the use of Aspose.cells for Java because it is easy to implement and the API is simple to understand and very fluent.Pierre-Eric Oudin | Advizeo by Setec, France
Our overall experience with Aspose products was very positive. This component increased business value to Xpand IT product - Xporter Plugin for JIRA, allowing us to develop a reference solution for data export.Paulo Lopes | Xpand IT, UK
Aspose.Cells offers individual Excel APIs for other popular development environments as listed below: