export to excel

Never mind - had an epiphany and figured it out as soon as I sent the message.

I'm trying to download a report into Excel for the first time and this thread has been helpful (I think?). The code seems to run just fine, but I'm not getting the window that pops up that would allow me to open/save the excel file. I used the last code set supplied by efecto747 to create the document. Any help would be appreciated.

David

Tks for you reply and help.
Looks like I have a different issue with <cfabort> and application.cfc
Before I found a site that told me to use the code above to pass <cfabort>
error
<cfif arguments.exception.rootCause eq
"coldfusion.runtime.AbortException">
<cfreturn/>
</cfif>

If I take this code out of the cfc.. works... but give me cfabort error.
coldfusion.runtime.AbortException at
coldfusion.tagext.lang.AbortTag.doStartTag(AbortTag.java:62) at
coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1908) at
cfsearchCustomer2ecfm2064181429._factor13

Do you know anything about this?
I will keep digging...
Rgds

Johnny



"insuractive" <webforumsuser@macromedia.com> wrote in message
news:emca28$qv3$1@forums.macromedia.com...
> Make sure you move the <cfsetting> command to the top of the page. I had
> success using the following code:
>
> <!--- Insert at top --->
> <cfsetting enablecfoutputonly="Yes">
>
> <!--- Building a dummy query to use as an example (you can ignore
> this) --->
> <cfset getStruc =
> QueryNew("customer,city,state,Zipcode,appearance,typeDesc,cfirstName,clastName,c
> title,cPhone,cExtension,cMobile,cFax,cEmail")>
> <cfset temp = QueryAddRow(getStruc, 1)>
> <cfset QuerySetCell(getStruc, "customer", "1", 1)>
> <cfset QuerySetCell(getStruc, "city", "testville", 1)>
> <cfset QuerySetCell(getStruc, "state", "tx", 1)>
> <cfset QuerySetCell(getStruc, "Zipcode", "55555", 1)>
> <cfset QuerySetCell(getStruc, "appearance", "1", 1)>
> <cfset QuerySetCell(getStruc, "typeDesc", "1", 1)>
> <cfset QuerySetCell(getStruc, "cfirstName", "Test", 1)>
> <cfset QuerySetCell(getStruc, "clastName", "User", 1)>
> <cfset QuerySetCell(getStruc, "ctitle", "Mr", 1)>
> <cfset QuerySetCell(getStruc, "cPhone", "555-5555", 1)>
> <cfset QuerySetCell(getStruc, "cExtension", "123", 1)>
> <cfset QuerySetCell(getStruc, "cMobile", "555-5556", 1)>
> <cfset QuerySetCell(getStruc, "cFax", "555-5557", 1)>
> <cfset QuerySetCell(getStruc, "cEmail", "testuser@somewhere.com", 1)>
> <!--- End Dummy data section --->
>
> <!--- Make the <CFHEADER> tag is all on 1 line --->
> <CFHEADER NAME="Content-Disposition" VALUE="inline;
> filename=contactsReport.csv">
> <!--- Notice the use of <cfoutput>'s below --->
> <CFCONTENT
> TYPE="application/unknown"><cfoutput>"Company","City","State","Zipcode","SalesRe
> p","Type","First
> Name","Last
> Name","Title","Phone","Ext","Mobile","Fax","Email"#chr(13)#</cfoutput>
> <cfloop
> query="getStruc"><cfoutput>"#customer#","#city#","#state#","#Zipcode#","#appeara
> nce#","#typeDesc#","#cfirstName#","#clastName#","#ctitle#","#cPhone#","#cExtensi
> on#","#cMobile#","#cFax#","#cEmail#"#chr(13)#</cfoutput></cfloop>
>
>
> Hope that helps!
>

Make sure you move the <cfsetting> command to the top of the page. I had success using the following code:

Hope that helps!

Tks for reply, I just try and it doesn't work.
Maybe I have to setup in different way???
Rgds

Johnny

<cfif IsDefined("url.downloadReport")>
<CFHEADER NAME="Content-Disposition" VALUE="inline;
filename=contactsReport.csv">
<cfsetting enablecfoutputonly="Yes">
<CFCONTENT
TYPE="application/unknown">"Company","City","State","Zipcode","SalesRep","Type","First
Name","Last Name","Title","Phone","Ext","Mobile","Fax","Email"
<cfloop
query="getStruc"><cfoutput>"#customer#","#city#","#state#","#Zipcode#","#appearance#","#typeDesc#","#cfirstName#","#clastName#","#ctitle#","#cPhone#","#cExtension#","#cMobile#","#cFax#","#cEmail#"#chr(13)#</cfoutput></cfloop>
<cfabort>
</cfif>

"insuractive" <webforumsuser@macromedia.com> wrote in message
news:embr4s$9ak$1@forums.macromedia.com...
> Have you tried using <cfsetting enablecfoutputonly="Yes">? You'd have to
> wrap
> all the text you want to actually output in <cfoutput> tags, which means
> changing <cfoutput query="getStruc"> to <cfloop query="getStruc">, but
> that may
> fix your problem.
>

Have you tried using <cfsetting enablecfoutputonly="Yes">? You'd have to wrap all the text you want to actually output in <cfoutput> tags, which means changing <cfoutput query="getStruc"> to <cfloop query="getStruc">, but that may fix your problem.