Re: Download of Database Into MS Excel File - How?
Re: Download of Database Into MS Excel File - How?
- Subject: Re: Download of Database Into MS Excel File - How?
- From: Michael Engelhart <email@hidden>
- Date: Wed, 23 Jun 2004 06:31:13 -0500
You can also just output a CSV stream in the response (and possibly
HTML since HTML tables can be read by Excel but I haven't tried that)
and just be sure you set the response header Content-Type to
"application/vnd.ms-excel". This doesn't actually output an Excel
file per se but it tells the browser to open it up in Excel which
achieves the same thing in many cases. YMMV.
There's also the "Content-Disposition" response header that you can set
to give the file a name with a value like:
"attachment; filename="some_file_name.xls"
I haven't worked enough in WO to know how you would implement streaming
a CSV into the response but it's pretty trivial using JSP/Servlets.
Mike
On Jun 23, 2004, at 3:38 AM, Giorgio Valoti wrote:
On 23/giu/04, at 09:29, Geoff Hopson wrote:
How you get the EOs from the database is up to you.
You might find the following set of classes useful when writing excel
files...
http://jakarta.apache.org/poi/
IIRC, Anjo Krank has integrated POI stuff with WO.
See <http://wonder.sourceforge.net/>
Hope this helps
Good luck.
Geoff
On Wednesday, June 23, 2004, at 03:52AM, Jonathan Fleming
<email@hidden> wrote:
How would I go about allowing a user to download the full content or
a
search result from the database into an MS Excel file?
An intended client needs to be able to get all their records or a
selection
of them from the database by simply clicking a download button after
having
filtered the records they want.
Jonathan :^)
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.