Geek Answers Handbook

Using the new Apache POI in ColdFusion 10

I would like to use a newer version of Apache POI with ColdFusion 10 than the one it comes with, since I need to access some new features.

I tried the ColdFusion Apache POI JAR file exchange for newer versions, but this caused some of the built-in ColdFusion spreadsheet functions to break.

Is it possible to download the new version for use in my code, but leave the ColdFusion version untouched so that the functionality of the embedded tables still works?

I know that it is possible to specify your own Java loading path in CF10 , but if I try and load into a newer version of the library that is already loaded to use ColdFusion, will this cause a collision?

+4
source share
1 answer

You can use Mark Mandel JavaLoader ( https://github.com/markmandel/JavaLoader ) to use the newer version of Apache POI with ColdFusion 10 without affecting the embedded CF in spreadsheet functions.

I used Apache POI version 3.11-beta2 because it does not depend on dom4j.jar, which seems problematic.

I used JavaLoader instead of the built-in ability of CF10 to load JARs, because it allows me to access the older version of Apache POI from ColdFusion, using createObject(), while accessing the newer version stored in my web court using the JavaLoader method server[application.JavaLoader].create().

+3
source

More articles:


All Articles