Apache POI has a more extensive set of documentation and examples available than JXL.Īdditionally, POI contains not just the main "usermodel" API, but also an event-based API if all you want to do is read the spreadsheet content.JXL doesn't support Chart creation or manipulation that support isn't there yet in Apache POI, but an API is slowly starting to form.JXL doesn't support Split Panes Apache POI does.
#GET NUMBER OF ROWS IN A EXCEL JAVA JXL PLUS#
Apache POI supports all of that plus Repeating Rows and Columns.
JXL supports most Page Setup settings such as Landscape/Portrait, Margins, Paper size, and Zoom. JXL doesn't support drawing shapes Apache POI does. JXL only supports certain text rotations: horizontal/vertical, +/- 45 degrees, and stacked Apache POI supports any integer number of degrees plus stacked. POI is called Poor Obfuscation Implementation, literally translated as 'Poor Fuzzy. poi can operate Excel 95 and later versions, and can operate excel with suffixes of. jxl can only operate Excel 95, 97, 2000, that is, excel suffixed with. different formatting within a text string Apache POI does support it. There are two mainstream toolkits for operating Excel in JAVA: jxl and poi. JXL doesn't support rich text formatting, i.e. JXL doesn't support Conditional Formatting, Apache POI does, although this is not that significant, because you can conditionally format cells with your own code. Additionally, the Java portion of the JXL API was last updated in 2009 (3 years, 4 months ago as I write this), although it looks like there is a C# API. Apache POI supports both with a common design. 
Perhaps the most significant difference is that Java JXL does not support the Excel 2007+ ".xlsx" format it only supports the old BIFF (binary) ".xls" format. Both attempt to keep existing objects in spreadsheets they read in intact as far as possible. Read/Write existing and new spreadsheets. (types and colors), font support (font names, colors, size, bold, Cell styling: alignment, backgrounds (colors and patterns), borders. At first I used JXL, but now I use Apache POI.įirst, here are the things where both APIs have the same end functionality: I have used both JXL (now "JExcel") and Apache POI.
0 kommentar(er)
