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
