Igor has posted 12 posts at DZone. View Full User Profile

JExcel 1.3 is Out

11.26.2008
| 19870 views |
  • submit to reddit

TeamDev is pleased to announce a new release of JExcel, library that allows Java developers to integrate their Java applications with Microsoft Office Excel.

With JExcel library, you can read, write, create, modify or display workbooks, spreadsheets, worksheets or even a specific range of cells in а Java application. You can also modify cell values, cell number formats, formulas, customize cell appearance, including text font, cell background and border, text alignment and orientation, etc. Printing Excel documents is also available.

In other words with JExcel you have full control over xls and xlsx in Java.

JExcel 1.3 introduces new API features related to operations with ranges, worksheets and workbooks. Also, with this release, we bundle JExcel with the latest versions of underlying technologies such as JNIWrapper and ComfyJ. The new version of ComfyJ allows to improve considerably JExcel performance on bulk operations. For the full list of changes, check out the What's New page.

Try online JExcel Demo or download JExcel to evaluate it.

For any help or feedback related to the use of JExcel 1.3, please use the support forum or e-mail us directly.

0
Average: 5 (1 vote)
Published at DZone with permission of its author, Igor Shvydkoy.

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)

Comments

Boaz Lev replied on Wed, 2008/11/26 - 6:33am

Anyone aware of an open-source with similar functionality? (other than Apache POI)

HC CHAU replied on Wed, 2008/11/26 - 10:04am in response to: Boaz Lev

JXL is one. I was using POI but I *feel* that JXL is better in that regard. Basically I built 2 different apps, one with POI and 1 with JXL. The JXL app performs better, but then again, the POI app was running on an older version of Java and WebSphere and the JXL app is running on JDK 1.5 and JBoss.

But JXL has nowhere near the amount of support that POI has.

http://jexcelapi.sourceforge.net/

Igor Shvydkoy replied on Wed, 2008/11/26 - 11:48am

JExcel is actually more powerful with more functionality. It wraps ALL Excel interfaces, writes and saves files smoothly, because all operations are performed by Excel. Besides JExcel is not dependant on some pecularities of XLS format and on reverse engineering.

HC CHAU replied on Wed, 2008/11/26 - 1:16pm

@Igor

Would you know of a link or document or something regarding JExcel's performance metrics. One issue I have with both POI and JXl is that for large spreadsheets (>100K excel cells), the memory needed shoots up a lot and tends the server to crash if such a volume happens.

Usually we don't see files that big, but every now and then, one shows up and takes everything down with it.

Igor Shvydkoy replied on Thu, 2008/11/27 - 11:49am in response to: HC CHAU

POI and JXL handle and parse Excel files by themselves, that’s why using these solutions for large files lead to heavy loads on memory and may result in crashes.

JExcel doesn’t handle the files by itself. It uses Excel installed on a PC to handle the file. All parsing and handling of files is performed by Excel. Therefore the memory requirements for JExcel are almost the same as they are for Excel. We haven’t measured JExcel performance in exact figures yet, but we should definitely make it and compare with other solutions.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.