Java Excel Spreadsheets Processing API
Build Java application with the ability to create, manipulate, convert, protect or print spreadsheets without relying on Microsoft Excel.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, manipulate, convert & print spreadsheets in their own applications, without needing Microsoft Excel application.
Aspose.Cells for Java is a mature and feature-rich library, offering many functions that are way beyond the simple data export 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 using formula calculation engine, stream Excel data & save the result in various formats.
At A Glance
A generic overview.
- Chart to Image
- Worksheet to Image
- Spreadsheet to PDF
- Apply Formatting
- Create Charts
- Apply Formulas
- Smart Markers
- Supports JSP Web Application
- Load Excel Files
- Save Excel Documents
- Provides Editing Capabilities
- Compatible with Modern Browsers
The library can be used in any Java-based applications developed on Windows Unix/Linux and Mac platforms.
- JSP/JSF Application
- Desktop Application
Supported File Formats
Aspose.Cells for Java supports the popular spreadsheet formats, commonly used images, fixed-layout and more 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
- SXC, FODS
- Fixed Layout: PDF, PDF/A, XPS
- Data Interchange: DIF
- Images: JPEG, PNG, BMP, SVG, TIFF, GIF, EMF
Advanced Java Excel Library Supports
Import & export data from Array, ArrayList & Recordset
Chart creation & manipulation through the APIs
Import formulas from a designer spreadsheet
Create, manipulate Named Ranges
Print spreadsheets to a physical printer
Populate worksheets through Smart Markers
Create & manipulate comments
Set & calculate Excel & custom formulas
Create & manipulate conditional formatting rules
Create & manipulate named ranges
Create, manipulate & refresh Pivot Tables & Pivot Charts
Rendering of charts & worksheets
Read & write large spreadsheets in the light-weight mode
Re-sample images in Excel-to-PDF conversion
Modify VBA code or Macros in the template file
Save Excel Files to Different Formats
Excel API provides the ability to convert spreadsheets to PDF, XPS, HTML and more 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 the spreadsheet in different formats - Java
// load file to be converted Workbook workbook = new Workbook(dir + "template.xls"); // convert xls to PDF, XPS and HTML workbook.save(dir + "output.pdf", SaveFormat.PDF); workbook.save(dir + "output.xps", SaveFormat.XPS); workbook.save(dir + "output.html", SaveFormat.HTML);
Format Worksheets to Most Granular Level
Library provides spreadsheets styling including but not limited to worksheet formatting at row, column, and cell level, adding conditional formatting rules, defining number formats and setting fonts with attributes. Similarly, API supports creating and manipulating all types of standard and custom charts as well as different types of drawing objects, such as comments, pictures, OLE objects, shapes and controls to the cells.
Convert Charts & Sheets 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 the 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 Excel 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 Charts & Pivot Tables
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. API 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, the library offers Smart Markers which is a great feature to populate worksheets based on some data sources and to create visually effective reports.
Web-based Visual Control for Spreadsheets
Aspose.Cells for Java also provide a UI control that can 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 spreadsheet 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: