Skip to main content
A
Anonymous
October 21, 2009
Question

Trouble creating Excel File

  • October 21, 2009
  • 5 replies
  • 1034 views

Hi

Here is the code I got and modified from the internet

<cfsetting enableCFOutputOnly="Yes">

<cfquery datasource="#dsn#" name="getInfo">
SELECT distinct route
  FROM empDB
  where route > 100 and route < 4999
  order by route asc
</cfquery>

<cfset tabChar = chr(9)>     
<cfset newLine = chr(13) & chr(10)>
<cfheader name="Content-Disposition" value="filename=pay1.xls">
<cfcontent type="application/msexcel">

<cfoutput>Street Number#tabChar#Street Name#newLine#</cfoutput>
<cfloop query="getFilms">
<cfoutput>#streetNumber##tabChar##streetName##newLine#</cfoutput>
</cfloop>

When I run the code, i get Error: "internet explorer cannot download math.cfm from www.brantnews.com"

anyone got any ideas why

Thanks

Craig

This topic has been closed for replies.

5 replies

A
Anonymous
October 27, 2009

Thanks alot everyone

I tried a few of the things and nothing by itsself worked but when I removed the cfcontent/cfheader I noticed a invalid field in one of the querys, once I removed that the process worked.

again, thanks alot.

Craig

M
Melvin T.
Participating Frequently
October 22, 2009

try:

<cfheader name="Content-Disposition" value="attachment; filename=yourfile.xls">

HTH

Melvin T.

A
Adam Cameron.
Inspiring
October 21, 2009

Does the code run without error (save the Excel file to disk instead of delivering it to the browser for the purposes of testing) if you run it without the <cfheader> / <cfcontent> lines?

--

Adam

D
Dan_Bracuk
Inspiring
October 21, 2009

If the template is named math.cfm, the problem might be that excel 2007 does not like excel content created this way.  There is a cfc out there that you can use to create actual excel files and this works a lot better.  To find it, google "coldfusion export to excel poi"

C
craigkaminsky
Inspiring
October 21, 2009

Craig,

A couple of things to try:

1. Change the type attribute of the cfcontent tag to either 'application/unknown' and/or 'text/plain'

2. The downside is that you'd have to re-write a bit of code but check out Ben Nadel's POI CFC project I use this utility for all Excel files. Basically, you can easily create an Excel file, write it to the server and provide a download link. It's worked consistently for me across browsers and applications.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices