Spreadsheet extension - java.lang.NoClassDefFoundError

Has anyone successfully installed a working copy of this extension on a
fresh install of Lucee?

Using the ‘Semi-Automatic “Spoofed Provider” Installation via Railo Admin
GUI’ from the link above installs the extension in the web context just
fine, but running the functions gives a java.lang.NoClassDefFoundError with
the message: “railo/loader/engine/CFMLEngineFactory”

Java Stacktrace here:

railo/loader/engine/CFMLEngineFactory
at java.net.URLClassLoader$1.run(URLClassLoader.java:366):366
at java.net.URLClassLoader$1.run(URLClassLoader.java:355):355
at java.security.AccessController.doPrivileged(Native Method):-2
at java.net.URLClassLoader.findClass(URLClassLoader.java:354):354
at java.lang.ClassLoader.loadClass(ClassLoader.java:425):425
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at com.compoundtheory.classloader.NetworkClassLoader.loadClass(
NetworkClassLoader.java:463):463
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at org.cfsearching.poi.XLSXQueryHandler.(XLSXQueryHandler.java:47):
47
at org.cfsearching.poi.WorkbookExportFactory.createQueryExport(
WorkbookExportFactory.java:36):36
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method):-2
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:57):57
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43):43
at java.lang.reflect.Method.invoke(Method.java:606):606
at lucee.runtime.reflection.pairs.MethodInstance.invoke(Unknown
Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.util.VariableUtilImpl.
callFunctionWithoutNamedValues(Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunction(Unknown Source):-1

    at 

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall1(C:\dev\webcontexts\test
components\org\cfpoi\spreadsheet\Spreadsheet.cfc:129):129

    at 

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test
components\org\cfpoi\spreadsheet\Spreadsheet.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source):-
1
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(
Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(Unknown
Source):-1
at spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test\library\tag
spreadsheet.cfc:136):136
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source):-
1
at lucee.runtime.tag.CFTag.cfcStartTag(Unknown Source):-1
at lucee.runtime.tag.CFTag.doStartTag(Unknown Source):-1
at index_cfm$cf.call(C:\dev\apps\test\index.cfm:44):44
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.listener.ModernAppListener._onRequest(Unknown
Source):-1
at lucee.runtime.listener.MixedAppListener.onRequest(Unknown Source
):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source):-
1
at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:305):305
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:210):210
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.
java:51):51
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:243):243
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:210):210
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:222):222
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:123):123
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
AuthenticatorBase.java:502):502
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:171):171
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:100):100
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:118):118
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter
.java:408):408
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200
):200
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
process(AbstractProtocol.java:603):603
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(
JIoEndpoint.java:310):310
at java.util.concurrent.ThreadPoolExecutor.runWorker(
ThreadPoolExecutor.java:1145):1145
at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:615):615

the class “railo/loader/engine/CFMLEngineFactory” simply not exist in
Lucee, it is named “lucee/loader/engine/CFMLEngineFactory”, so the
extension need a small adjustment.

MichaOn Wed, Feb 4, 2015 at 6:48 AM, ADK <@ADK> wrote:

Has anyone successfully installed a working copy of this extension on a
fresh install of Lucee?

https://github.com/teamcfadvance/cfspreadsheet-railo

Using the ‘Semi-Automatic “Spoofed Provider” Installation via Railo Admin
GUI’ from the link above installs the extension in the web context just
fine, but running the functions gives a java.lang.NoClassDefFoundError with
the message: “railo/loader/engine/CFMLEngineFactory”

Java Stacktrace here:

