• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

excludeheader attribute of cfspreadsheet is not working?

New Here ,
Jul 27, 2011 Jul 27, 2011

Copy link to clipboard

Copied

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

Views

4.0K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Jul 27, 2011 Jul 27, 2011

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 28, 2011 Jul 28, 2011

Copy link to clipboard

Copied

Thnaks Sourav,

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

Any ways thanks for the updates.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 26, 2013 Feb 26, 2013

Copy link to clipboard

Copied

LATEST

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation