JExcelApi is a java library which provides the ability to read, write, and modify Microsoft Excel spreadsheets. This project mirrors the files on http://www.jexcelapi.org, which has been known to go down on occasion.
great! would you do some work on Microsoft Excel 2007 format 'xlsx' ?
I am using it and if i have more then 256 columns to write to xls or xlsx then all data above 256th column is not being written. In office 2007 also i am getting only 256 cloumns though it supports more then 256 columns.
Easy and powerful. A great library, the good solution for generate excel file on Unix
- Renamed the common packages to be jxl.common, in order to avoid naming clashes - Incorporated Matt England's simple check in order to detect cyclic block chains in the compound file format - Included function names in Dutch in the resource bundle - Added improved error handling in the event a named range could not be found for formula parsing within cell validations. Instead of an assertion and stopping, it continues with a warning - When retrieving names (eg. from a formula) need to account for the fact that names which are local to a particular sheet are still added to the global names from a name index perspective - Added support for checkboxes. Handled the case where the checkbox text was empty, so that it didn't need to read in the continue records after the TXO record Introduced the following of Andre's changes into Workbooksettings: - Flag to indicate whether all external data and pivot stuff should refreshed - Flag to indicate whether the file is a template or not (Usually with .xlt) - Flag to indicate whether the file has been written by excel 2000. - The WINDOWPROTECT record stores an option from the Protect Workbook - The HIDEOBJ record stores options selected in the Options dialog, View tab. - Supported the following records when reading the workbook: REFRESHALL; TEMPLATE; EXCEL9FILE; WINDOWPROTECT; HIDEOBJ; WRITEACCESS
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?