Antony

Recent Blog Comments By Antony

• Finally Bought Ayn Rand's Atlas Shrugged

  Posted on May 7, 2007 at 11:57 PM

  I found both the fountainhead and atlas shrugged to be really depressing. Spot on, and excellent reads, but depressing. On the plus side, though, I see I'm not the only person to spell Antony correctly!... read more »

• I Love That "Oh Wow!" Moment

  Posted on Mar 13, 2007 at 3:28 AM

  I had the opposite the other day. Live demo to client, error comes up. Error handler picks it up nicely, emails me the error. I jump into that - basically, our SQL server fell over as it ran out of space for logs!!!! Long story short - jumped onto Citrix, Remote Desktop-ed the SQL Server, made some... read more »

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

  Posted on Feb 19, 2007 at 10:34 PM

  Hi Ben I think the most powerful use of using an existing xls as a template is that you get to include charts. There's no way to use the poi stuff to create a chart, but you are supposed to be able to load data into the right places so that existing charts display with your dynamic series data. Ant... read more »

• How To Easily Format An Excel Document Generating With POI And ColdFusion

  Posted on Feb 13, 2007 at 11:53 PM

  Hi Ben Stumbled upon this at riaforge - thought you might find it useful. http://cfhssf.riaforge.org/... read more »

• How To Easily Format An Excel Document Generating With POI And ColdFusion

  Posted on Feb 12, 2007 at 10:04 PM

  Hi Ben I've defined styles in my poi wrapper, and then I say something like compCostsRep.addCell(4,Amount,"currency") where compCostsRep is the xls object, addCell is a function, 4 is the column number, amount is the value, and currency is the format. I prepared a bunch of formats (currency, tim... read more »

• ColdFusion Component Wrapper For POI To Read And Write Excel Files

  Posted on Feb 8, 2007 at 7:48 PM

  Yeah, sounds like we followed the same path. It's a great hammer to have in your toolkit, makes all the other excel generation options look decidely crap.... read more »

• ColdFusion Component Wrapper For POI To Read And Write Excel Files

  Posted on Jan 30, 2007 at 5:15 PM

  Hi Ben I looked into the POI stuff for Excel a while ago and came up with a bunch of methods for writing - didn't look into reading as I didn't need it at that time. I ended up with methods that created styles (date, currency, etc), write sheet headers and footers for printed output, freeze panes,... read more »