html to excel with cfcontent problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JeffHorne2 - 27 Apr 2006 20:40 GMT

I am attempting to allow a user to save the contents of a table created with a
cfquery into an Excel spreadsheet. Using <cfcontent> I am able to create the
spreadsheet fine, but the formatting is not right. Some of it is and some of
it is not. The bold on the header line doesn't happen, which I can live with,
but the landscape orientation does not and that is a bigger problem. I view it
fine in Excel 2003 but when I print preview or print it is portrait. I have
converted this code from ASP. It has the XML inside, so I kept it..

We are still on CF5. Not sure if there's a way to resolve this issue.

Thanks for any help on this.

Jeff

<cfsetting enablecfoutputonly="Yes">

<cfset filename = "Facets_Fix_Report_#fileDate#.xls">

<cfcontent type="application/vnd.ms-excel">

<cfheader name="Content-Disposition" value="attachment;
filename=#trim(filename)#">

<cfoutput>
<HTML xmlns:x="urn:schemas-microsoft-com:office:excel">
<HEAD>
<style>

</style>

</HEAD>

Reply to this Message

BKBK - 28 Apr 2006 09:19 GMT

What happens when you begin with

<cfset filename = "Facets_Fix_Report_#fileDate#.xls">
<cfheader name="Content-Disposition" value="inline; filename=#trim(filename)#">
<cfcontent type="application/vnd.ms-excel">
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel">
xmlns="http://www.w3.org/TR/REC-html40">
<HEAD>
...
etc.

Reply to this Message

JeffHorne2 - 28 Apr 2006 15:46 GMT

Well, I don't know XML, but when I placed <x:Name>#filename#</x:Name> using the
variable instead of a static text string, it worked and the Bold and Landscape
orientation worked.

Thanks,

Jeff:D

Reply to this Message

Webmaster Forum / ColdFusion / Advanced Techniques / April 2006

html to excel with cfcontent problem