nathan kelly

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_and_cfc.7z for the pack. nathan... 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 th... 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.html This is from my (heavily modified) CF7 server install so you might not need all the jars included. @Ben - are y... 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 ColumnList = rereplace(ARGU... read more »