Easily display, create, print, read, write or modify your Excel workbooks (both *.xls and *.xlsx) using a comprehensive Java Excel API.

No specific knowledge of Microsoft Office programming required.

Why JExcel

Need to incorporate a spreadsheet into Java application?

  • // Simple JWorkbook-based application
  • JFrame frame = new JFrame("Test application");
  • frame.setDefaultCloseOperation (
    • javax.swing.WindowConstants.EXIT_ON_CLOSE
    );
  • Container cp = frame.getContentPane();
  • cp.setLayout( new BorderLayout());
  • JWorkbook workbook = new JWorkbook();
  • cp.add(workbook);
  • frame.setBounds(100, 100, 500, 500 );
  • frame.setVisible(true);

JExcel gives all the power of Microsoft Excel: workbooks, formulas, full spreadsheet control. Easy to mix Java logic and Excel capabilities.

Do you want to embed the spreadsheet? Just add a few simple lines of code.

Now the spreadsheet is incorporated in the application. Of course, you want to manipulate it.

Fill cells with scientific data, statistics, measurement results, or any other data. As in the previous example, it takes just a few lines of code.

  • // Gets reference to active worksheet
  • Worksheet sheet=workbook.getActiveWorksheet();
  • // Creates 2d double array and fills the range
  • final int ARRAY_SIZE = 5;
  • double dcount = 0;
  • final double double_array[][] =
  • new double[ARRAY_SIZE][ARRAY_SIZE] ;
  • for( int i = 0; i < ARRAY_SIZE; i++) {
    • for (int j = 0; j < ARRAY_SIZE ; j++) {
      • double_array[i][j] = dcount++;
    • }
  • }
  • sheet.fillWithArray("A1:E5", double_array);

Likewise, you can easily set up formulas within the sheet. Here, we’ve put in a label and added a sum for a row.

  • // Adds comment and SUM formula
  • Cell cell = sheet.getCell("D7");
  • cell.setValue("Result:");
  • Cell sumcell = sheet.getCell("E7");
  • sumcell.setValue("=SUM(E1:E6)");

As you can see, with a few simple lines, you can easily integrate Excel into your Java applications.

  • JPanel panel = new JPanel();
  • JWorkbook workbook = new JWorkbook();
  • panel.setLayout(new BorderLayout());
  • panel.add(workbook);
  • Worksheet sheet = workbook.getActiveWorksheet();
  • sheet.fillWithArray("A1:D6", pricesArray);

Features

Embed a workbook in Java Swing

Integrates like an ordinary Swing component. Open, save and print workbooks. Display a workbook in read-only or editable mode

Manage workbooks

Create new workbooks. Open existing workbooks. Save in any formats supported by Excel. Copy all worksheets from one workbook into another. Modify properties such as name, title, author, etc. Control password protection. Control window properties, such as caption, size, zoom and window state.

Manipulate cells and ranges

Get and set cell values, by coordinates, address or name. Manipulate ranges. Merge and unmerge cells and ranges. Customize cell appearance, including format, font, alignment, color and pattern.

Work with peers and threads

Directly interact with Microsoft Excel COM API from Java, using the included ComfyJ run-time for Application, Workbook, Worksheet, Range, and Cell. Control threading model.

Process application, workbook, and workbook events

Add Java listeners for application, workbook, and worksheet events. Run special code when workbooks are created, opened, saved, closed or previewed. Process worksheet events: activation and deactivation, changing values and selections, double-click and right-click events.

Manage worksheets

Access any worksheet within a workbook. Add, move or remove worksheets. Control worksheet properties.

Try the Demo

Run the demo jexceldemo.jnlp

MS Windows Runs on Microsoft Windows XP or later with:

  • Microsoft Excel 2000 or later;
  • JDK (JRE): 1.4.0 or later. Version 1.4.2 recommended;
  • Java™ WebStart. Version 1.4.2 recommended.

The JExcel Demo is a Windows program and cannot run under another operating system.

To see the Demo, you can do one of the following:

  • Download it and run on Microsoft Windows computer
  • Open this page directly from Windows.

Examples of Apps Our Customers Build

Getting Help

Contact Support

During evaluation period please use the email address, provided to you in the evaluation email.

If you have an active support subscription, please use the email address, provided to you in the email confirming the licence purchase.

Ask a Question

You can ask a question on our product forum. In order to do it, you will need a Google ID.

links.teamdev.com/jexcel-forum

Send email: jexcel-forum@teamdev.com
Your message will be automatically posted on the web.

Evaluation SupportProvided for 30 days

Support Evaluation

Standard SupportProvided for one year with 25% discount for renewal

Support Standard

Premium SupportContract-based time and materials service

