Thanks to all for the suggestions. I am going to play with the POI cfc and see if I can get my reports into it. The thing I'm excited about is the ability to create multi pages sheets. Thanks again for your help.
Scott Sledgister QSR Technology, Inc [email protected] 970-690-3501 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Alan Williamson Sent: Wednesday, December 24, 2008 4:12 AM To: [email protected] Subject: [OpenBD] Re: OpenBD and excel Chris thats a fantastic little tip. works a treat -- i have just had to do some reporting output, and i had all my stuff in a query. even if you just <CFDUMP> your query object, Excel will pick it all out beautifully. I'll add this to the WIKI Scott Sledgister wrote: > Thanks I'll give it a try > I just serve up an html table with headers to tell the browser its an > excel file > > <cfheader name="Content-Disposition" value='inline; filename="report.xls"'> > <cfcontent type="application/vnd.ms-excel" reset="true"> --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official blog @ http://blog.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
