TeamDev Ltd. Home Page

JExcel library provides an effective way to solve various tasks related to tabular format reports processing using integration and full control over Microsoft Excel in Java Swing applications.


Manage Workbooks & Properties

Manage Workbooks & Properties

You’ll be able to perform  any operation on Excel workbooks—create or open, save, modify (not only the workbook data, but also name, title, author, file path, password protection, window caption, size, zoom, state and many other options).

Work with Cells & Ranges

Reference cells by coordinates, address or name, set and get values of different types, convert cells into ranges and vice versa, customize cell appearance, reference range, find values in ranges, obtain ranges intersection, merge/unmerge cells of a range, etc.

Manage Worksheets

Obtain worksheet by its name or index, obtain all worksheets in a workbook, add a new worksheet and assign the name of the new worksheet, move a worksheet to a specified position and remove a worksheet from a workbook etc.

Customize Cells & Ranges

  • Change a number format
  • Customize text alignment and orientation
  • Font customization—name, size, general styles, underline style, color, alignment style
  • Change background pattern and color in cells
  • Border appearance customization: border color, line style and weight.
Microsoft Excel 2000 or later must be installed on developer and target environment for correct work of JExcel.

JExcel Learn how you can benefit from JExcel and save your time and money!

Buy online in few steps
Questions by email
Listen to and Handle Excel Events

Listen to and Handle Excel Events

With JExcel Workbook and Worksheet classes, you can add listeners to the events generated by a workbook or worksheet as well as process them by handlers to affect respectively the behavior of a workbook or worksheet.

Application Events

Microsoft Excel sends notifications about the following application events: a new workbook is created, a workbook is opened.

Workbook Events

You can listen to workbook activation/deactivation, new worksheet adding to a workbook, workbook saving/closing events.

Worksheet Events

You can handle various worksheet events: activation/deactivation, changing values and selections, double-click and right-click events.



Embed a Workbook into Java

Using the JWorkbook class as an OLE container, you can add an Excel workbook into a Java Swing application just like an ordinary Swing component and receive functionality for working with its content: open and save an embedded workbook, print it by displaying the Print dialog or directly, display a workbook in a static mode (read-only) or in a normal mode, listen to JWorkbook events.

Ability to work with Native Peers and Thread Issues

Using the developer-friendly JExcel API, you can get direct access to any COM interface of the MS Excel COM API to implement functionality that is not yet available in the JExcel API. JExcel provides peers for the following classes: Application, Workbook, Worksheet, Range, and Cell.

High level mergeWorkbook() method

It allows copying all worksheets from the specified workbook into another workbook instance. Using this method you can copy worksheets only but you’ll be unable to do the same with VBA scripts.