RE: Here's a question to chew on

by "Ann Ezzell" <amcbainezzell(at)alum.mit.edu>

Date:	Fri, 17 Nov 2000 09:32:29 -0700
To:	"'Kortland, Brian'" <Brian.Kortland(at)AIG.com>, <hwg-techniques(at)hwg.org>
In-Reply-To:	NYCSEXC2
	todo: View Thread, Original


You can do it in ASP if the users have at least Excel 97 (and there
may be ways to do it for earlier versions, but I'm not familiar with
them).

Basically, you put this at the top of the page:

Response.ContentType = "application/vnd.ms-excel"

Then just send your output to a table -- you can do some amount of
formatting.


> -----Original Message-----
> From: Kortland, Brian
> Sent: November 17, 2000 8:22 AM

>
> Hi All,
>
> I have not seen this, and don't know if there is a utility or
> applet or
> something out there, but does anyone know of a way to dump
> query results
> into an excel file that can be downloaded.
>
> We have a bunch of intranet sites and we are using Cold
> Fusion to diplay
> query results. People are now asking us to come up with a way
> to allow users
> to take those same results and have them dump to an excel
> file or to a txt
> file.
>
> Anyone have an idea how to do this. It can be Cold Fusion,
> ASP or whatever.
> We just are curious if this is being done somehow.
>
> Thanks,
>
> Brian
>

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA