cfspreadsheet for Railo update
I have done a minor update to the cfspreadsheet extension thanks to Sean Corfield and his preliminary testing. Please let me know if you are using/testing it as the more feedback the better. I know that I really do need to write some MXUnit tests when I get the time so that is on the list and don't forget you can log issues at https://github.com/andyj/RailoExtensionProvider/issues
To install (to update go to step 2 and it should say an update is available)
- 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 is open at https://github.com/andyj/RailoExtensionProvider
Comments
Awesome! My initial tests pass now! I'll continue to play and let you know if I hit anything else. Great work Andy!
Hi Andy,
Not sure if this is an issue with the extension or the POI, but when I load a spreadsheet with some empty values in the entire row, it seems to misalign the columns
For example, if I have the following columns:
[discountcode,name,price,weight,RRP]
If discountcode is totally empty (except for the header) when I load the spreadsheet, the name data is in the discountcode column - the price data is in the name column, and the RRP column is empty. So everything shifts over 1 column.
Not sure if this is an issue with the extension or the POI, but when I load a spreadsheet with some empty values in the entire row, it seems to misalign the columns
For example, if I have the following columns:
[discountcode,name,price,weight,RRP]
If discountcode is totally empty (except for the header) when I load the spreadsheet, the name data is in the discountcode column - the price data is in the name column, and the RRP column is empty. So everything shifts over 1 column.
@tom if its not too rude can you email me the file you are trying to load and I'll have a look at it for you. My email address is mail@{my domain name}.co.uk
Does this work with Railo 3.1? I'm currently attempting to move my main CF app over to Railo and found that the POIutility.cfc solution I've been using for a while, to write out Excel files, isn't functioning there - thought maybe this would be a workable alternative - but I'm having trouble getting it installed.
I'm getting this error:
java.lang.StackOverflowError
error occured in installFolder.cfc:79
77: message = ""};
78: var ssDir = "";
79: var serverPath = expandPath('{railo-web-directory}');
80:
81: processResult.status = deleteAsset("directory", "#serverPath#/components/org/cfpoi");
I'm getting this error:
java.lang.StackOverflowError
error occured in installFolder.cfc:79
77: message = ""};
78: var ssDir = "";
79: var serverPath = expandPath('{railo-web-directory}');
80:
81: processResult.status = deleteAsset("directory", "#serverPath#/components/org/cfpoi");
@scott. I can't think of a reason it wouldn't work with 3.1 but its only been tested with 3.2+
Is there a reason you cannot update to the latest stable version of Railo?
Is there a reason you cannot update to the latest stable version of Railo?
Is it possible to read XLSX files while using a Railo server instead of Adobe?
I'm using cfspreadsheet on Railo and it works beautifully with XLS, but when I try XLSX it throws an error.
I don't want to leave Railo just because of this, but my application NEEDS to read XLSX files.
I'm using cfspreadsheet on Railo and it works beautifully with XLS, but when I try XLSX it throws an error.
I don't want to leave Railo just because of this, but my application NEEDS to read XLSX files.
Andy, I have your extension provider added but I'm not seeing CFPOI as an application available to install. I'm running Railo 3.3.0.022 at the moment and have looked in both server and web contexts for the option to install. Any ideas?
Hi again -
Got this functioning on an install of Railo 3.2.3. Works pretty slick.
One issue I have - doesn't seem to be a way to set column headers via the tag. Must one simply create a spreadsheet with one row, containing the column headers desired, then append to it with the main data write?
Got this functioning on an install of Railo 3.2.3. Works pretty slick.
One issue I have - doesn't seem to be a way to set column headers via the tag. Must one simply create a spreadsheet with one row, containing the column headers desired, then append to it with the main data write?
Nevermind previous comment - puzzled it out with the various CF spreadsheet functions. :P
@Alex Pizarro - Did you ever figure out if Railo can read xlsx?
