|
From: Calle H. <che...@te...> - 2005-01-12 19:29:23
|
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 |