Support Premium
Help with the product use Help with the product use Help with the product use
Response within one business day Response within one business day Response within one business day
Provided by email Provided by email Phone, chat and remote desktop
Product updates Product updates
Feature development
Priority issue resolution
Evaluate for Free Request Renewal Contact Us
JExcel is very easy to use and meets our expectations. Johannes M. Hug, Swiss Reinsurance Company
Product is extremely easy to use and set up — for me its a first class product … its ease of use is its main feature. Yashir, IDI Insurance Company Ltd.

Licensing and Pricing

Licence use is governed by the Product Licence Agreement

  • Perpetual Licence Perpetual licence
  • Free Distribution Free distribution within your application
  • Support Updates 1 year Support and updates
  • 25% Discount Support renewal with 25% discount
  • 15% Discount 15% discount on TeamDev products

Per Developer $799

  • Developer 1 developer
  • Unlimited Projects Unlimited projects
  • Support 55 hours of support for 1 year
Buy Now

Project $2,299

  • Developers Unlimited developers
  • Project 1 project
  • Support 75 hours of support for 1 year
Contact Us

Company-wide $7,499

  • Developers Unlimited developers
  • Unlimited Projects Unlimited projects
  • Support 200 hours of support for 1 year
Contact Us

Source Code For 1 Developer

$5,999 1 Per Developer licence included
Developers Licence for more developers
is also available for purchase

Get Licences via Resellers

Become a Reseller

Frequently Asked Questions

Technical Questions

JExcel requires MS Excel to be installed in a system.

All versions starting from Excel 2000.

All versions starting from Windows XP.

Yes, JExcel provides corresponding methods that allow bulk writing data from Java to Excel documents and bulk reading data from Excel to Java.

You should include jexcel-1.7-full.jar library instead of jexcel-1.7.jar to classpath of your Java application. This full version contains all Excel wrappers.

Licensing Questions

Our licensing is based on versions of JExcel. Having purchased the licence for our product you get the right to use the current major version of the product.

Major and minor version upgrades issued during your active Standard Support subscription period are free of charge. Upon expiration of the Standard Support subscription you can renew it with a 25% discount from the actual licence price.

You only need to purchase 2 licences. We licence our library by the number of people who write code using our library.

You can distribute unlimited number of copies of your product with our library enclosed.

You may want to purchase a Project licence, which is cost-effective in case there are 3 and more developers on the team. The Project licence is bound to a single project you do, but it allows any number of developers in your company to work with our library.

Project Licence is bound to your project via a fully-qualified class name. A fully-qualified name for a class is the package name followed by the class name, separated by a period (.). For example: com.mycompany.myproduct.MyClass

This can be any class of your application. The only requirement is that it should be included into your Java application class path.

When we say “project” we have in mind one product of your company including your future product versions or potential derivative works based on your product.

The Project licence is tied to one project only.

The best solution would be to purchase the Company–wide licence, which covers any number developers and projects in one company.

Upon the licence purchase you will receive an archive with two types of licence files: development and runtime. Development licences are intended to be used in the development process. Runtime licences are to be used for distribution of your software with JExcel enclosed.

Yes, you can purchase JExcel Source Code Licence; it is provided on a per developer basis. Please contact our sales team if you are interested in this option.

If you are doing an open source or academic project, you can apply to get a free licence. Please submit a request via Open Source or Academic tab on the evaluation form.

Thank you!

Start your free trial in few simple steps

1
Email

Check Your Email

Links to download your evaluation licence and distribution archive will arrive at your inbox in a few minutes.

If the message gets lost in your mailbox, try searching for an email from JExcel Evaluation Support with “Your Free 30 Days Trial” subject.

2
Licence

Install the Licence

To start using JExcel

  • download your evaluation licence,
  • download and extract the distribution archive,
  • include all the JAR files from the lib directory and evaluation licence licence.jar in your application class path.
3
Start

Get Started

Use the Programmer’s Guide to get JExcel up and running in no time:

Run your first program

See Support Documentation for more information on using JExcel.

Examples

Check out the ready-made examples for instructions and ideas on what you can do with your newly gotten JExcel.

Evaluate

Commercial Open source Academic

With this licence you will be able to evaluate our product for 30 days.
The evaluation licence will not work after this time, so you will need to purchase the licence.

With this licence you will be able to evaluate our product for 30 days.
The evaluation licence will not work after this time. If you are doing an open source project, you can request a permanent licence via the link provided in the email you will receive.

With this licence you will be able to evaluate our product for 30 days.
The evaluation licence will not work after this time. You can request a licence for duration of your academic project via the link provided in the email you will receive.

You should have an existing open source project which has commits and some life period of the project.

We can provide licences only for projects distributed under non-viral licence (LGPL, Apache, etc.). Our library is proprietary and we will not be able to disclose its code.