railo/loader/engine/CFMLEngineFactory
at java.net.URLClassLoader$1.run(URLClassLoader.java:366):366
at java.net.URLClassLoader$1.run(URLClassLoader.java:355):355
at java.security.AccessController.doPrivileged(Native Method):-2
at java.net.URLClassLoader.findClass(URLClassLoader.java:354):354
at java.lang.ClassLoader.loadClass(ClassLoader.java:425):425
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at com.compoundtheory.classloader.NetworkClassLoader.loadClass(
NetworkClassLoader.java:463):463
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at org.cfsearching.poi.XLSXQueryHandler.(XLSXQueryHandler.java:47
):47
at org.cfsearching.poi.WorkbookExportFactory.createQueryExport(
WorkbookExportFactory.java:36):36
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method):-2
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:57):57
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43):43
at java.lang.reflect.Method.invoke(Method.java:606):606
at lucee.runtime.reflection.pairs.MethodInstance.invoke(Unknown
Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.util.VariableUtilImpl.
callFunctionWithoutNamedValues(Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunction(Unknown Source):-1

    at

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall1(C:\dev\webcontexts\test
components\org\cfpoi\spreadsheet\Spreadsheet.cfc:129):129

    at

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test
components\org\cfpoi\spreadsheet\Spreadsheet.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(
Unknown Source):-1
at spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test\library\tag
spreadsheet.cfc:136):136
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.tag.CFTag.cfcStartTag(Unknown Source):-1
at lucee.runtime.tag.CFTag.doStartTag(Unknown Source):-1
at index_cfm$cf.call(C:\dev\apps\test\index.cfm:44):44
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.listener.ModernAppListener._onRequest(Unknown
Source):-1
at lucee.runtime.listener.MixedAppListener.onRequest(Unknown
Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source
):-1
at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):
728
at org.apache.catalina.core.ApplicationFilterChain.
internalDoFilter(ApplicationFilterChain.java:305):305
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:210):210
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.
java:51):51
at org.apache.catalina.core.ApplicationFilterChain.
internalDoFilter(ApplicationFilterChain.java:243):243
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:210):210
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:222):222
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:123):123
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
AuthenticatorBase.java:502):502
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:171):171
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:100):100
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:118):118
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:408):408
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:
200):200
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
process(AbstractProtocol.java:603):603
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(
JIoEndpoint.java:310):310
at java.util.concurrent.ThreadPoolExecutor.runWorker(
ThreadPoolExecutor.java:1145):1145
at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:615):615


You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/f58fd3e6-534b-458e-9905-35906966133f%40googlegroups.com
https://groups.google.com/d/msgid/lucee/f58fd3e6-534b-458e-9905-35906966133f%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

Hi Julian - thx. I had tried that as well and same issue. In a clean Lucee
install there is not really ANY mention of “railo” any longer and so it
seems that the references to it in the compiled class files in some uf the
jars are pointing to a railo path that no longer exists. My guess is that
that is why it works on a migrated instance but not a fresh one?On Thursday, February 5, 2015 at 12:52:30 AM UTC-8, Julian Halliwell wrote:

I’ve got it working on a migrated Lucee server, but only by installing
it manually. The extension installation mechanism didn’t work in Railo
4.x either so I’d installed the spreadsheet functionality manually
there too. Here are some instructions - just adjust the path
WEB-INF/railo to WEB-INF/lucee

http://cfsimplicity.com/88/migrating-from-coldfusion-to-railo-part-2-spreadsheets

Can’t see any reason why it wouldn’t work on a fresh install too.

As mentioned in another thread, I’ve ditched this extension in favour
of a standalone library I’ve started building from it. It doesn’t
support everything yet, but I plan to make it do so. It has a couple
of extra methods which make generating simple reports from queries
really easy.

https://github.com/cfsimplicity/lucee-spreadsheet

Julian.

On 4 February 2015 at 05:48, ADK <and...@leftbower.com <javascript:>> wrote:

Has anyone successfully installed a working copy of this extension on a
fresh install of Lucee?

https://github.com/teamcfadvance/cfspreadsheet-railo

Who did the extension? Is there a license defined?

MichaAm Donnerstag, 5. Februar 2015 schrieb ADK :

Thanks Micha.

Searching through all of the files in that extension, I can only seem to
find that reference in 2 compiled class files: XLSXQueryHandler.class and
XLSToQuery.class. There does not seem to be any java src files in the
Github repo though… so I am guess I am not sure what or how to tweak?

On Wednesday, February 4, 2015 at 12:53:26 AM UTC-8, Micha wrote:

the class “railo/loader/engine/CFMLEngineFactory” simply not exist in
Lucee, it is named “lucee/loader/engine/CFMLEngineFactory”, so the
extension need a small adjustment.

Micha

On Wed, Feb 4, 2015 at 6:48 AM, ADK and...@leftbower.com wrote:

Has anyone successfully installed a working copy of this extension on a
fresh install of Lucee?

https://github.com/teamcfadvance/cfspreadsheet-railo

Using the ‘Semi-Automatic “Spoofed Provider” Installation via Railo
Admin GUI’ from the link above installs the extension in the web context
just fine, but running the functions gives a java.lang.NoClassDefFoundError
with the message: “railo/loader/engine/CFMLEngineFactory”

Java Stacktrace here:

