Skip navigation
Sateesh
Currently Being Moderated

excludeheader attribute of cfspreadsheet is not working?

Jul 27, 2011 2:04 AM

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

 
Replies
  • Currently Being Moderated
    Jul 27, 2011 3:53 AM   in reply to Sateesh

    Hi Saasthii123,

    <cfspreadsheet action="read" src="the file name to read" query="name of the query variable where you want to store the result" columnnames="the name of the coloumns tou want to show in query. for multiple coloumn name seperate them by comma"  rows="start row to end row"

    columns="The coloumn in sheet" sheet="sheet number" />

     

    I don't know about the attribute "excludeHeaderRow" . Please take look at following attributes.

    Rows=Here you will provide the range of row. Like a value "3-15" decide read 3rd row to 15th row of the xls sheet. Now if we consider that header row is the first row and total no mof row is 20, if want to avoid the header row then just put "2-20" in rows attribute.

     

    Thanks

    Saurav

     
    |
    Mark as:
  • Currently Being Moderated
    Feb 26, 2013 7:17 AM   in reply to Sateesh

    Well, it's an old post, but for people who search for the answer ,the answer is this. It's very simple and the poster almost had it. Except he had "excludeHeaderRow='false'". So this means, do NOT exclude headerrow. It should've read "exludeheaderrow='true'". This will only work if you have Coldfusion 9.01 or higher.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points