OK - educate me here. What's to be gained using this method over CFX_Excel?
Dave
----- Original Message -----
From: Dave Watts <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: 'S.E.Fling' <[EMAIL PROTECTED]>
Sent: Thursday, June 29, 2000 9:55 PM
Subject: RE: outputting query results to Excel
> > > I'd like to write the results of a query to an excel
> > > spreadsheet, then allow the user to download it. I think I
> > > can handle the download part, but I'm not sure how to output
> > > the query results to Excel. Appreciate any and all clues, TIA.
> ....
> > Install Office on your web server. Use Visual Basic to write
> > a COM object (wrapper really) that calls on Excel. Then call on
> > your COM Wrapper using CFOBJECT.
> >
> > If you go this route, go buy the book "Instant ASP Components"
> > (yes, even though you are not using ASP this book has an exact
> > example of how to write this COM wrapper to use both Excel and
> > Word). ISBN:0-07-212552-7
>
> I'd second this recommendation if you're interested in automating Office
> apps via CF, even if you don't know VB. It's got examples using WSH, VB,
and
> VC++, so you can pick your poison. However, if you need to generate this
> stuff under heavy use, remember that OLE automation is relatively slow and
> resource-intensive.
>
> > A cheaper and less technologically advanced route may be to
> > simple output the query as a CSV file or tab delimited file and
> > let them convert.
>
> Sometimes low tech is the best approach. Unless they really, really need
to
> have an Excel spreadsheet - if, for example, you need to have Excel
> functions in addition to raw data - rather than just data they can read in
> Excel, I'd recommend simply generating CSV directly from CF. I've beaten
> this example to death, but it demonstrates generating CSV:
>
> http://www.figleaf.com/demo/mimetest/
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
