3 Replies Latest reply: Feb 26, 2013 7:17 AM by meanrat78 RSS

    excludeheader attribute of cfspreadsheet is not working?


      Hi All,


      I am new to CF. Just i started working with CFSpreadsheet.

      I have one xlsheet which conatins the row header and i am reading xlsheet with query.

      what i want is i dont want to read 1st row(Header row).

      I tried with all options but i am not getting the things.

      Please help me.


      even though i update to my CF to  9.0.1.


      Please find the follwing the code snippet.


      <cfspreadsheet action="read"  src="#GetTempDirectory()#/msepdata_test1.xls"  excludeHeaderRow = "false"  sheet="1" query="queryData" />