Recent content by rkolosky

Actually, I downloaded three JARs: poi-2.5.1-final-20040804.jar, poi-contrib-2.5.1-final-20040804.jar, poi-scratchpad-2.5.1-final-20040804.jar I then put them into CFusionMX\wwwroot\WEB-INF\lib\ and then went to the CF Administrator -> Java and JVM Settings and put the exact locations of the...

Yes, you have to download poi from the Apache POI site and then copy the JAR somewhere on your Cold Fusion server. You would then go to the Cold Fusion Administrator and add the JAR into the class path.

No, I have this running under IIS as well. The Apache Foundatin is just providing services for POI, they don't require you to be running Apache as the webserver.

While you can definitely create an Excel spreadsheet using Apache POI, you can also read from one. You would upload the Excel spreadsheet into somewhere Cold Fusion can see it, and then tell it which cells to read and the variables to store the data in. Here's the code I use to test if the...

Using Apache POI (http://jakarta.apache.org/poi/), you can load a Java object that can read Excel sheets. Dave Ross (http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA) has a blog post about how to do this. It looks like a lot of coding, but it's pretty simple once you...

Thank you both for the answers.

I have two databases, one that is being used as forum software for a web application and another in-house application to manage addresses. I would like to be able to propogate changes from the address application out to the forum application. On the address application, I put a trigger on...