|
From: Ola H. T. <ol...@st...> - 2005-01-12 13:49:09
|
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 --------------------- |