Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Matthew Bourke
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Matthew Bourke@gummatt )

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

By Ben Nadel on
Tags: ColdFusion

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

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.

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.

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.

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

Hi Ben,

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.

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:
"<poi:class name="header"

that's all

Ben, Thanks very much..