Alan Johnson

Recent Blog Comments By Alan Johnson

• 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. Our litt... 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 »

• 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 »