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