Hello all! I am trying to create a chart in an exc...
# cfml-general
j
Hello all! I am trying to create a chart in an excel sheet using apache poi 4.1.2 on CF2018. I can not access the methods in the XDDFChart abstract class. When I try to call it from the XSSFChart class (which extends the XDDFChart), I get a method not found error. I can dump the contents of the XDDFChart and see all the methods from that class there, but I am not able to instantiate the XDDFChart as an object since it is an abstract class. Has anyone else had success building a chart in an excel spreadsheet, and/or had success calling any methods from any of the abstract classes that are extended in apache POI?
c
CF2018 uses POI 3.17 for its spreadsheet functionality, the class structure of which seems to be different from 4.x in terms of charts. It may be that it's clashing with 4.1.2. How are you loading it? Have you just put it in your class path?
j
I tried both dropping the jar files in and adding a custom class path.
c
I'd recommend using JavaLoader to load 4.1.2, which should ensure it doesn't conflict with 3.17
That's how the Spreadsheet CFML library works conflict-free with ACF using the latest POI v5.x