OR code below Then sample output below HTH [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => TedJ [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> Download query results to Excel file - Macromedia ColdFusion

Download query results to Excel file - Macromedia ColdFusion

Hello, I am trying to create this reporting tool - where users can select the criteria and generate a montly report - which I wanted them to download to an excel file. Can someone guide me how to do this. Thanks JT...

  1. #1

    Default Download query results to Excel file

    Hello,

    I am trying to create this reporting tool - where users can select the
    criteria and generate a montly report - which I wanted them to download to an
    excel file. Can someone guide me how to do this.

    Thanks

    JT

    JethroTull Guest

  2. #2

    Default Re: Download query results to Excel file

    You might look into the CFCONTENT tag.

    <CFCONTENT TYPE="application/mcel">

    Phil
    paross1 Guest

  3. #3

    Default Re: Download query results to Excel file

    Try the 'stuff' below:

    ( write your CFQuery ) Then

    <cfheader name="Expires" value="#Now()#">
    Then below
    <!--- <cfcontent type="Application/Unknown"> this is a standard method --->

    OR code below

    <!--- <CFContent Type="Application/vnd.ms-excel"> This works IE5.0--->

    Then sample output below

    <table name="SaleExcel">
    <tr>
    <td>Product ID</td>
    <td>Product Name</td>
    </tr>
    <cfoutput query="SaleExcel">
    <tr>
    <td>#SaleExcel.ProductID#</td>
    <td>#SaleExcel.ProductName#</td>
    </tr>

    HTH

    TedJ Guest

  4. #4

    Default Re: Download query results to Excel file

    Thank you... it worked

    JT
    JethroTull Guest

Similar Threads

  1. Complex join = no results (for a query that shouldreturn results)
    By jchapman16 in forum Coldfusion Database Access
    Replies: 4
    Last Post: August 23rd, 10:49 PM
  2. Outputting query results to excel.. wierd!!
    By jjay@aus in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: April 15th, 06:17 AM
  3. Query results don't display properly in results table.IGNORE PREVIOUS
    By JoyRose in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: March 24th, 07:28 PM
  4. Query results don't display properly in results table.
    By JoyRose in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: March 24th, 07:17 PM
  5. Dinamt Table, cannot export sql query results to excel! Please help
    By IluDeR in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 21st, 11:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Product ID Product Name
#SaleExcel.ProductID# #SaleExcel.ProductName#