POIUtility.cfc Now Hosted On GitHub

Posted February 26, 2013 at 9:33 AM by Ben Nadel

Tags: ColdFusion

This is just a quick post to say that my old POIUtility.cfc is now hosted on GitHub. I cleaned the codebase up a little, adding some organizational folders; but, mostly, it was copied over as-is to GitHub. For those of you who have no idea what the POIUtility.cfc is, it's a ColdFusion component (and set of ColdFusion custom tags) that facilitated the reading and writing of native Microsoft Excel documents.




Reader Comments

Feb 26, 2013 at 10:16 AM // reply »
49 Comments

You haven't identified what license it is available as?


Feb 26, 2013 at 10:57 AM // reply »
2 Comments

Only the MX7 version? I'm stuck on CF8 - no cfspreadsheet for me yet. (Sure would come in handy right about now though!)


Feb 26, 2013 at 2:31 PM // reply »
6 Comments

I'm still using this on a cf8 project! Thanks again Ben.


Feb 26, 2013 at 2:49 PM // reply »
11,246 Comments

@Peter,

Ah, good call. I don't know very much about licensing. I'll put something in there.

@Michael,

There is a folder for CFMX7, but the main repository is for CF8/CF9, I think. The CF7 is there as a nice-to-have.

@Dana,

Awesome! Always thrilled to hear that :D


Feb 26, 2013 at 2:59 PM // reply »
2 Comments

@Ben,

I see it now! The code for the CF8/9 version is in the "lib" folder. Tricky! (Actually it's not that tricky... probably just means I'm a novice at the way Github projects are typically set up.)

Thanks for the reply - it let me know I needed to look a little more closely. Oh, and thanks for the awesome tool! Too often when people share something like that on the Internet, the main thanks they get is clueless people asking silly questions (or at best, clueful people asking insightful questions), which creates more work for the guy who was just trying to do folks a favor. It's great to know that even though cfspreadsheet is out there, you're still keeping this project alive for those of us who need it.


Feb 26, 2013 at 5:47 PM // reply »
49 Comments

Licensing is one of those things that can appear complex, but is really quite simple once boiled down.

I wrote the following a little while ago, it's slightly out of context, but good enough that I can't be bothered re-writing...

If you want to protect your investment for all users, use GPLv3 or above.

If you want to protect your investment for all users, but are pragmatic about the complexities of the world, use LGPLv3 or above.

If you don't care, use Apache License v2.0 or MIT License.

There are lots of other licenses, but many of them are (rough) variations of MIT or LGPL, with a sprinkling of extra legal waffle that just get in the way of programmers helping each other. Unless you want to contribute to a project using another license, you can ignore them.


Feb 26, 2013 at 6:10 PM // reply »
369 Comments

Thanks for letting us know, @Ben, and for this wonderful tool! I have used it many times and it was a big help! Much appreciate. :-)


Feb 26, 2013 at 7:39 PM // reply »
11,246 Comments

@Michael,

No problem at all, my man. I probably should have configured it a little more clear. Like "Examples" and "CF7-Examples" or something along those lines. I was just putting it up in a bit of a haste :)


Feb 26, 2013 at 7:40 PM // reply »
11,246 Comments

@Peter,

Ah, good stuff. That's a good start for me. I'll get to it.

@Anna,

It is my pleasure :D


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>







  • Help Wanted - Find Your Next ColdFusion Job
Ben Nadel's Company - Epicenter Consulting Recent Blog Comments
May 23, 2013 at 6:06 PM
The Girl Who Broke My Heart, And Made Me A Better Person
Good day,ladies and gentle men, my name is Dr AMADI the great spell caster in Africa, i have help so many people for different kind of problems,who say there is no solution to problems on earth, that ... read »
May 23, 2013 at 4:26 PM
ColdFusion QueryAppend( qOne, qTwo )
@Heather, Glad people are still getting value out of this! ... read »
May 23, 2013 at 3:49 PM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@WebManWalking, I meant the code at the bottom (not the video). I did try to experiment with an intermediary variable, like: value = users.id[ i ]; arrayContains( userIDs, value ); ... but t ... read »
May 23, 2013 at 11:06 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@Ben, Are you talking about As Number: YES As String: YES As Java: YES? If so, that's with 3 different ways of referencing the constant 1, not users.id[1]. Query object references(*) are what seem ... read »
May 23, 2013 at 9:55 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@Dan, According to the CF Admin, I'm running Java "1.6.0_45". As far as the DB column, in the database it's an INT. I'll see if I can dig into what CF sees it as. @WebManWalking, But h ... read »
May 23, 2013 at 9:49 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@Ben, I think the problem is that we're used to loose typing in ColdFusion, like JavaScript. If a value is a number but it's needed in an expression to be a string, noooo problem. I've encountered ... read »
May 23, 2013 at 9:47 AM
ColdFusion QueryAppend( qOne, qTwo )
You rock! Thank you, thank you, thank you!!! ... read »
May 23, 2013 at 5:19 AM
Ask Ben: Print Part Of A Web Page With jQuery
How to print also the background color of table cells and table lines ... read »
InVision App - Prototyping Made Beautiful With Prototyping Tools