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

Posted June 10, 2008 at 9:21 AM by Ben Nadel

Tags: ColdFusion

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

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

Error: Typo
File: /coldfusion_mx7/poi/cell.cfm
Line: 82

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.

@Erik,

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

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

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.

@All,

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

@All,

I have updated the CFMX 7 version of the tags:

http://www.bennadel.com/projects/poi-utility.htm

@Spencer,

I never got my bear hug....

The frunk always gets in the way of a good bear hug.

Damn you Frunk! Damn you!!!

Post A Comment

Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Please review the following issues:

Author Name:
Author Email:
Author Website:
Comment:	Supported HTML tags for formatting: <strong>bold</strong>   <em>italic</em>   <code>code</code>
	Remember my information
	Subscribe to comments
	Send me a copy of this comment