cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Exit
search
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
1
Upvote

creating excel file from query

matthisco
Explorer ,
Nov 17, 2008 Nov 17, 2008
I'm trying to create a spreadsheet of contact names on the fly using the code attached. I have a few roblems with this though.

I'd like to download the file by clicking a link, do you know how I can do this? Currently it downloads it when you browse to the page.

Also, I have a cfoutput tag in the footer of my page, this gets included in the spreadsheet, do you know how I can eliminate this?

Thankyou
661
Translate
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
replies 4 Replies 4
latest latest Jump to latest reply
davidsimms
Contributor ,
Nov 17, 2008 Nov 17, 2008
"I'd like to download the file by clicking a link, do you know how I can do this? Currently it downloads it when you browse to the page."

Wouldn't one browse to the page by clicking a link? Seems like you've answered your own question.
Translate
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
matthisco
Explorer ,
Nov 17, 2008 Nov 17, 2008
In Response To davidsimms
Ah yes of course, sorry todays been hectic, my minds screwed.

Thanks for your reply
Translate
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
matthisco
Explorer ,
Nov 18, 2008 Nov 18, 2008
Does anyone know if formatting of the excel document is possible?

I would like to use the table header and split the window and free the frame.

Excel> Window> Freeze pane

Thankyou
Translate
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
Guest
Nov 18, 2008 Nov 18, 2008
LATEST
In Response To matthisco
Put this in the <HEAD> you'll have to google for what each of these are, I don't recall them all. I think you are interested in this particularly:
<x:SplitHorizontal>1</x:SplitHorizontal> and/or <x:TopRowBottomPane>1</x:TopRowBottomPane>

<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Actions with Bad Codes</x:Name>
<x:WorksheetOptions>
<x:FitToPage/>
<x:Print>
<x:FitHeight>999</x:FitHeight>
<x:ValidPrinterInfo/>
<x:HorizontalResolution>300</x:HorizontalResolution>
<x:VerticalResolution>300</x:VerticalResolution>
</x:Print>
<x:DoNotDisplayGridlines/>
<x:FreezePanes/>
<x:FrozenNoSplit/>
<x:SplitHorizontal>1</x:SplitHorizontal>
<x:TopRowBottomPane>1</x:TopRowBottomPane>
<x:ActivePane>2</x:ActivePane>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
</x:Pane>
<x:Pane>
<x:Number>2</x:Number>
<x:ActiveRow>1</x:ActiveRow>
<x:ActiveCol>1</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
Translate
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
ColdFusion User Guide
Open in a new window
Copyright © 2025 Adobe. All rights reserved.
Using the Community Experience League Terms of Use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices