Skip to main content
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Charlie Arehart
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Charlie Arehart ( @carehart )

POI Utility Now Has ColdFusion MX7 Compatible Tags (Thanks Dan Wilson!)

By on
Tags:

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.

Reader Comments

10 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

2 Comments

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.

81 Comments

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.

2 Comments

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.

1 Comments

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..

2 Comments

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

2 Comments

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.

3 Comments

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..

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
Ben Nadel