Currently, I am doing a research on various solutions available for java & excel xls integration to be used for our next generation sales quotation tools. I found this article already did some work and compile a list of solution available below:
| Library / package | License | Description |
|---|---|---|
| Actuate Spreadsheet Engine | Commercial, 30-day trial version available | Write Excel (XLS) files. |
| ExcelAccessor | ? | Read and write Excel (XLS) files. |
| ExcelReader | ? | JavaWorld article on how to read Microsoft Excel (XLS) files, including code. Requires an installed Microsoft ODBC driver for Excel files, and Sun's ODBC-JDBC driver. |
| ExtenXLS | Commercial, 30-day trial version available | Read and write Microsoft Excel (XLS) files. |
| JACOB project | LGPL | Java COM bridge with examples to interface Excel. |
| Java Excel API | LGPL | Read Excel (XLS) 97, 98 and 2000 files. |
| Java to Excel conversion | ? | Write SYLK files, which Excel can import and export. |
| JExcel | Commercial | Swing component to integrate Excel via JNI. |
| jXLS | LGPL | Create Excel files using XLS templates. |
| POI | Apache Software License 1.1 | Read and write Microsoft OLE 2 compound document format files. This includes MS Office files (DOC, XLS, PPT) written with Office versions that were released after 1997. |
| Snowbound | Commercial | Read Excel files. |
| SoftArtisans OfficeWriter | Commercial | Write Word and Excel files. |
| Vista JDBC | Commercial, 15-day trial version available | JDBC driver to access MS Excel (XLS) files. |
| xlSQL | GPL | JDBC driver to access MS Excel (XLS) and CSV files. |
In addition to this table, following links are viable choice for java & excel integration in the application.
Handle Excel files
Content Tagged with excel + Java
ExtenXLS Java Spreadsheet SDK
XLSBeans - mapping Excel sheets to POJOs
Java Excel API
JACOB - JAVA-COM Bridge to call COM components
The Java-Excel solution
Read and Write Microsoft Excel Documents with Jakarta's POI - (The Excel Document Model)
Excel Reports with Apache Cocoon and POI
Jxcell
j-integra - Accessing Excel from Java
ActiveXLS™ Professional for Java
Apache POI - Java API To Access Microsoft Format Files
jXLS - generating Excel files using XLS templates
Posts
2 comments:
Hi Hai,
Currently I am Using Appace POI in my application to generate the Excel report, but in POI there is a row limit.(65536)in MS offce 2003.
Can you provide other java API which I can use to generate a report with more then 65536 limit(In MS office 2007).
Thanks for the info and links!
Post a Comment