Mickey

Recent Blog Comments By Mickey

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

  Posted on Oct 13, 2011 at 9:15 AM

  @Emily, Aha! I think I just found something that might help you! It's been a while since I've had to make any updates so this slipped my mind but the template file I read from WAS getting locked and not released. I just found an edit I made to Ben's POI\document.cfm file that fixed it. It a... read more »

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

  Posted on Oct 12, 2011 at 4:16 PM

  @Ryan & Emily, My apologies... I am using POIUtility to generate Excel spreadsheets on demand from a database and the problems you described sounded very much like problems I had and solved during the write process. I only read in a template file and the rest is output to a new file. Sorry I co... read more »

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

  Posted on Oct 12, 2011 at 11:30 AM

  @Emily, Close the file output stream. This will release any locks on the file and finalize the process. This works for me <cfset objFileOutputStream.Close() />... read more »

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

  Posted on Oct 11, 2011 at 4:49 PM

  @Ryan, I believe I am using an earlier version that doesn't support Excel 2007. But have you tried explicitly defining the field type as a string? <poi:cell type="string" value="#yourvalue# " />... read more »