Why JExcel
- Rich and easy-to-use API.
- Great documentation with many examples.
- Makes all Excel functions available in your Java application.
- Great support. Responsive support team will answer to your request within 24 hours. To get help you can choose different support channels: email, support site and forum or premium support service. You are welcome to contact us with initial questions at evaluation support address. Learn more.
Need to incorporate a spreadsheet into Java application?
Easily embed a spreadsheet
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.
- // 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);
Populate your spreadsheet with data
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);
Add formulas to your spreadsheet
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)");
Enjoy the spreadsheet in your Java app
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 unmergecells andranges. 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
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.
Examples of Apps Our Customers Build
- Applications for reading data from Excel documents, creating JExcel documents, and writing data from Java to Excel documents. With JExcel API you can read, modify and write data in Excel documents from your Java applications.
- Embedding Excel documents directly to Java applications with help of JWorkbook component form JExcel library.
Getting Help
Documentation
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 |
Standard SupportProvided for one year with 25% discount for renewal |
Premium SupportContract-based time and materials service |
|---|---|---|
| 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 | Request Premium |
If you have questions, not covered by the documentation, please email us at sales@teamdev.com.
Licensing and Pricing
Licence use is governed by the product licence agreement
- Perpetual licence
- Free distribution within your application
- 1 year Support and updates
- Support renewal with 25% discount
- 15% discount on TeamDev products
Company-wide $7,499
- Unlimited developers
- Unlimited projects
- 200 hours of support for 1 year
Source Code For 1 Developer
is also available for purchase
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.8-full.jar library instead of jexcel-1.8.jar to classpath of your Java application. This full version contains all Excel wrappers.
Take a look at the licence installation instruction.
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.
Please take a look at the Product Licence Agreement.
You only need to purchase 2 licences. We licence our library by the number of people who write code using our library.
This is possible with the Per Developer licence.
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.
Evaluate
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.