Spire.XLS for Java

Spire.XLS for Java

 

Standalone Java API to process Excel worksheets

 

Spire.XLS for Java is a professional Java Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets without using Microsoft Office or Microsoft Excel.

 

Spire.XLS for Java supports both for the old Excel 97-2003 format (.xls) and for the new Excel 2007, Excel 2010, Excel 2013 and Excel 2016 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format. Spire.XLS for Java offers a wide range of features of operating Excel worksheets on Java applications, such as create, read, edit, convert and print Excel worksheets, find and replace data, create charts, create auto filters, read and write hyperlinks, merge/unmerge cells and files, group/ungroup rows and columns, freeze/unfreeze Panes, encrypt/decrypt Excel workbooks etc.

 

 

Commercial Edition

Compared with Free Spire.XLS for Java, the commercial editon of Spire.XLS for Java has no limitation on the number of worksheets and rows. It is more comprehensive in processing Excel files.

 

Main Functions

 

Only Spire.XLS for Java, No Microsoft Office

Spire.XLS for Java is a totally independent Excel library, Microsoft Office or Microsoft Excel is not required in order to use Spire.XLS for Java.

 

High Quality File Conversion

Spire.XLS for Java allows converting files from Excel to PDF, Excel to HTML, Excel to CSV, Excel to Text, Excel to Image, Excel to XML, Excel to SVG, Excel to PostScript and Excel to XPS. And on the other hand, most of popular files can be transferred to Excel back.

 

Easy Integration

Spire.XLS for Java can be easily integrated into Java applications.

 

Support a Rich Set of Excel Elements

Spire.XLS for Java supports a rich set of Excel elements, including comment, pivot table, charts, shapes, tables, images, hyperlinks, reports, text/image watermark, Excel formula and many more. Spire.XLS for Java also embeds many flexible options for displaying worksheets, such as page breaks, zoom-setting, freeze panes, headers/footers, print excel files, print paper size and print area etc.

 

Features

 

File Format Supports

Spire.XLS for Java supports lots of file formats.

• Spire.XLS for Java offers support both for the old Excel 97-2003 format (.xls) and for the new Excel 2007,Excel 2010, Excel 2013 and Excel 2016 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format.
• Load and save documents in the tab delimited file format.
• Comprehensive support of the CSV format to interact with a variety of applications.
• Easily extract text by saving in plain text format.

 

Conversion

Spire.XLS for Java has powerful conversion ability and it enables converting Excel files to most common and popular formats.

• Excel to HTML/XML/CSV
• XML/CSV to Excel
• Excel to Image
• Excel to Text
• Excel to PDF
• Excel to XPS
• Excel to SVG

 

Contents Features

Spire.XLS for Java offers a wide range of features and the main features are listed as below:

• Create and Edit Excel
• Find and Replace Data
• Print excel files
• Import/Export data from a DataTable, DataView, Array, DataGrid etc.
• Save Excel to file/Stream or as web response
• Create charts
• Read and write hyperlinks
• Create auto filters
• Implement Data Sorting
• Implement Data Validations
• Merge/Unmerge Cells and files
• Group/UnGroup Rows and Columns
• Insert/Delete or Hide Rows, Columns and Sheets
• Calculate Complex Excel Formula
• Freeze/Unfreeze Panes
• Insert Hyperlinks to link data
• Protect/Unprotect Worksheets
• Create Pivot Tables
• Encrypt/Decrypt Files
• Load/Save Excel VBA
• Merge data into Excel with MarkerDesigner

 

Formatting Features

Spire.XLS for Java provides detailed programmatic access to formatting properties of all spreadsheet elements.

• Apply all characters formatting in the cells including fonts, colors, effects, fill and shading
• Apply all the Number Format Settings (supported in MS Excel) for the cells.
• Set all types of Text Alignment settings.
• Apply different kinds of Font Settings for the cells.
• Apply different Colors to Cells, Fonts, Gridlines, Graphic objects etc.
• Apply different Rich Text formatting in a single cell.
• Apply different Border Settings on cells.
• Apply different Background Patterns on cells.
• Apply gradient Background Patterns on cells.
• Apply Format Settings on a Worksheet, Row, Column or a range of cells etc.

 

Page Setup Features

Spire.XLS for Java enables developers/programmers to set PageSetup options.

• Adjust your page orientation, scaling, paper size.
• Specify your margins and page centering.
• Create or edit your header and/or footer with image.
• Set print area, print titles, or turn on gridlines etc.
• Managing Page Breaks