Skip to main content
Inspiring
May 13, 2014
Question

cfspeadsheet excludeheaderrow

  • May 13, 2014
  • 1 reply
  • 353 views

I use on Local CF 9.0.2

I used CFspreadsheet with excludeheaderrow

No problem

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.

Pierre.

    This topic has been closed for replies.

    1 reply

    plartsAuthor
    Inspiring
    May 14, 2014

    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.