RE: [dhis2] Java API for manipulating MS Excel files

[Calle H. <che...@te...>]

Hi,

I noted the limitation that "generating pivot tables is not supported".

BUT REMEMBER THAT WE ALREADY HAVE A VB APPLICATION THAT DOES EXACTLY THAT
(see the file Pvt2L.exe in DHIS version 1.3.0.7x)

I see two possibilities here:

1.
Somebody with both Java and VB skills ports our Pivot Table Generator app VB
code to Java and inserts it into this Java API. I don't know if that CAN be
done, but it would be nice to contribute towards the global FOSS community
in that regard.

2.
Another possibility would be to somehow encapsulate the VB app and call it
from the Java API.

The first option would be best, and we could at the same time make a few
improvements to the Pivot Table Generator (I've got a small list).

The logical person to do this would of course be Greg Rudman from Soft
craft, the original designer of the VB app & a good Java developer. Problem
is that he works commercially and we cannot prioritise funding for this now,
so for now we need to find some student(s) or equivalent who's willing to do
this for free. 

Regards
Calle


-----Original Message-----
From: jdh...@li...
[mailto:jdh...@li...] On Behalf Of Ola Hodne
Titlestad
Sent: Wednesday, January 12, 2005 3:48 PM
To: jdh...@li...
Subject: [dhis2] Java API for manipulating MS Excel files

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
---------------------




-------------------------------------------------------
The SF.Net email is sponsored by: Beat the post-holiday blues
Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
_______________________________________________
Jdhis-developers mailing list
Jdh...@li...
https://lists.sourceforge.net/lists/listinfo/jdhis-developers