POI Utility Now Has ColdFusion MX7 Compatible Tags (Thanks Dan Wilson!)
Posted June 10, 2008 at 9:21 AM
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.
Comments (17) | Post Comment | Ask Ben | Permalink | Other Searches | Print Page
ColdFusion CFCatch Tags Catch Exceptions Based On Type Hierarchy
jQuery UI 1.5 Released, Focus On Consistent API And Effects
Reader Comments
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
Posted by Spencer Strickland on Jun 12, 2008 at 5:16 PM
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.
Posted by Chris Smith on Jun 17, 2008 at 2:30 PM
Hey guys, I am working on fixing this. It should be relatively straightforward, I just haven't had the time.
Posted by Ben Nadel on Jun 17, 2008 at 2:34 PM
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?
http://badassery.blogspot.com/2007/01/coldfusion-regex-support-udfs-rematch.html
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.
Posted by James Moberg on Jul 8, 2008 at 8:27 PM
Error: Typo
File: /coldfusion_mx7/poi/cell.cfm
Line: 82
NumberFormat is misspelled as NumberForamt
Posted by Erik Goodlad on Jul 9, 2008 at 4:10 AM
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.
Posted by Erik Goodlad on Jul 9, 2008 at 5:32 AM
@Erik,
I am working on formula support and the other CFMX 7 updates. Thanks.
Posted by Ben Nadel on Jul 9, 2008 at 8:17 AM
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..
Posted by Eureka on Jul 9, 2008 at 9:24 PM
Hi Ben,
I just wanted to say that this Utility has made my life 100 times easier.
Thank you so much for providing it,
-Lyle
Posted by Lyle on Jul 16, 2008 at 12:16 AM
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.
Posted by Chris Smith on Jul 16, 2008 at 10:29 AM
@All,
Thanks guys, I really appreciate the positive feedback.
Posted by Ben Nadel on Jul 16, 2008 at 1:09 PM
I'll give you a big bear hug next time I see you.
Posted by Spencer Strickland on Jul 16, 2008 at 5:54 PM
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
VARIABLES.ColumnsTag.ColumnIndex
Change Column.cfm line 109
from:
<cfset VARIABLES.ColumnsTag.ColumnIndex = VARIABLES.ColumnsTag.ColumnIndex++ />
to:
<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
from:
JavaCast( "Short", ...
to:
JavaCast( "int", ...
c) Variable REMatch is undefined.
Change inside your cfm document...
Remove:
"border-bottom".. or "border-top" from Poi Class:
"<poi:class name="header"
that's all
Ben, Thanks very much..
Posted by Plutarco Gonzalez on Jul 17, 2008 at 2:26 PM
@All,
I have updated the CFMX 7 version of the tags:
http://www.bennadel.com/projects/poi-utility.htm
Posted by Ben Nadel on Aug 1, 2008 at 8:42 AM
@Spencer,
I never got my bear hug....
Posted by Ben Nadel on Aug 1, 2008 at 8:42 AM
The frunk always gets in the way of a good bear hug.
Posted by Spencer Strickland on Aug 3, 2008 at 1:22 AM
Damn you Frunk! Damn you!!!
Posted by Ben Nadel on Aug 3, 2008 at 12:42 PM
