Spire.XLS for Java 2.2.0 is released

We're pleased to announce the release of Spire.XLS for Java 2.2.0. This Excel API supports to create, manage, manipulate, convert and print Excel worksheets without using Microsoft Office or Microsoft Excel. Multiple features are supported, see the content below for details.

File Format Supports:

• Excel 97-2003 format (.xls)
• Excel 2007
• Excel 2010
• Excel 2013 and Excel 2016 (.xlsx, .xlsb, .xlsm)
• Open Office(.ods) format

File Conversion:

• 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:

• Create and Edit Excel, charts, auto filters, Pivot Tables
• 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 Read and write hyperlinks
• Implement Data Sorting, Data Validations
• Merge/Unmerge Cells and files
• Group/UnGroup Rows and Columns
• Insert/Delete or Hide Rows, Columns and Sheets
• Calculate Complex Excel Formula
• Insert Hyperlinks to link data
• Protect/Unprotect Worksheets
• Encrypt/Decrypt Files

Formatting Features:

• Apply all characters formatting in the cells including fonts, colors, effects, fill and shading
• Set all types of Text Alignment settings.
• Apply different Colors to Cells, Fonts, Gridlines, Graphic objects etc.

Page Setup Features:

• 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