After over 2 years, cfHSSF has been updated. It has been done by Steven Durette and he did a really great job! From his email: I made a couple more additions and I set it up so that it would degrade gracefully if the version of POI isn't high enough to support the features. I also made a change to the way values are set in cells. Before a row was created every time a cell value was set. With newer versions of POI if a cell already existed in a row, it was wiped out when another cell in the same row was set. The new method first checks to see if the row exists and uses that. If the row doesn't exist then it creates it. The ability to put JPEG and PNG images into workbooks was added. This works with the POI included with CF9. If someone tries to use it that doesn't have a new enough version, it takes the cell where the image was to reside and places a message that the POI version doesn't support it. You can now stream the workbook directly to the browser instead of having to cr...

Posts - 56 (29 of them being in december) Comments - 60 (18 being my answers) Total views - 118758 (15280 in december) Unique views - 25415 (2910 in december) My open source projects downloads: 1939 1ssBlog - 351 cfWatcher2.1 - 324 cfFirewall - 256 cfWatcher1 - 203 cfHSSF - 201 cfSQLMaster - 138 mollom - 115 robots - 114 defensio - 79 yahooSiteExplorer - 75 1ssBlog1Update1 - 43 1ssBlog1Update2 - 40 Top 10 posts by views: 20725 - Making your Database fly 9978 - Parsing Large XML files 8964 - Presenting Mollom - a quality-assessment and spam-filtering service 5523 - ColdFusion 8 price madness 4953 - Want to see what your baby will look like? 3233 - Hack Alexa rating to see where ColdFusion (CFML) site are located 2708 - How to make your blog profitable 2482 - Change Your Life - Use Reality Transerfing! 2319 - What is this Transerfing of Reality anyway? 2104 - Using CTE (Common Table Expression) For SQL Recursion Top 10 posts...

Last night i was playing with a new pod that would show the download counts of my open source projects. And it looks like there was already 1066 downloads. It seem like a nice count to me. cfWatcher - 415, cfHSSF - 301, cfFirewall - 191, etc. The weird thing is that, in all this time, there was no comments on how it work or how it help someone in their work. And even no requests for improvements (except only a couple of emails with problems unzipping the files, problems running cfWatcher2 on Java 1.4 and maybe a couple of other emails). And i bet it's not because i or this open source projects are so perfect. :) So, the questions are: Did someone use any of this projects? Did any of this projects help someone in their work? Is there anything that would be good to be changed or added to this projects? or at least... is ANYONE happy or pleased with any of this projects? And if yes, why? ...

There was a request for some cfHSSF usage examples, so here are a couple: EXAMPLE 1: EXAMPLE 2: EXAMPLE 3: Select * From states EXAMPLE 4: Hope it helps :)...

While i will be trying to submit it to RIAForge, for now, cfHSSF.cfc can be downloaded from here. Enjoy....