I am happy to announce that the newest build of the POI Utility ColdFusion custom tags for creating highly formatted Microsoft Excel documents in ColdFusion now includes a ColdFusion MX7 compatible version. Dan Wilson of nodans.com has taken the existing tab library and retrofitted it to work with ColdFusion MX7. This is now included in a sub-directory of the latest build (coldfusion_mx7). Going forward, I will do my best to maintain this version of the tag library in parallel with any new updates that I make.
As a minor note, thanks to a suggestion by Dan Guy, I have also added the ability to set the print orientation of each Sheet tag.
Looking For A New Job?
Am I crazy? It looks like a few files here use REMatch(), which in CF7, gives:
Variable REMatch is undefined.
The error occurred in
path\CSSRule.cfc: line 376
You're not crazy, Spencer - I found the same issue. One quick workaround is to comment out the entire poi:class tag if you don't need the css classes.
Hey guys, I am working on fixing this. It should be relatively straightforward, I just haven't had the time.
There's more incompatible with CFMX7 than REMatch. Javacast(''Short") is CF8 only (sheet.cfm) and so is VARIABLES.ColumnsTag.ColumnIndex++ (column.cfm).
I finally got it working except for the styles. Would this FUNCTION allow it to work with CFMX7?
I am glad that Adobe is making strides to add shortcuts to CF8, but I wish that they would update CFMX as it is still in use and CF8-only scripts are in abundance.
NumberFormat is misspelled as NumberForamt
It is possible to expand the date formats to support mm/dd/yyyy ?
Also, is there a way that I am not seeing to support formulas?
If I set a cell as =SUM(E4:E6) the formula shows in the document as text, but if I go to the formula builder and hit enter it calculates.
This is wonderful as is, but of course if I could figure out how to add formulas it would be even sweeter.
I am working on formula support and the other CFMX 7 updates. Thanks.
It's very powerful tools for cf to create the excel.
But, can be support the "UTF-8" or "UTF-16" format?
Thanks very much..
I just wanted to say that this Utility has made my life 100 times easier.
Thank you so much for providing it,
Kudos from me too. At the moment I'm working on a project requiring output to multi-sheet XLS files, and the POI utility is just the ticket. Thanks to Ben and everybody involved.
Thanks guys, I really appreciate the positive feedback.
I'll give you a big bear hug next time I see you.
Im a novice coldfusion user and Im very happy use POI Utility, there are a minor bugs,
in CFMX 7:
a) Invalid CFML construct found
Change Column.cfm line 109
<cfset VARIABLES.ColumnsTag.ColumnIndex = VARIABLES.ColumnsTag.ColumnIndex++ />
<cfset VARIABLES.ColumnsTag.ColumnIndex = (VARIABLES.ColumnsTag.ColumnIndex + 1) />
b) JavaCast Type Short must be one of the following types ("int","long","float","double","boolean","string")
Change Sheet.cfm line 139 and 140
JavaCast( "Short", ...
JavaCast( "int", ...
c) Variable REMatch is undefined.
Change inside your cfm document...
"border-bottom".. or "border-top" from Poi Class:
Ben, Thanks very much..
I have updated the CFMX 7 version of the tags:
I never got my bear hug....
The frunk always gets in the way of a good bear hug.
Damn you Frunk! Damn you!!!