I think this is what you after. You could setup a xls as a db in CF and just query the data from the spreadsheet path.
1. Create an empty Excel spreadsheet (placeholder) 2. Create a System DSN for the spreadsheet in the server's ODBC Data Source Administrator. 3. Create an ODBC Socket data source in the ColdFusion Administrator, pointing to the ODBC DSN created in step 2. 4 Use the IN predicate within the query, specifying the path to the actual spreadsheet to be used. <cfquery name="test" datasource="dynamicXLS"> SELECT TN_ID FROM [CF$] IN '#path to your generated spreadsheet#' 'EXCEL 5.0;' </cfquery> Warmest Regards, Phillip B. Holmes http://phillipholmes.com 214-995-6175 (cell) -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, April 27, 2006 7:12 AM To: CF-Talk Subject: Re: File header and footer in excel spreadsheet created with cxcontent? I've not done page headers or footers in excel. But, what I would do is set up the page like you want in excel, and then save it as html. Find the applicable code and add it to your CF template. I've done that with excel number formatting to get numbers to display the way I want and such. On 4/26/06, Jeff Horne <[EMAIL PROTECTED]> wrote: > I've got a spreadsheet that is created with cfcontent using the results of a query against a database. Everything is great but I'd like to include a page header and footer in the spreadsheet. Just to be clear, the column headers print fine, I want to create a header with the spreadsheet title and a footer with our company name, copyright info, page info and generated date. I don't want to see the info until I select print preview or print out the spreadsheet. We're still on CF 5. > > Any thoughts on how to accomplish this would be great. > > Thanks, > > Jeff > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238858 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