railo/loader/engine/CFMLEngineFactory
at java.net.URLClassLoader$1.run(URLClassLoader.java:366):366
at java.net.URLClassLoader$1.run(URLClassLoader.java:355):355
at java.security.AccessController.doPrivileged(Native Method):-2
at java.net.URLClassLoader.findClass(URLClassLoader.java:354):354
at java.lang.ClassLoader.loadClass(ClassLoader.java:425):425
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at com.compoundtheory.classloader.NetworkClassLoader.loadClass(
NetworkClassLoader.java:463):463
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at org.cfsearching.poi.XLSXQueryHandler.(XLSXQueryHandler.java:47
):47
at org.cfsearching.poi.WorkbookExportFactory.createQueryExport(
WorkbookExportFactory.java:36):36
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method):-2
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
ssorImpl.java:57):57
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
thodAccessorImpl.java:43):43
at java.lang.reflect.Method.invoke(Method.java:606):606
at lucee.runtime.reflection.pairs.MethodInstance.invoke(Unknown
Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamed
Values(Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunction(Unknown Source):-1

    at

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall1(C:\dev\webcontexts\test
\components\org\cfpoi\spreadsheet\Spreadsheet.cfc:129):129

    at

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test
components\org\cfpoi\spreadsheet\Spreadsheet.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedVal
ues(Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(Unk
nown Source):-1
at spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test\library\tag
\spreadsheet.cfc:136):136
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.tag.CFTag.cfcStartTag(Unknown Source):-1
at lucee.runtime.tag.CFTag.doStartTag(Unknown Source):-1
at index_cfm$cf.call(C:\dev\apps\test\index.cfm:44):44
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.listener.ModernAppListener._onRequest(Unknown
Source):-1
at lucee.runtime.listener.MixedAppListener.onRequest(Unknown
Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source
):-1
at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):
728
at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
lter(ApplicationFilterChain.java:305):305
at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
licationFilterChain.java:210):210
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.
java:51):51
at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
lter(ApplicationFilterChain.java:243):243
at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
licationFilterChain.


You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com
<javascript:_e(%7B%7D,‘cvml’,‘lucee%2Bunsubscribe@googlegroups.com’);>.
To post to this group, send email to lucee@googlegroups.com
<javascript:_e(%7B%7D,‘cvml’,‘lucee@googlegroups.com’);>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/b2cb11f7-1f7f-4e07-bdf8-e3cdeada2c8e%40googlegroups.com
https://groups.google.com/d/msgid/lucee/b2cb11f7-1f7f-4e07-bdf8-e3cdeada2c8e%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

Andrew, I just shut down my migrated instance of Lucee (on my dev
machine), and started up a fresh Lucee Express. A quick test of my
standalone library, placing it in the /webapps/ROOT/, appeared to work
perfectly.

I then stopped the instance, installed the old Railo extension
manually into the

/webapps/ROOT/WEB-INF/lucee

context, restarted the express instance and, again it worked fine.

With the Railo-migrated instance completely shut down, surely it can’t
be interfering can it?

Perhaps it’s only certain functions that are affected? Which ones are
you testing?

Julian.On 5 February 2015 at 09:08, Julian Halliwell <@Julian_Halliwell> wrote:

You might be right, Andrew. Could you see if my standalone library on
Github works? It uses exactly the same jars but detached from the
Railo/Lucee context.

https://github.com/cfsimplicity/lucee-spreadsheet

On 5 February 2015 at 09:02, ADK <@ADK> wrote:

Hi Julian - thx. I had tried that as well and same issue. In a clean Lucee
install there is not really ANY mention of “railo” any longer and so it
seems that the references to it in the compiled class files in some uf the
jars are pointing to a railo path that no longer exists. My guess is that
that is why it works on a migrated instance but not a fresh one?

You might be right, Andrew. Could you see if my standalone library on
Github works? It uses exactly the same jars but detached from the
Railo/Lucee context.

https://github.com/cfsimplicity/lucee-spreadsheetOn 5 February 2015 at 09:02, ADK <@ADK> wrote:

Hi Julian - thx. I had tried that as well and same issue. In a clean Lucee
install there is not really ANY mention of “railo” any longer and so it
seems that the references to it in the compiled class files in some uf the
jars are pointing to a railo path that no longer exists. My guess is that
that is why it works on a migrated instance but not a fresh one?

There is not a license that I can find. It looks like it was orignally done
by Andy Jarrett and then taken over by TeamCfAdvance:

All old links from original repos either 404 or redirect to the new repo
linked aboveOn Wednesday, February 4, 2015 at 11:24:41 PM UTC-8, Micha wrote:

Who did the extension? Is there a license defined?

Micha

