Programming Help

Web Development



What's Here?

  • Members: 149,500
  • Replies: 506,574
  • Topics: 79,827
  • Snippets: 2,666
  • Tutorials: 706
  • Total Online: 1,379
  • Members: 81
  • Guests: 1,298

Welcome to Dream.In.Code
Become an Expert!

Join 149,500 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,379 people online right now. Registration is fast and FREE... Join Now!




Exporting Queried Data To Excel

 
 Reply to this topicStart new topic

Exporting Queried Data To Excel
Joe K
6 Apr, 2007 - 07:25 AM
Post #1

New D.I.C Head
*

Joined: 6 Apr, 2007
Posts: 2


My Contributions
Hello, I would like to export the contents of queried dataset to Excel using a button. The only method that I found migrates to a new page. Any thoughts?
User is offlineProfile CardPM
+Quote Post

supersloth
RE: Exporting Queried Data To Excel
7 Apr, 2007 - 12:38 AM
Post #2

serial frotteur - RUDEST MEMBER ON D.I.C.
Group Icon

Joined: 21 Mar, 2001
Posts: 19,904



Thanked: 13 times
Dream Kudos: 2147483647
Expert In: being gentlemanly

My Contributions
You can export any data into excel by sticking the code
CODE

<cfcontent type='application/ms-excel' file="filename.xls">


at the top of your page. to do this you can make a form submit to a page that exports your query to excel. if you want it to look right only use one table, follow simple html rules and as little styling as possible and it will come out looking pretty decent.
User is online!Profile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/7/09 06:27PM
Invision Power Board v2.1.7 © 2009  IPS, Inc.
Licensed to: MediaGroup1

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month