Hi Curtis,

My situation is probably different in that I'm running this stuff on an IBM
iSeries with the OS400 operating system rather than a Windows or Unix-like
OS. However, I'll list what I did and see if that helps; I'm sure others can
chime in with more info for your scenario.

 1. Go to http://jakarta.apache.org/poi, click on the Download link, select
a mirror site, and download the latest release bin -- in my case I chose
poi-bin-2.5.1-final-20040804.zip -- they also have other archive file
formats available, eg .tar.

 2. Unzip the .jar files:
poi-2.5.1-final-2004-0804.jar
poi-contrib-2.0-RC2-20040102.jar
poi-scratchpad-2.0-RC2-20040102.jar
from this file and place them in your ../j2skd1.4.2_08/jre/lib/ext (in my
case they go in a directory called /QIBM/userdata/Java400/ext). If you put
them somewhere else, that directory should be in your classpath.

 3. The poi-3.0-alpha1-20050721.jar file from the nightly builds link
replaces the poi-2.5.1-final-2004-0804.jar file. Move or delete the latter
so it will use the former.

 4. Write your Java code that utilizes the classes and methods in these .jar
files and run it.
I was writing a general purpose utility to read a template .xls file, add
data to it from an OS400 file, and write out another .xls file. The problem
was that the default column formatting from the template .xls was not being
applied to the data I was adding; the patch for issue #35799 which is
included in the poi-3.0-alpha1-20050721.jar fixed that.

hth,
Peter Dow
Dow Software Services, Inc.
www.dowsoftware.com
909 793-9050 voice
909 793-4480 fax

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.5/58 - Release Date: 7/25/2005



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Reply via email to