<CFCONTENT TYPE="application/vnd.ms-excel"> question

[Davo67]

I am using CF to retrieve specific records from a database and need it to be outputted as an Excel spreadsheet. Using <CFCONTENT TYPE=&quot;application/vnd.ms-excel&quot;> works ok. Is there any way that I can set worksheet formatting within CF so that when the page is downloaded as a spreadsheet using <CFCONTENT TYPE=&quot;application/vnd.ms-excel&quot;> these are already applied?

The sort of thing I could do with is setting orientation, page breaks, headers & footers and print ranges.

I've tried to use com and cfobject before but found it very confusing and unstable.

Many thanks

 

[brian512]

I was just doing almost the same thing. Within the <CFCONTENT ...> it was just an HTML table that excel dynamically turns into an excel spreadsheet. Other than very simple formatting (borders, etc.) I don't think its possible to do what you want using <CFCONTENT>, the excel COM object might be able to but I haven't done anything with that.

Brian