December's ColdFusion Developer's Journal has an article about feeding live data into Excel from a web server, entitled "Excel's Web Query". I haven't read it yet but this could be a good source of information.
That magazine is a great source of information anyway, for all levels. Thanks, Joe Kelly [EMAIL PROTECTED] ----- Original Message ----- From: "BILLY CRAVENS" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 20, 2001 9:39 AM Subject: Re: outputting in XLS > 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 > ------------------------------------------------------------------------- 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
