Interfacing Java with Microsoft Excel has always been a pain for software engineers.

The Apache foundation came out wit POI a Java API To Access Microsoft Format Files but it had its own limitations and the learning curve was a bit steep.

While looking for other ready made libraries I came across "jexcel". Its a simple library which can do quite a bit for its size. Its very easy to use and can manipulate existing excel files having formatted information as well as create new files with custom information and formats based on pure coding or a template.

If your existing libraries or custom developed tool does not do its job or does not do its job well I highly recommend giving this a shot.

Also check out http://jexcelapi.sourceforge.net/ and http://www.andykhan.com/jexcelapi/tutorial.html for a quick tutorial on how to use it.