Reliable Excel API for handling complex Excel report (parsing & writing ~10,000 lines) that works with Java

i know some similar question already exists, but I haven't found any satisfying answer yet.

I found several library such as Apache POI and JExcelAPI, however as I don't have any previous experience with any Java Excel API yet, perhaps some of you guys who experienced it before can enlighten me regarding the advantages and disadvantages of each API. My requirements are reliability and ease-of-use, because I have to parse and write numerous excel reports with ~10,000 lines in each file.

I'm also considering JXLS which can parse and write document using template to minimize coding effort, but based on my test, we have to hard-code the startRow and endRow when parsing (the s开发者_StackOverflow中文版tartRow and endRow for my document is different for each file).

---

Actually, even the old versions of POI will support 10,000 rows - the limitation was either ~32000 or ~64000 rows.

But the latest POI supports the XML file formats for 2007, and therefore I'm sure memory will be your only limitation.

I use POI in a corporate application, and I've never had a problem with it.

---

Aspose.Cells for Java allows you to create or parse large Excel files in Java applications. The API is simple along with complete documentation and support. A large number of users have already incorporated it in their applications. It is easy to learn and any questions can be answered quickly through our support forum. You may try this and see if it helps in your scenario.

Disclosure: I work as developer evangelist at Aspose.

---

I've used JExcel with great success, although I can't say that any of those files were on the order of 10,000 rows per file.

I'd wonder if you'd be better off with a relational database with this volume of data. Excel might have been a fine way to start, but maybe it's time to ask yourself if you've outgrown spreadsheets.