I use on Local CF 9.0.2
I used CFspreadsheet with excludeheaderrow
on the server it is CF 9.0.0
and with same files , it does not accept : excludeheaderrow
So how to exclude the first line from an Excel file to read. (column headers).
here is the code :
<cfspreadsheet action="read" columnNames="emp_id,emp,policy,emp_cc,tdate,legacykey,pdate,etype,purpose,attendee,atype, title,company,amount" excludeheaderrow="yes" headerrow="1" query="nf_data" src="#data_file#" sheet="1">
Thanks for help.
I did an escape of first line in the loop.
<cfif currentrow is not 1>
It does work.
But why the behaviour of cfspreadsheet is different.
Which means, developping in local does garanty it works on Server.