Java Microsoft Excel API [closed]

Question

Does anyone know if there is an API for java by Microsoft Excel?

Answer 1

You have APache POI and JExcelApi to mention two open source variants. The former supports up to version 2008 and the latter up to version 2003. Personally I prefer the syntax of the former.

Answer 2

Extensive List of Products currently available:

Apache POI

OpenXls

JEXCEL

JXLS

xlSQL

JCOM

Personally, POI will be the best option, but it involves a lot of coding effort compared to JXLS, which is a wrapper over POI. In JXLS all you need to do is to create XLS template file with all required formatting, formulas etc using specific notation to indicate placement of data and then write a couple lines of code to invoke jXLS engine passing XLS template and the exported data as parameters. Catch in Jxls is the data in every cell must be a JavaBean.