cfspreadsheet for Railo
This is a fork of http://code.google.com/p/cfpoi/ for Railo so a massive thank you must go out to Matt Woodward (www.mattwoodward.com / @mpwoodward) as he has done all the hard work for this project I am just forking it to make it workable with Railo as an extension.
At the moment this should be considered alpha/beta as it needs some full testing to be done. It is currently working for my limited needs but it requires feedback before being considered as stable.
To install
- log in to your Web Administrator and add http://www.andyjarrett.co.uk/RailoExtensionProvider/ExtensionProvider.cfc to your Providers (under Extension)
- Then go to Applications (still under Extension) and install "CFPOI, a wrapper for the Apache POI Project."
- Once done you will need to restart your Railo server.
With your server restarted you should be able to use the cfspreadsheet functions and tags.
All the code os open source so to have a look around or log issues please check out the following links:
Source: https://github.com/andyj/RailoExtensionProvider
Report issues: https://github.com/andyj/RailoExtensionProvider/issues
Comments
I am going to assume the reason the extension wouldn't install is because I am still on an earlier version of the railo beta cycle 3.2.003 (3.2.1 will not run when I update the .rc file)
The error message I receive is:
invalid component definition, can't find /install/Install
error occured in ExtensionManager.cfc:22
variable [INSTALL] doesn't exist
error occured in extension.applications.install2.cfm:91
The error message I receive is:
invalid component definition, can't find /install/Install
error occured in ExtensionManager.cfc:22
variable [INSTALL] doesn't exist
error occured in extension.applications.install2.cfm:91
Hi Andy,
Thanx for creating this extension. I installed it but I've having a few problems running it (I'm not very familiar with the cfspreadsheet tag so I may be doing something wrong). Can you contact me directly so I can send you the output I'm seeing?
Thanx!
Thanx for creating this extension. I installed it but I've having a few problems running it (I'm not very familiar with the cfspreadsheet tag so I may be doing something wrong). Can you contact me directly so I can send you the output I'm seeing?
Thanx!
@michael I've added your issue to https://github.com/andyj/RailoExtensionProvider/is... I think I know the issue and will get back to you
@sean I've DM you on twitter. Or you can just email me on my IM address if you want
@sean I've DM you on twitter. Or you can just email me on my IM address if you want
@michael im going to try and get hold of 3.2.003 but is it possible for you to try and run 3.2 final and give it a go on the same machine as well?
Just a note that Andy's recent update to the extension has fixed my issues! Thanx!
Andy, I'm trying to install this on my dev server, which is running 3.2.1.000. I added the provider, see it in the list and verifying it says OK. But under Applications I do not see the POI option, only the Railo provider extensions.
Any ideas?
Any ideas?
I am having exactly the same issue as Sean. The Provider verifies, but the Application does not show up. I am also running Railo 3.2.1.000.
I really need this functionality, so I'm hoping we can get this sorted out!
I really need this functionality, so I'm hoping we can get this sorted out!
@chris @sean Sorry for the late replies on this. This is a WEB context extension currently. From the info you've supplied I would assume you are looking under the server context?
Andy,
It appears just fine for me in the Web context.
Thanks for the clarification. I am a Railo newb, so I'm still learning the ropes of all of this.
It appears just fine for me in the Web context.
Thanks for the clarification. I am a Railo newb, so I'm still learning the ropes of all of this.
Yes, I am looking to use it in the server context. Any plans for that? Is it something I could easily install to a web context and then copy a few files around?
Thanks! Looks forward to giving it a shot.
Thanks! Looks forward to giving it a shot.
@sean @chris I do want to move it to the extension to the server level but I think while its still very much in the early part of testing its best to limit an possible issues to a single web instance.
Hi Andy,
Quick question. I know the original project assumed the POI jars would be in the class path, so it used createObject(). The new extension uses the javaLoader. So there is obviously a mix of both in the forked code. [ For example, when you create a new SpreadSheet component, the underlying POI workbook object is created with the old Railo jar, not POI 3.7 ]. Can I assume the Railo extension *should be* using the javaLoader for everything?
Also stupid question - I have run into a few small issues with the base CFPOI code. Should I ask you about those or ask on the CFPOI list? All this fork-ing, github stuff is new to me ;)
-Leigh
Quick question. I know the original project assumed the POI jars would be in the class path, so it used createObject(). The new extension uses the javaLoader. So there is obviously a mix of both in the forked code. [ For example, when you create a new SpreadSheet component, the underlying POI workbook object is created with the old Railo jar, not POI 3.7 ]. Can I assume the Railo extension *should be* using the javaLoader for everything?
Also stupid question - I have run into a few small issues with the base CFPOI code. Should I ask you about those or ask on the CFPOI list? All this fork-ing, github stuff is new to me ;)
-Leigh
Hi Leigh
The idea is to be using the new POI 3.7 for all of it. I've still got some tweaking to do there. Railo does use the POI lib for tags such as cfcollection,cfindex and cfsearch which is why the Javaloader is needed.
I have got your fork on github and hopefully over the weekend I'll look at it to go in to the main repos.
The idea is to be using the new POI 3.7 for all of it. I've still got some tweaking to do there. Railo does use the POI lib for tags such as cfcollection,cfindex and cfsearch which is why the Javaloader is needed.
I have got your fork on github and hopefully over the weekend I'll look at it to go in to the main repos.
Andy -
Thank you for the great hack! In order to enable the component, I had to apply a modification to the Spreadsheet.cfc, without removing dom4j-1.6.1.jar from the list of libraries to load using JavaLoader I always received the exception
org.dom4j.DocumentFactory cannot be cast to org.dom4j.DocumentFactory
Is this a known bug? I'm running on the latest BER of railo (.006)
-- Hansjörg
Thank you for the great hack! In order to enable the component, I had to apply a modification to the Spreadsheet.cfc, without removing dom4j-1.6.1.jar from the list of libraries to load using JavaLoader I always received the exception
org.dom4j.DocumentFactory cannot be cast to org.dom4j.DocumentFactory
Is this a known bug? I'm running on the latest BER of railo (.006)
-- Hansjörg
Hi, and thanks for the extension.
The path is verified OK in the Providers part, but when I go to Applications, nothing shows up, just the default Railo applications...
The path is verified OK in the Providers part, but when I go to Applications, nothing shows up, just the default Railo applications...
Just installed the extension on a Linux box with Railo 3.3.1.000 final installed and it worked perfectly first time. Really cool and helpful! Hope more features come soon for it.
@Jonathon - Glad to hear it. There are some new features brewing. Hopefully we can get another release together as soon as everyone's schedule calms down. If there are any features you would like to see, please feel free to submit an issue on github.
@Alex - Sorry for the delayed response. What version of Railo are you running?
@Hansjörg - Thanks for mentioning the conflict with dom4j. We will look into it.
@Alex - Sorry for the delayed response. What version of Railo are you running?
@Hansjörg - Thanks for mentioning the conflict with dom4j. We will look into it.
I'm trying to load the "Read_Into_HTML.cfm" from Leigh and I the following error
----------------
Railo 3.3.1.000 Error (java.lang.NoClassDefFoundError)
Message Could not initialize class org.apache.poi.openxml4j.opc.internal.unmarshallers.PackagePropertiesUnmarshaller
Cause java.lang.NoClassDefFoundError
Stacktrace The Error Occurred in
/var/confnet/bsc07/WEB-INF/railo/components/org/cfpoi/spreadsheet/Spreadsheet.cfc: line 169
167:
168: <cftry>
169: <cfset Local.exportUtil.process() />
170:
171: <cfif arguments.format eq "query">
called from/var/confnet/bsc07/WEB-INF/railo/library/tag/spreadsheet.cfc: line 125
called from/var/confnet/bsc07/$_Sys/railo_cfspreadsheet/cfspreadsheet/Read_Into_HTML.cfm: line 6
----------------
FYI I installed the extension in the WEB administrator
----------------
Railo 3.3.1.000 Error (java.lang.NoClassDefFoundError)
Message Could not initialize class org.apache.poi.openxml4j.opc.internal.unmarshallers.PackagePropertiesUnmarshaller
Cause java.lang.NoClassDefFoundError
Stacktrace The Error Occurred in
/var/confnet/bsc07/WEB-INF/railo/components/org/cfpoi/spreadsheet/Spreadsheet.cfc: line 169
167:
168: <cftry>
169: <cfset Local.exportUtil.process() />
170:
171: <cfif arguments.format eq "query">
called from/var/confnet/bsc07/WEB-INF/railo/library/tag/spreadsheet.cfc: line 125
called from/var/confnet/bsc07/$_Sys/railo_cfspreadsheet/cfspreadsheet/Read_Into_HTML.cfm: line 6
----------------
FYI I installed the extension in the WEB administrator
I'm trying to load the "Read_Into_HTML.cfm" from Leigh and I the following error
----------------
Railo 3.3.1.000 Error (java.lang.NoClassDefFoundError)
Message Could not initialize class org.apache.poi.openxml4j.opc.internal.unmarshallers.PackagePropertiesUnmarshaller
Cause java.lang.NoClassDefFoundError
Stacktrace The Error Occurred in
/var/confnet/bsc07/WEB-INF/railo/components/org/cfpoi/spreadsheet/Spreadsheet.cfc: line 169
167:
168: <cftry>
169: <cfset Local.exportUtil.process() ></cfset>
170:
171: <cfif arguments.format eq "query">
called from/var/confnet/bsc07/WEB-INF/railo/library/tag/spreadsheet.cfc: line 125
called from/var/confnet/bsc07/$_Sys/railo_cfspreadsheet/cfspreadsheet/Read_Into_HTML.cfm: line 6
----------------
FYI I installed the extension in the WEB administrator
----------------
Railo 3.3.1.000 Error (java.lang.NoClassDefFoundError)
Message Could not initialize class org.apache.poi.openxml4j.opc.internal.unmarshallers.PackagePropertiesUnmarshaller
Cause java.lang.NoClassDefFoundError
Stacktrace The Error Occurred in
/var/confnet/bsc07/WEB-INF/railo/components/org/cfpoi/spreadsheet/Spreadsheet.cfc: line 169
167:
168: <cftry>
169: <cfset Local.exportUtil.process() ></cfset>
170:
171: <cfif arguments.format eq "query">
called from/var/confnet/bsc07/WEB-INF/railo/library/tag/spreadsheet.cfc: line 125
called from/var/confnet/bsc07/$_Sys/railo_cfspreadsheet/cfspreadsheet/Read_Into_HTML.cfm: line 6
----------------
FYI I installed the extension in the WEB administrator
I'm trying to install this but I keep getting the following error in Railo Web Admin:
can't copy file [http://www.andyjarrett.co.uk:80/RailoExtensionProv...] to [C:\railo\tomcat\webapps\ROOT\WEB-INF\railo\extensions\2E1348EC3E0B5663D1A35ACDAA0E68C0\CFPOI\0.2.rep]
Read timed out
Anyone else having this problem? Is Andy's server down?
can't copy file [http://www.andyjarrett.co.uk:80/RailoExtensionProv...] to [C:\railo\tomcat\webapps\ROOT\WEB-INF\railo\extensions\2E1348EC3E0B5663D1A35ACDAA0E68C0\CFPOI\0.2.rep]
Read timed out
Anyone else having this problem? Is Andy's server down?
