[dhis2] Java API for manipulating MS Excel files

[Ola H. T. <ol...@st...>]

Hi all,
found this OSS project:

http://jakarta.apache.org/poi/

Not sure exactly how we can use it, but it sure seems like an interesting
bridge between java apps and MS files, especially Excel files.

"The POI project consists of APIs for manipulating various file formats
based upon Microsoft's OLE 2 Compound Document format using pure Java. In
short, you can read and write MS Excel files using Java. Soon, you'll be
able to read and write Word files using Java. POI is your Java Excel
solution as well as your Java Word solution. However, we have a complete
API for porting other OLE 2 Compound Document formats and welcome others
to participate."

In limitations I found:
"[..]
Pivot Tables:
Generating pivot tables is not supported. It has been reported that files
containing pivot tables can be read and re-written safely.
[..]
"

So modifying pivot tables should work....

-- 
regards,
Ola Hodne Titlestad
HISP
University of Oslo
---------------------