Am Donnerstag, 5. Februar 2015 schrieb ADK :

Thanks Micha.

Searching through all of the files in that extension, I can only seem to
find that reference in 2 compiled class files: XLSXQueryHandler.class and
XLSToQuery.class. There does not seem to be any java src files in the
Github repo though… so I am guess I am not sure what or how to tweak?

On Wednesday, February 4, 2015 at 12:53:26 AM UTC-8, Micha wrote:

the class “railo/loader/engine/CFMLEngineFactory” simply not exist in
Lucee, it is named “lucee/loader/engine/CFMLEngineFactory”, so the
extension need a small adjustment.

Micha

On Wed, Feb 4, 2015 at 6:48 AM, ADK and...@leftbower.com wrote:

Has anyone successfully installed a working copy of this extension on a
fresh install of Lucee?

https://github.com/teamcfadvance/cfspreadsheet-railo

Using the ‘Semi-Automatic “Spoofed Provider” Installation via Railo Admin
GUI’ from the link above installs the extension in the web context just
fine, but running the functions gives a java.lang.NoClassDefFoundError with
the message: “railo/loader/engine/CFMLEngineFactory”

Java Stacktrace here:

railo/loader/engine/CFMLEngineFactory
at java.net.URLClassLoader$1.run(URLClassLoader.java:366):366
at java.net.URLClassLoader$1.run(URLClassLoader.java:355):355
at java.security.AccessController.doPrivileged(Native Method):-2
at java.net.URLClassLoader.findClass(URLClassLoader.java:354):354
at java.lang.ClassLoader.loadClass(ClassLoader.java:425):425
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at com.compoundtheory.classloader.NetworkClassLoader.loadClass(
NetworkClassLoader.java:463):463
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at org.cfsearching.poi.XLSXQueryHandler.(XLSXQueryHandler.java:47
):47
at org.cfsearching.poi.WorkbookExportFactory.createQueryExport(
WorkbookExportFactory.java:36):36
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method):-2
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
ssorImpl.java:57):57
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
thodAccessorImpl.java:43):43
at java.lang.reflect.Method.invoke(Method.java:606):606
at lucee.runtime.reflection.pairs.MethodInstance.invoke(Unknown
Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamed
Values(Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunction(Unknown Source):-1

    at 

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall1(C:\dev\webcontexts\test
components\org\cfpoi\spreadsheet\Spreadsheet.cfc:129):129

    at 

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test
components\org\cfpoi\spreadsheet\Spreadsheet.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(Unk
nown Source):-1
at spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test\library\tag
spreadsheet.cfc:136):136
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.tag.CFTag.cfcStartTag(Unknown Source):-1
at lucee.runtime.tag.CFTag.doStartTag(Unknown Source):-1
at index_cfm$cf.call(C:\dev\apps\test\index.cfm:44):44
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.listener.ModernAppListener._onRequest(Unknown
Source):-1
at lucee.runtime.listener.MixedAppListener.onRequest(Unknown
Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source
):-1
at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):
728
at org.apache.catalina.core.ApplicationFilterChain.internalDoFi
lter(ApplicationFilterChain.java:305):305
at org.apache.catalina.core.ApplicationFilterChain.doFilter(App
licationFilterChain.java:210):210
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.
java:51):51
at org.apache

Thanks Micha.

Searching through all of the files in that extension, I can only seem to
find that reference in 2 compiled class files: XLSXQueryHandler.class and
XLSToQuery.class. There does not seem to be any java src files in the
Github repo though… so I am guess I am not sure what or how to tweak?On Wednesday, February 4, 2015 at 12:53:26 AM UTC-8, Micha wrote:

the class “railo/loader/engine/CFMLEngineFactory” simply not exist in
Lucee, it is named “lucee/loader/engine/CFMLEngineFactory”, so the
extension need a small adjustment.

Micha

On Wed, Feb 4, 2015 at 6:48 AM, ADK <and...@leftbower.com <javascript:>> wrote:

Has anyone successfully installed a working copy of this extension on a
fresh install of Lucee?

https://github.com/teamcfadvance/cfspreadsheet-railo

Using the ‘Semi-Automatic “Spoofed Provider” Installation via Railo Admin
GUI’ from the link above installs the extension in the web context just
fine, but running the functions gives a java.lang.NoClassDefFoundError with
the message: “railo/loader/engine/CFMLEngineFactory”

Java Stacktrace here:

