Is there a way of determining what version of Apache POI ColdFusion 10 uses? I have had a look in the lib directory but the name of the POI JAR file does not contain a version number.
If it is not the latest version how would I go about using the latest version in my code? I know I can use this.JavaSettings to load a JAR from a custom path.
I have downloaded the latest version of POI and it contains many JAR files: 6 in the top level directory, 4 in the lib subdirectory and 3 in the ooxml-lib directory. Do I need to reference all of these JARs within this.JavaSettings?
Also once I have referenced the correct JARs in this.JavaSettings how do I then use the library in my code? I have used ColdFusion's version of POI with code such as the following:
createObject('java','org.apache.poi.ss.usermodel.WorkbookFactory').create(infile);
How would I need to change this code to use the latest version of POI which I referenced in this.JavaSettings?
Still getting my head around all this Java stuff! Thanks.
I asked a similar question more recently after forgetting I had already posted this question.
Please see Using a newer version of Apache POI in ColdFusion 10 which contains more helpful information.