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 »
3 Comments

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


Feb 26, 2013 at 2:49 PM // reply »
11,238 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,238 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,238 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 20, 2013 at 4:38 PM
Using A Dynamic Column Name With ValueList() In ColdFusion
@Dana, Your confusion is well founded, since this is a very confusing features. In fact, it ONLY works if you use array notation. Meaning, that this: arrayToList( query[ "columnName" ] ) ... read »
May 20, 2013 at 4:34 PM
Using A Dynamic Column Name With ValueList() In ColdFusion
I was thinking chicken and the egg, I wouldn't have expected it to work in the valuelist going in I guess. Maybe I just need a beer, long day :) ... read »
May 20, 2013 at 4:29 PM
Using A Dynamic Column Name With ValueList() In ColdFusion
@Dana, That's if you're trying to reference a specific row. In this case, we're trying to reference the entire query column as one cohesive value. So, you are correct that if you wanted to output a ... read »
May 20, 2013 at 4:24 PM
Using A Dynamic Column Name With ValueList() In ColdFusion
I thought when you used array notation to reference queries you always had to have the row or it would throw a similar error as well? ... read »
May 20, 2013 at 11:45 AM
Using jQuery's Animate() Step Callback Function To Create Custom Animations
This is really useful. I found out that you don't actually have to use a dummy css property (surprisingly). To animate a property in a linear-gradient for instance I did this this.css('someLinearGra ... read »
May 20, 2013 at 10:51 AM
Using A Dynamic Column Name With ValueList() In ColdFusion
@Josh, Oh snap! You're totally right! I'm not sure I've ever tried that. I did know that you can call a number of other array-methods on ColdFusion query columns: http://www.bennadel.com/blog/167 ... read »
May 20, 2013 at 10:45 AM
Using A Dynamic Column Name With ValueList() In ColdFusion
@Ben - I believe you can achieve the same functionality with ColdFusion's built in ArrayToList() function. ArrayToList( users[ "id" ] ); ... read »
May 20, 2013 at 10:21 AM
My Experience With AngularJS - The Super-heroic JavaScript MVW Framework
Is there any error logging and handling framework in angularjs, if not then in what way I can do this. ... read »
InVision App - Prototyping Made Beautiful With Prototyping Tools