railo/loader/engine/CFMLEngineFactory
at java.net.URLClassLoader$1.run(URLClassLoader.java:366):366
at java.net.URLClassLoader$1.run(URLClassLoader.java:355):355
at java.security.AccessController.doPrivileged(Native Method):-2
at java.net.URLClassLoader.findClass(URLClassLoader.java:354):354
at java.lang.ClassLoader.loadClass(ClassLoader.java:425):425
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at lucee.loader.classloader.LuceeClassLoader.loadClass(Unknown
Source):-1
at com.compoundtheory.classloader.NetworkClassLoader.loadClass(
NetworkClassLoader.java:463):463
at java.lang.ClassLoader.loadClass(ClassLoader.java:358):358
at org.cfsearching.poi.XLSXQueryHandler.(XLSXQueryHandler.java:47
):47
at org.cfsearching.poi.WorkbookExportFactory.createQueryExport(
WorkbookExportFactory.java:36):36
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method):-2
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:57):57
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43):43
at java.lang.reflect.Method.invoke(Method.java:606):606
at lucee.runtime.reflection.pairs.MethodInstance.invoke(Unknown
Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.java.JavaObject.call(Unknown Source):-1
at lucee.runtime.util.VariableUtilImpl.
callFunctionWithoutNamedValues(Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunction(Unknown Source):-1

    at 

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall1(C:\dev\webcontexts\test
components\org\cfpoi\spreadsheet\Spreadsheet.cfc:129):129

    at 

org.cfpoi.spreadsheet.spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test
components\org\cfpoi\spreadsheet\Spreadsheet.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(Unknown Source):-1
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(
Unknown Source):-1
at spreadsheet_cfc$cf.udfCall(C:\dev\webcontexts\test\library\tag
spreadsheet.cfc:136):136
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source
):-1
at lucee.runtime.tag.CFTag.cfcStartTag(Unknown Source):-1
at lucee.runtime.tag.CFTag.doStartTag(Unknown Source):-1
at index_cfm$cf.call(C:\dev\apps\test\index.cfm:44):44
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.listener.ModernAppListener._onRequest(Unknown
Source):-1
at lucee.runtime.listener.MixedAppListener.onRequest(Unknown
Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source
):-1
at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):
728
at org.apache.catalina.core.ApplicationFilterChain.
internalDoFilter(ApplicationFilterChain.java:305):305
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:210):210
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.
java:51):51
at org.apache.catalina.core.ApplicationFilterChain.
internalDoFilter(ApplicationFilterChain.java:243):243
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.

I’ve got it working on a migrated Lucee server, but only by installing
it manually. The extension installation mechanism didn’t work in Railo
4.x either so I’d installed the spreadsheet functionality manually
there too. Here are some instructions - just adjust the path
WEB-INF/railo to WEB-INF/lucee

http://cfsimplicity.com/88/migrating-from-coldfusion-to-railo-part-2-spreadsheets

Can’t see any reason why it wouldn’t work on a fresh install too.

As mentioned in another thread, I’ve ditched this extension in favour
of a standalone library I’ve started building from it. It doesn’t
support everything yet, but I plan to make it do so. It has a couple
of extra methods which make generating simple reports from queries
really easy.

Julian.On 4 February 2015 at 05:48, ADK <@ADK> wrote:

Has anyone successfully installed a working copy of this extension on a
fresh install of Lucee?

https://github.com/teamcfadvance/cfspreadsheet-railo

Very odd. Could you test whether this works?

It uses the exact same jars as the extension.On 11 February 2015 at 08:17, ADK <@ADK> wrote:

So I just did exactly as you say: shutdown my local Tomcat/Lucee, download
Lucee Express (4.5.1.000) and manually install EXACTLY as your blog post,
start up Lucee and run both a cfspreadsheet tag and a spreadsheetread()
cfscript version to read a file and both give me error and show looking for
“railo/loader/engine/CFMLEngineFactory”

Looking at the compiled class files, this seems to be hard coded in? (i.e.
references to “railo”) so I am not sure (a) how you got it to work and (b)
how to move forward?

I suppose I could rewrite a lot of code to use an alternative solution (i.e.
yours or other’s POI utility, etc.) but would really like to just get this
extension up an running…

Hey Julian… sorry for late response, I was traveling.

So I just did exactly as you say: shutdown my local Tomcat/Lucee, download
Lucee Express (4.5.1.000) and manually install EXACTLY as your blog post,
start up Lucee and run both a cfspreadsheet tag and a spreadsheetread()
cfscript version to read a file and both give me error and show looking for
“railo/loader/engine/CFMLEngineFactory”

