Java Excel Spreadsheets API

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.

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

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