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

    excludeheader attribute of cfspreadsheet is not working?

    Sateesh Community Member

      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" />

       

       

      Regards

      Sateesh