Looking at the compiled class files, this seems to be hard coded in? (i.e.
references to “railo”) so I am not sure (a) how you got it to work and (b)
how to move forward?

I suppose I could rewrite a lot of code to use an alternative solution
(i.e. yours or other’s POI utility, etc.) but would really like to just get
this extension up an running…On Thursday, February 5, 2015 at 2:18:57 AM UTC-8, Julian Halliwell wrote:

Andrew, I just shut down my migrated instance of Lucee (on my dev
machine), and started up a fresh Lucee Express. A quick test of my
standalone library, placing it in the /webapps/ROOT/, appeared to work
perfectly.

I then stopped the instance, installed the old Railo extension
manually into the

/webapps/ROOT/WEB-INF/lucee

context, restarted the express instance and, again it worked fine.

With the Railo-migrated instance completely shut down, surely it can’t
be interfering can it?

Perhaps it’s only certain functions that are affected? Which ones are
you testing?

Julian.

On 5 February 2015 at 09:08, Julian Halliwell <julianh...@gmail.com <javascript:>> wrote:

You might be right, Andrew. Could you see if my standalone library on
Github works? It uses exactly the same jars but detached from the
Railo/Lucee context.

https://github.com/cfsimplicity/lucee-spreadsheet

On 5 February 2015 at 09:02, ADK <and...@leftbower.com <javascript:>> wrote:

Hi Julian - thx. I had tried that as well and same issue. In a clean
Lucee

install there is not really ANY mention of “railo” any longer and so it
seems that the references to it in the compiled class files in some uf
the

jars are pointing to a railo path that no longer exists. My guess is
that

that is why it works on a migrated instance but not a fresh one?

Andrew, it seems that Micha intended to implement ACF’s spreadsheet
functionality in the core 3 years ago and made a small start:

https://issues.jboss.org/browse/RAILO-1749

But that was abandoned, presumably because it was deemed not
appropriate for the core after all. SpreadsheetNew() does seem to work
without the extension, but I couldn’t get SpreadsheetWrite() to do
anything. Clearly not reliable and likely to be removed in 5.0.

I’ve been working on my standalone library today and have managed to
get “read” functionality partially working in Lucee. Basically it will
read an xls file into a query object, but not CSV or HTML at present.
Also specifying column/row ranges and column names other than the
header row isn’t there yet, neither is reading a named sheet (reading
by sheet number is, however).

It needs more work and some tests (on the way), but I do plan to match
as much of the old extension functionality as I can.

I realise though that unlike the extension, it would involve folks
changing application code, so my aim is also to fork the Railo
extension and replace the faulty “read” elements with what I’ve come
up with.

It would be great if you and others could test the library in Lucee to
iron out any issues before I back-port it to the extension.

Cheers
Julian.On 13 February 2015 at 19:12, ADK <@ADK> wrote:

Julian - yes, “reading” spreadsheets is all I actually need to do. It
appears that spreadsheet writing is already part of Lucee core:

https://bitbucket.org/lucee/lucee/src/dc6cad5966335262c49f2a15743acd3e7061ce00/lucee-java/lucee-core/src/lucee/runtime/functions/poi/?at=master

So there appears to be some duplication going on?

Andrew, I’ve been doing some testing and have now been able to
reproduce the error, but only with the “read” method.

The jar with the now incorrect railo reference is the
“poi-export-utility.jar”, which is only used when reading spreadsheets
from disk.

I’m working on an alternative way of fulfilling that functionality
which I’ll include in my standalone library and if possible as a fork
of the old Railo extension.

Will let you know when I’ve made more progress.

Cheers
Julian.On 11 February 2015 at 08:17, ADK <@ADK> wrote:

So I just did exactly as you say: shutdown my local Tomcat/Lucee, download
Lucee Express (4.5.1.000) and manually install EXACTLY as your blog post,
start up Lucee and run both a cfspreadsheet tag and a spreadsheetread()
cfscript version to read a file and both give me error and show looking for
“railo/loader/engine/CFMLEngineFactory”

Looking at the compiled class files, this seems to be hard coded in? (i.e.
references to “railo”) so I am not sure (a) how you got it to work and (b)
how to move forward?

I suppose I could rewrite a lot of code to use an alternative solution (i.e.
yours or other’s POI utility, etc.) but would really like to just get this
extension up an running…

On Thursday, February 5, 2015 at 2:18:57 AM UTC-8, Julian Halliwell wrote:

Andrew, I just shut down my migrated instance of Lucee (on my dev
machine), and started up a fresh Lucee Express. A quick test of my
standalone library, placing it in the /webapps/ROOT/, appeared to work
perfectly.

