Palyne, The HTML to XLS process is an expensive one - the limitations of this format become evident when working with large sets of data.
You can use comma-delimited or tab-delimited files instead of HTML files - however, you can only do straight text (no formatting). You could look at using the Excel COM object (probably not available on shared hosting, though) You could set up a DTS job that creates the spreadsheet, and either invoke it programmatically or schedule it. --- Billy Cravens ----- Original Message ----- From: "Palyne Gaenir" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 9:35 PM 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
