This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFE228.F114A190
Content-Type: text/plain;
charset="iso-8859-1"
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 have personally used the examples in that book as a roadmap to create
document generation objects that are callable from CF.
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.
You could also write a CFX that does that same thing as the COM wrapper.
But VB is quick and dirty....but runs fine in a server environment (oddly
enough, just like java is great for server components....though they both
suck IMO as client side languages).
--b
--------------------------------------------
Bryan D. Batchelder Work: 813-935-7100
Palm/Internet Developer Home: 727-547-1322
--------------------------------------------
ConnectWise, Inc. (www.ConnectWise.com)
2803 West Busch Blvd, Suite 204
Tampa, FL 33618
--------------------------------------------
-----Original Message-----
From: S.E.Fling [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 29, 2000 8:09 PM
To: [EMAIL PROTECTED]
Subject: outputting query results to Excel
Hi,
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.
sharon
----------------------------------------------------------------------------
--
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.
------_=_NextPart_001_01BFE228.F114A190
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: outputting query results to Excel</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>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.</FONT></P>
<P><FONT SIZE=3D2>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</FONT></P>
<P><FONT SIZE=3D2>I have personally used the examples in that book as a =
roadmap to create document generation objects that are callable from =
CF.</FONT></P>
<P><FONT SIZE=3D2>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.</FONT></P>
<P><FONT SIZE=3D2>You could also write a CFX that does that same thing =
as the COM wrapper. But VB is quick and dirty....but runs fine in =
a server environment (oddly enough, just like java is great for server =
components....though they both suck IMO as client side =
languages).</FONT></P>
<P><FONT SIZE=3D2>--b</FONT>
</P>
<P><FONT SIZE=3D2>--------------------------------------------</FONT>
<BR><FONT SIZE=3D2>Bryan D. =
Batchelder Work: =
813-935-7100</FONT>
<BR><FONT SIZE=3D2>Palm/Internet Developer Home: =
727-547-1322</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
<BR><FONT SIZE=3D2>ConnectWise, Inc. (www.ConnectWise.com)</FONT>
<BR><FONT SIZE=3D2>2803 West Busch Blvd, Suite 204</FONT>
<BR><FONT SIZE=3D2>Tampa, FL 33618</FONT>
<BR><FONT SIZE=3D2>--------------------------------------------</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: S.E.Fling [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FON=
T>
<BR><FONT SIZE=3D2>Sent: Thursday, June 29, 2000 8:09 PM</FONT>
<BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT>
<BR><FONT SIZE=3D2>Subject: outputting query results to Excel</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Hi,</FONT>
</P>
<P><FONT SIZE=3D2>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</FONT></P>
<P><FONT SIZE=3D2>results to Excel. Appreciate any and all clues, =
TIA.</FONT>
</P>
<P><FONT SIZE=3D2>sharon</FONT>
</P>
<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
---------------</FONT>
<BR><FONT SIZE=3D2>Archives: <A =
HREF=3D"http://www.eGroups.com/list/cf-talk" =
TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk</A></FONT>
<BR><FONT SIZE=3D2>To Unsubscribe visit <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/cf_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/cf_talk</A> or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01BFE228.F114A190--
------------------------------------------------------------------------------
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.