I then stopped the instance, installed the old Railo extension
manually into the

/webapps/ROOT/WEB-INF/lucee

context, restarted the express instance and, again it worked fine.

With the Railo-migrated instance completely shut down, surely it can’t
be interfering can it?

Perhaps it’s only certain functions that are affected? Which ones are
you testing?

Julian - yes, “reading” spreadsheets is all I actually need to do. It
appears that spreadsheet writing is already part of Lucee core:

https://bitbucket.org/lucee/lucee/src/dc6cad5966335262c49f2a15743acd3e7061ce00/lucee-java/lucee-core/src/lucee/runtime/functions/poi/?at=master

So there appears to be some duplication going on?On Friday, February 13, 2015 at 7:26:31 AM UTC-8, Julian Halliwell wrote:

Andrew, I’ve been doing some testing and have now been able to
reproduce the error, but only with the “read” method.

The jar with the now incorrect railo reference is the
“poi-export-utility.jar”, which is only used when reading spreadsheets
from disk.

I’m working on an alternative way of fulfilling that functionality
which I’ll include in my standalone library and if possible as a fork
of the old Railo extension.

Will let you know when I’ve made more progress.

Cheers
Julian.

On 11 February 2015 at 08:17, ADK <and...@leftbower.com <javascript:>> wrote:

So I just did exactly as you say: shutdown my local Tomcat/Lucee,
download
Lucee Express (4.5.1.000) and manually install EXACTLY as your blog
post,
start up Lucee and run both a cfspreadsheet tag and a spreadsheetread()
cfscript version to read a file and both give me error and show looking
for
“railo/loader/engine/CFMLEngineFactory”

Looking at the compiled class files, this seems to be hard coded in?
(i.e.
references to “railo”) so I am not sure (a) how you got it to work and
(b)
how to move forward?

I suppose I could rewrite a lot of code to use an alternative solution
(i.e.
yours or other’s POI utility, etc.) but would really like to just get
this
extension up an running…

On Thursday, February 5, 2015 at 2:18:57 AM UTC-8, Julian Halliwell wrote:

Andrew, I just shut down my migrated instance of Lucee (on my dev
machine), and started up a fresh Lucee Express. A quick test of my
standalone library, placing it in the /webapps/ROOT/, appeared to work
perfectly.

I then stopped the instance, installed the old Railo extension
manually into the

/webapps/ROOT/WEB-INF/lucee

context, restarted the express instance and, again it worked fine.

With the Railo-migrated instance completely shut down, surely it can’t
be interfering can it?

Perhaps it’s only certain functions that are affected? Which ones are
you testing?

Sorry, I meant Michael. For the avoidance of confusion.On 14 February 2015 at 21:40, Julian Halliwell <@Julian_Halliwell> wrote:

Hi Martin

Hi Julian,
I would like to test you spreadsheet extension, but I need a little help to
install it.
I’m using lucee on a windows server with Apache Tomcat.
Could you please describe how to install it, if I downloaded the file
lucre-spreadsheet-master.zip?

Thank you for your help!!!

And by the way: I’m wondering, why there aren’t more people requesting the
spreadsheet tags. We get very offen excel-sheets from our customers, which
must be imported or we have to export data in excel-format.

Greetings

Michael
https://github.com/cfsimplicity/lucee-spreadsheet/archive/master.zipAm Freitag, 13. Februar 2015 21:22:03 UTC+1 schrieb Julian Halliwell:

It would be great if you and others could test the library in Lucee to
iron out any issues before I back-port it to the extension.

https://github.com/cfsimplicity/lucee-spreadsheet
https://www.google.com/url?q=https%3A%2F%2Fgithub.com%2Fcfsimplicity%2Flucee-spreadsheet&sa=D&sntz=1&usg=AFQjCNFOY0XRM6oumb-lwL_dVfm5Xqa6OQ

Cheers
Julian.

Hi Martin

Firstly, I found a serious bug in my code for the read() function.
Please download the latest version (v0.0.6) under “releases” or
the master zip and replace the files you downloaded earlier.

Secondly, I get the same error using . I would strongly
recommend you avoid that tag call the Spreadsheet.cfc as follows.

// test.cfm

spreadsheet = New Spreadsheet();
spreadsheetFilepath = ExpandPath( “RegulatoryKopf.xls” );
dataAsQuery = spreadsheet.read( src=spreadsheetFilepath,format=“query” );

Or if you must use tags:

