title: Reliable Excel API for handling complex Excel report (parsing & writing ~10,000 lines) that works with Java
body: <p>i know some similar question already exists, but I haven't found any satisfying answer yet.</p>
  
  <p>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.</p>
  
  <p>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 startRow and endRow for my document is different for each file).</p>