Is there a better way to do this?
<cfspreadsheet action="read"
src="file.xls"
name="spreadsheet">
<cfspreadsheet action="read"
Src="file.xls"
Headerrow="1"
Rows="2-#spreadsheet.rowcount#"
Query="spreadsheet">
Basically I want to end up with a query that has the first row of the
spreadsheet as column names but does not have it as a row in the query
itself. I'd like to avoid reading the file twice to do it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335321
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
