Skip to main content
S
Sateesh
Participant
July 27, 2011
Question

excludeheader attribute of cfspreadsheet is not working?

  • July 27, 2011
  • 2 replies
  • 4196 views

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

    This topic has been closed for replies.

    2 replies

    M
    meanrat78
    Participant
    February 26, 2013

    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.

    glamorous_Wonder6C1C
    glamorous_Wonder6C1C
    Inspiring
    July 27, 2011

    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

    S
    SateeshAuthor
    Participant
    July 28, 2011

    Thnaks Sourav,

    But the problem is i dont know how amnt rows whether sheet contains.

    Any ways thanks for the updates.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices