> > 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.
