Is it possible the column name is case sensitive ? Alex
On 14 February 2012 16:48, Mats Stromberg <[email protected]> wrote: > Hej Hugo, > > That's correct, it just ends up as string (I suppose) but now I run into > another wierd problem. > > I have my Excel document as an object xlsObj > > Create an ArgumentCollection setting my column names... 37 columns in all > (field 1 is an empty column... > <cfset args = { > spreadsheet : "#xlsObj#", > sheet : 0, > columnnames : "field1, kundenname, ref_whr, ..." > } /> > > Creating an query using the SpreadsheetQueryread() > > <cfset qExcel = SpreadsheetQueryread(ArgumentCollection = args) /> > > and dumpng the Qery object > <cfdump var="#qExcel#" /> > > Output in the dump looks OK > > query [long version] > field1 Kundenname ref_whr zelle_aa ist_titel_prc > soll_zeller_aa_prc neu_titel_prc ... > 1 [empty string] SomeName CHF CH/Immob. 0.87 > 20 1.88 ... > > So far so good... > > It's a query but trying an cfoutput of the query doesn't work > > <cfoutput query="qExcel"> > #qExcel.kundenname#<br /> > </cfoutput> > > Returns trhe following error > > cfcatch struct > column 3 > detail Error at line 1, column 1 > errorcode [empty string] > extendedinfo [empty string] > line 54 > message qExcel.kundenname doesn't exist. > scriptline 1 > Not sure what's going on here... The SpreadsheetQueryread would have been > such a sweet function to solve my Excel Import... > Now I guest I have to go back to the looping through Columns and Rows and > read each cell again... > > /Mats/ > > -- > online documentation: http://openbd.org/manual/ > google+ hints/tips: https://plus.google.com/115990347459711259462 > http://groups.google.com/group/openbd?hl=en > > Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012 > -- Alex Skinner Managing Director Pixl8 Interactive Tel: +448452600726 Email: [email protected] Web: pixl8.co.uk -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012
