Java Excel Spreadsheets Processing API

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.

// 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.

// 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.