In my life as a Software Developer I've been on the need to work with MS-Office in some many programming languages and regardless the language it's always a pain.
EXCEL is the favorite tool for a common user on its daily basic work. For me and for most the people i know, EXCEL if the best software packaged in the MS-Office Suite.
How ever finding a library that suite your needs it kinda difficult sometime.
Currently exist Apache POI, this library intends to be the bridge between all MS-Office package and the Java World, currently its on a very early stage and most of the work its being done on the EXCEL implementation API. This library give you the complete control over the documents and sheets, w
hich i found it interesting when you want to build your report from scratch.
But in the other hand, the JXLS Project which only focus on EXCEL Interoperability, seems for me the right choice when you have a very elaborate template with a fancy design and just want a way to inject data directly into it.
Check the following example and you will know what i mean.
EXCEL is the favorite tool for a common user on its daily basic work. For me and for most the people i know, EXCEL if the best software packaged in the MS-Office Suite.
How ever finding a library that suite your needs it kinda difficult sometime.
Currently exist Apache POI, this library intends to be the bridge between all MS-Office package and the Java World, currently its on a very early stage and most of the work its being done on the EXCEL implementation API. This library give you the complete control over the documents and sheets, w
hich i found it interesting when you want to build your report from scratch.
But in the other hand, the JXLS Project which only focus on EXCEL Interoperability, seems for me the right choice when you have a very elaborate template with a fancy design and just want a way to inject data directly into it.
Check the following example and you will know what i mean.