<cfset spreadsheet = New Spreadsheet()>
<cfset spreadsheetFilepath = ExpandPath( “RegulatoryKopf.xls” )>
<cfset dataAsQuery = spreadsheet.read( src=spreadsheetFilepath,format=“query” )>

This assumes test.cfm, Spreadsheet.cfc and RegulatoryKopf are all in
the same folder. Note you must provide a full path to your Excel file,
not just the file name.

(Also, avoid using within a block -
could lead to problems).

Julian.On 14 February 2015 at 13:24, Michael Vornkahl <@Michael_Vornkahl> wrote:

Hi Julian,
I got the following error:

Lucee 4.5.1.000 Error (expression)
Message variable [TOOLS] doesn’t exist

Hi Julian,
I got the following error:

Lucee 4.5.1.000 Error (expression)
Message variable [TOOLS] doesn’t exist
Stacktrace The Error Occurred in
D:\Inetpub\wwwroot\CPMG\assets\lucee-spreadsheet\Spreadsheet.cfc: line 313

311: throw( type=exceptionType,message="Attribute not yet 

supported",detail=“Sorry the ‘sheetName’ attribute is not yet supported.” );
312: //END TODO
313: var workbook = tools.workbookFromFile( src );
314: switch( format ){
315: case “csv”: case “tab”: case “pipe”:

called from
D:\Inetpub\wwwroot\CPMG\assets\lucee-spreadsheet\KBV_Export.cfm: line 6
Java Stacktrace variable [TOOLS] doesn’t exist
at lucee.runtime.type.scope.UndefinedImpl.getCollection(Unknown Source):-1
at
cpmg.assets.lucee_spreadsheet270.spreadsheet_cfc$cf.udfCall2(D:\Inetpub\wwwroot\CPMG\assets\lucee-spreadsheet\Spreadsheet.cfc:313):313
at
cpmg.assets.lucee_spreadsheet270.spreadsheet_cfc$cf.udfCall(D:\Inetpub\wwwroot\CPMG\assets\lucee-spreadsheet\Spreadsheet.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl._call(Unknown Source):-1
at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source):-1
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(Unknown
Source):-1
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(Unknown
Source):-1
at
cpmg.assets.lucee_spreadsheet270.kbv_export_cfm$cf.call(D:\Inetpub\wwwroot\CPMG\assets\lucee-spreadsheet\KBV_Export.cfm:6):6
at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
at lucee.runtime.listener.ClassicAppListener._onRequest(Unknown Source):-1
at lucee.runtime.listener.MixedAppListener.onRequest(Unknown Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source):-1
at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222):222
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123):123
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99):99
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408):408
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589):589
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310):310
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617
at java.lang.Thread.run(Thread.java:745):745

Timestamp 2/14/15 2:23:56 PM CET

Hi Michael

It’s not an extension so you don’t need to install it. It works as a
standalone library, so you just need to copy the contents of
lucee-spreadsheet-master inside the zip to a folder where you can call
Spreadsheet.cfc from your code. Could be inside your app, or in a
central location available via an application mapping.

I put some examples of how to call it in the ReadMe. Let me know if
it’s not clear enough.

Do read about the limitations - it doesn’t do everything that the
extension did yet.

Thanks
JulianOn 14 February 2015 at 11:38, Michael Vornkahl <@Michael_Vornkahl> wrote:

I would like to test you spreadsheet extension, but I need a little help to
install it.
I’m using lucee on a windows server with Apache Tomcat.
Could you please describe how to install it, if I downloaded the file
lucre-spreadsheet-master.zip?

Ok,
I will report any problems.
Could you give me a hint how I can call the spreadsheet.cfc if it’s not in
the same directory?
Maybe I’m to tired today, but it won’t work in the moment.

Bye

MichaelAm Sonntag, 15. Februar 2015 11:06:16 UTC+1 schrieb Julian Halliwell:

Glad to hear it’s working, Michael.

The library is neither complete nor stable at the moment so it’s
important you test thoroughly. However I’ve been using it in
production for the limited set of functions I regularly need
(generating reports, mainly) and it’s been fine so far.

Please do report any more problems you come across. Probably best to
do so using the Github issue tracker:

https://github.com/cfsimplicity/lucee-spreadsheet/issues

Julian.

On 15 February 2015 at 09:31, Michael Vornkahl <michael.v...@gmail.com <javascript:>> wrote:

So I will follow your work and test it so offen I can. If it is ready
(for
me, I know, for the developer it is never ready …), I can switch on my
production server to lucee.