Community Member Profile

Recent Blog Comments By nathan kelly

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

  Posted on May 24, 2012 at 4:21 AM

  @Steve, Works for us on railo. Have you put all the jars into the ROOT\WEB-INF\railo\lib folder and restarted? or maybe your missing a jar? http://dl.dropbox.com/u/21421558/poi_xlsx_jars_... read more »

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

  Posted on Oct 13, 2011 at 8:54 AM

  @Emily, Things to look at: Do you have any other process acting on the file that might be locking it? Is this a large excel file? - has the POI action actually finished? Coldfusion logs > are there heap space errors or timeouts related to queries that might be running for this... read more »

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

  Posted on Oct 13, 2011 at 6:31 AM

  @emily - the readExcel method has a 'LOCAL.FileInputStream.Close();' on line 933 of POIUtility so if the read goes ok it should close with no problems internally. Is that line in your version?... read more »

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

  Posted on Jun 23, 2011 at 4:54 PM

  @Geert, jars and components for excel 2007 (xlsx) here (as posted further up for @Zubair) http://dl.dropbox.com/u/21421558/poi_xlsx_jars_and_cfc.7z nath... read more »

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

  Posted on Mar 29, 2011 at 9:44 AM

  @Zubair, try: http://dl.dropbox.com/u/21421558/poi_xlsx_jars_and_cfc.7z nath... read more »

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

  Posted on Jan 24, 2011 at 4:24 PM

  @Mallik - No reason why not. but I don't have CF 8 so I can't confirm either way. Install it on your development box and see what happens ;) We run CF 7 on java 1.6u23 JVM, so depends on the java version you have under coldfusion for POI 3.7 to work.... read more »

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

  Posted on Dec 30, 2010 at 7:26 AM

  With some changes, yes - the changes are in the comments above, but here is a zip package with all the new stuff in. http://www.2shared.com/file/Ryqvnzet/poi_xlsx_jars_and_cfc.h... read more »

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

  Posted on Jun 24, 2010 at 9:43 AM

  Slightly changed your POIUtility.cfc - lines: //line 1381 ColumnList = rereplace(ARGUMENTS.Sheets[ LOCAL.SheetIndex ].ColumnList,'[[:space:]]',"","all"), //line 1382 ColumnNames = rereplace(ARGUMENTS.Sheets[ LOCAL.SheetIndex ].ColumnNames,"\n\t\r","","all"), And //1399... read more »

• Calling Array Functions on ColdFusion Query Columns

  Posted on Dec 4, 2008 at 1:30 PM

  Yep in CF 7 it fails - i ended up changing my code to do this: the_array=arraynew(1); for(i=1;i lte the_query.recordcount;i=i+1){ the_array[i]=the_query[column_name][i]; } not as neat, and probably slower - but it worked at the time and keeps the boss happy... If... read more »

• Calling Array Functions on ColdFusion Query Columns

  Posted on Jan 23, 2008 at 12:22 PM

  another line sorts it - the_array=duplicate(the_query['column_name']); ArrayPrepend(the_array,the_query['column_name'][1]); i've got it in a CFC function so i can call it when needed - i guess it could be a udf too. Keep up the good work your website has been a great sourc... read more »

• Calling Array Functions on ColdFusion Query Columns

  Posted on Jan 23, 2008 at 10:45 AM

  You can duplicate columns directly into arrays as well using this syntax: contents_array=duplicate(a_query["the_column"]); this will preseve the empty cells of a column that would otherwise be ignored using: contents_array=listtoarray("#valueList(a_query.the_column)#"); BU... read more »