If it's not time-sensitive data (if they don't have to see the most up-to-date information) you could set up a scheduled task in CF administrator to write the same table to an actual .xls file every night or so. Excel will read HTML content from a .xls and present it as an Excel spreadsheet just as it does when you do all of that CFCONTENT business.
Then you'd just have to link to the XLS. To recap, generate once every night (or whenever) and serve content from the disk without regenerating it. Take it easy David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Palyne Gaenir Sent: Wednesday, December 19, 2001 9:35 PM To: [EMAIL PROTECTED] Subject: outputting in XLS A report I'm outputting to XLS is from a logging table which even on a single day may have 5000++ records. I was taught to output to xls by using cfcontent and creating a simple table for output, which would put it in the spreadsheet (works well). The select query from the db I'm using takes around .5-.6 seconds when timed with cftick. But it can take 10 minutes to load into the browser/xls -- if it loads at all and doesn't just lock up my browser which it usually does. This is for one DAY of records, never mind I gotta provide a research firm several months of this data in xls format. I think maybe it's the gigantic table-to-xls. Is there a better way of doing this? Is there some delimited char I could use in the output under the cfcontent tag that would read into separate cells like the table does? I didn't want to output to delimited and then import to xls as that does require some review of the data and I didn't wanna review a couple hundred thousand records to be sure it was all perfect. Many thanks for any advice. I feel like I've learned more from people on this list in the last month than I ever have in six without the helpful folks here. Regards, Palyne ------------------------------------------------------------------------ - This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
