Here is a brief summary of Spire.XLS for Java features.

File Format Supports

• 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, Excel 2016 and Excel 2019 (.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

• 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
• 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
• Add digital signature

Formatting Features

• 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

• 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