JExcel 1.3 is Out
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.
- Login or register to post comments
- 13964 reads
- Printer-friendly version
(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
HC CHAU replied on Wed, 2008/11/26 - 10:04am
in response to: boazlev
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
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: hchaudh1
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.