Gabe

Recent Blog Comments By Gabe

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

  Posted on Jun 13, 2011 at 9:55 PM

  This is what I am using in the code: <poi:cell value="ROUNDUP((9*@avgmonthly#currentrow#-@total#currentrow#)/@casepack#currentrow#,0)*@casepack#currentrow#" type="formula" numberformat="#,##0" /> But what I get is a cell that contains "ROUNDUP((9*J3-H3)/R3,... read more »

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

  Posted on Jun 13, 2011 at 3:02 PM

  Ran into a weird issue. I am using this formula for one of the cells "=ROUNDUP((9*J3-H3)/R3,0)*R3" ... all the cellnames are variables but on the final outputted excel file the cell contains the formual text and not the final number. When I click into the cell and select the text and click... read more »

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

  Posted on Jun 10, 2011 at 9:52 AM

  Does anyone know if there is a way to get this code to handle excel files that are password protected (given you have the password)?... read more »

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

  Posted on Jun 8, 2011 at 6:37 PM

  @Mickey, That helped.... turns out the excel file I was testing with was saved as a Excel 2007 Wooksheet instead of an Excel Worksheet. Resaving the file in the correct format got the code to work correctly :)... read more »

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

  Posted on Jun 8, 2011 at 5:30 PM

  I am trying to get the cfc to work, but when I test it I get the following error: -------------------- Object Instantiation Exception. An exception occurred when instantiating a Java object. The class must not be an interface or an abstract class. Error: ''. -------------------- The error occurs... read more »

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

  Posted on May 31, 2011 at 8:01 PM

  @Mickey, Yep,.. feel silly now. Just needed the double quotes and it was working fine. These tools are great and they offer alot more freedom to do things than the old fashioned way of using table html to genrate the excel file.... read more »

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

  Posted on May 31, 2011 at 6:02 PM

  Does your POI tools support the HYPERLINK() formula within cells?... read more »