Home > Excel Business Solutions > Excel Productivity > Programming Components > Java Library Share

Java Library

Excel java library for programming components


Excel Java Library

Rate this solution:
(3/5 from 2 votes)
Java Library screenshot
The Java Library for Excel (Jxcell) is a high performance library of components for Java development environments to create, manipulate and print Excel workbooks and worksheets.

The Java Library for Excel provides the tools needed to store, analyze, manipulate and present any data in Excel. The library uses the Excel document format to support formulas, images, lines and charts.

Key features of the Java Library for Excel include:

  • Unicode support.
  • CSV files (delimited with comma, tab, semicolon or any other separator).
  • Excel 2007 OpenXML support.
  • Open encrypted Excel files and save encrypted Excel files.
  • Multiple worksheets per file.
  • Template support (create new workbooks using an existing workbook as a template).
  • Various cell data types (numbers, strings, dates, floating point etc).
  • Custom number formatting.
  • Merged regions.
  • Cell styles (alignment, indentation, rotation, borders, shading, protection, text wrapping and shrinking etc).
  • Font formatting (size, color, font type, italic and strikeout properties, different levels of boldness, underlining, subscript and superscript).
  • Formatting options (font, color, content format, pattern, border line, border color, alignment).
  • Conditional Formats (apply cell formats when the value of a cell or formula meets a predetermined set of conditions).
  • Text orientation and applying different formatting to parts of a cell.
  • Data validation support.
  • Copy/Move/Delete  - Cells can be copied, moved and deleted with the same behavior as in Excel. Rows and columns can be copied and moved as well. Copy/move between sheets is supported and entire sheets can be copied.
  • Row height and column width.
  • Formula support (absolute and relative references, names, 3D cell references and more than 260 supported functions).
  • Named ranges (names can be used and used to access ranges).
  • Calculation engine (cells and whole worksheets can be calculated).
  • Formulas with references to external workbooks are supported.
  • Charts (supports all standard chart types like Column, Bar, Line, Pie, Scatter etc).
  • Customize charts (stack chart, percentage pie, chart data labels, chart formats set etc).
  • Pictures support (BMP, JPG, GIF, PNG, WMF).
  • Hyperlink support (cell links, urls, email links, file links).
  • Export data to Excel files, CSV text files and HTML files.
  • Convert Excel to PDF file.
  • Access all printing options (select paper size, set margins, set header and footer, including formatting codes. Define printing areas, set page breaks, preserve print area and summaries).
  • Spreadsheet designer mode.
  • View, create, modify, print spreadsheet in Swing GUI Component.
  • Supports VBA and macros (Copied from master template).

Try It  Get It

(Pricing is available on the next page)
(Updated on 2023-09-01)

Related Excel Solutions for Java Library

Remote Viewing ComponentProgramming Components  OCX Office Viewer ComponentProgramming Components  .NET ComponentsProgramming Components  C++ LibraryProgramming Components

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.