We got round this by making it into a two stage process, asking the user to
download the file rather than squirting it straight to them:
<!--- create file and output field headings --->
<cffile action="write"
file="#path#RegisteredUsers.xls" output="Name
Title Email Date_Added">
<!--- append query results to file --->
<cfloop
query="GetUsers">
<cffile action="append" file="#path#RegisteredUsers.xls"
output="#Name#
#Title# #Email# #Date_Added#">
</cfloop>
Worked fine
Ben
----------------------------------------------------------
Ben Whalley, Radley Yeldar
326 City Road, London, EC1V 2SP
----------------------------------------------------------
0207 7130038
[EMAIL PROTECTED]
www.ry.com
----------------------------------------------------------
Date: Mon, 10 Sep 2001 15:55:31 +1000
From: "zap005" <[EMAIL PROTECTED]>
Subject: Create Excel document
Message-ID: <[EMAIL PROTECTED]>
Hi There,
My hosting provider does not allow cfcontent or COM objects.
I need a way to insert the excel document type into the header of a document
without using cfcontent,
or launching excel on the server...does anybody have any ideas.
Thanks
Doug
-----------------------------------------------------------------------
* This message has been processed by MailGuard SMTP from NET-TEL
* Computer Systems Ltd. See <http://www.mailguard.co.uk>.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
