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: Nathan Dumar <email@hidden>
- Date: Wed, 23 Jun 2004 09:15:40 -0400
Good stuff ... better than my hack job of making a tab-delimited text
file to import. Thanks for asking this, Jonathan.
Nathan
On Jun 23, 2004, at 7:31 AM, Michael Engelhart wrote:
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 :^)
_______________________________________________
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.