Bill King
Member since Sep 15, 2009
- Profile: /members/4324-bill-king.htm
- URL: http://fusiondevelopers.com
- Comments: 4
Recent Blog Comments By Bill King
-
ColdFusion Component Wrapper For POI To Read And Write Excel Files
Posted on Dec 4, 2009 at 5:57 PM
@Ted, I don't think you will be able to do it that way. Try, simply looping over the new query presented by the POI wrapper, then insert a single line at a time into your database table as follows: <cfloop query="objSheet.Query"> <cfquery datasource="yourdsn" name="ittInsert"> ... read more »
-
ColdFusion Component Wrapper For POI To Read And Write Excel Files
Posted on Nov 19, 2009 at 2:32 PM
@Bob Dively, I don't think that would be the best solution (removing the code,) but you should be able to add AND isDefined('VARIABLES.RowHeight') AND Val( VARIABLES.RowHeight ) What do you think @Ben?... read more »
-
ColdFusion Component Wrapper For POI To Read And Write Excel Files
Posted on Sep 15, 2009 at 4:56 PM
Ben, This is working great when I use a spreadsheet created by Google docs, but when I use a sheet created in Excel or OpenOffice I am getting an error: Element SHEETDATA.QUERY.RECORDCOUNT is undefined in LOCAL. This seems to go away when I change the "HasHeaderRow = true" to false. Any thoughts... read more »