Community Member Profile

Recent Blog Comments By Alan Johnson

• POIUtility.cfc Examples For Reading And Writing Excel Files In ColdFusion

  Posted on Apr 28, 2009 at 1:20 AM

  POI was written for 97-2003. Microsoft changed the structure of Excel dramatically for 2007+ and so it will likely never work for 2007, unless a new POI arises from the project.... read more »

• Populating An Existing, Formatted Excel Document Using ColdFusion And POI

  Posted on Jul 10, 2008 at 3:59 PM

  If you have images in the excel doc, you might want to start by stripping those out first. Macros are usually okay to have in the file. Images (since CF7 and above) seem to cause issues.... read more »

• Populating An Existing, Formatted Excel Document Using ColdFusion And POI

  Posted on Jul 10, 2008 at 3:02 PM

  @Bret What version of Excel is your template saved as? Try to keep it Excel 97-2005 version, since we've found that is the most agreeable to be used with POI.... read more »

• Dynamically Evaluating Image Functions In ColdFusion 8

  Posted on May 9, 2008 at 12:52 PM

  @Ben Sometime I'll have to show you (or perhaps it'd be a worthwile article for other developers). A rules engine puts the capabilities of Cold Fusion in the business automation/workflow class of applications... and totally rocks. Plus there are a lot more things you can use it for too.read more »

• Dynamically Evaluating Image Functions In ColdFusion 8

  Posted on May 9, 2008 at 12:15 PM

  ColdFusion's Evaluate() is Godlike. It is the secret sauce for dyamanic rules engine driven applications. We use it extensively... If you're looking to build a rules based decision engine, you'll need this tool in your arsenal.... read more »

• CFHTTPSession.cfc For Multi-CFHttp Requests With Maintained Session

  Posted on Mar 10, 2008 at 11:29 PM

  I was trying to write something like this the other day... couldn't figure it out and gave up. But THIS IS TOO COOL. Thanks for the lesson. Can't wait to try it out.... read more »

• Populating An Existing, Formatted Excel Document Using ColdFusion And POI

  Posted on Oct 4, 2007 at 10:57 AM

  FYI... Also we've noticed that the best xls format to work with POI is Excel version 97-2003/2005... read more »

• Populating An Existing, Formatted Excel Document Using ColdFusion And POI

  Posted on Oct 4, 2007 at 10:11 AM

  @Eileen, We also found this to be the case with CF7... however, for some reason it would still work in CF6. Not all images, but it could still handle most of them. I haven't found any workaround for this in the later versions of Cold Fusion. alan... read more »

• Ask Ben: Selecting XML Attributes Given Other XML Attributes

  Posted on Sep 21, 2007 at 12:17 PM

  Ben, I was looking at doing this exact same thing. How would it work if I wanted to test/search on two variables say Brunette and age = 32... read more »

• POIUtility.cfc Examples For Reading And Writing Excel Files In ColdFusion

  Posted on Jul 26, 2007 at 9:42 AM

  Hi Ben -- IF I haven't told you in a while, you Rock. One wish list item here that I think could really add tremendous value to your tool would be to not only tell which worksheet to read/write to, but what cell range to read from. (ie. Read cells B15:E25)... Likewise with the write, to... read more »

• Using ColdFusion's CFLocation Tag For Inline Image SRC Attributes

  Posted on May 21, 2007 at 11:46 PM

  I've been pondering the same question too. Why does some email go into Junk folders while other does not. I'd also be interested in anyone's thoughts on this. Is it a ratio of text to images? An unsubscribe line?, how the images are handled within an email? Simpicity of the email, or compl... read more »

• Using ColdFusion's CFLocation Tag For Inline Image SRC Attributes

  Posted on May 17, 2007 at 10:57 PM

  Fernando, et. all I recently wrote an email tracker as part of a CRM system using this trick not too long ago. Unfortunately, Outlook doesn't automatically download the image so tracking only occurs when the image is downloaded. Do you know of anyway to force the image to download, so trac... read more »

• Am I A Senior Programmer?

  Posted on Apr 13, 2007 at 1:51 PM

  Dude, Don't sell yourself short.... and look at this wonderful community you've built. Rock on Ben Nadel!... read more »

• Populating An Existing, Formatted Excel Document Using ColdFusion And POI

  Posted on Feb 19, 2007 at 2:44 PM

  I'm blushing Ben. Thanks. I'm just glad it all worked ;*) .... Cheers!... read more »

• First Attempt At Excel Document Formatting Hooks Using ColdFusion And POI

  Posted on Feb 16, 2007 at 6:04 PM

  Ben, We have written some custom Java stuff to 'read and write' excel files that piggybacks off of POI. In our world (mortgage rates, etc...) on import we are reading 'range specific locations' on an excel worksheet and parse that information. For export, we drop blocks of data... read more »