Dirk

Recent Blog Comments By Dirk

• ColdFusion POIUtility.cfc Updates And Bug Fixes

  Posted on Oct 8, 2010 at 8:08 AM

  @Christophe, what you want? read or write an excel? i have never problems with the columorder. i use queries/excelfiles with 50+ columns and use POI to read and write them. keep in mind that every usage of queryname.ColumnList returns columnnames in alphanumerical order.... read more »

• ColdFusion POIUtility.cfc Updates And Bug Fixes

  Posted on Sep 1, 2010 at 7:10 AM

  and of course you should remove the old poi class files from [cfusion]/lib... read more »

• ColdFusion POIUtility.cfc Updates And Bug Fixes

  Posted on Sep 1, 2010 at 6:54 AM

  add XLSX support (tested with CF8) the poi api wich comes with CF8 is very old. download new poi api from http://poi.apache.org/download.html copy all jar-files (also from subdirectories) direct to [cfusion]/lib restart coldfusion changes in POIUtility.cfc in function ReadExcel() replace the... read more »

• Parsing CSV Values In To A ColdFusion Query

  Posted on Aug 31, 2010 at 5:06 PM

  @Greg: Your solution is not for all situations. 1. If one row have more columns then the header row have, you can't access this values nor see it in the dump of the result query. 2. Same problem is an empty column header. 3. GetMetaData() of the result query contains the old columnnames like COLUMN_... read more »