Re: Using Servlets to server Excel files over web???

Hi Ryan,
[Quoted] Here we've been doing that for a while with no problems at all. We just created a servlet that instead of HTML generates CSV text. Of course, it sets the content type to "application/vnd.ms-excel" instead of "text/html".
From the user point of view, the effect depends on the browser they are using. If they are using Netscape or IE 4.0, Excel starts and loads the file when they activate the URL of the servlet. If they are using IE 5.0, an Excel spreadsheet appears right in the browser's window.

Ryan wrote:

> I am working on a project using an Oracle database, Oracle Application
> Server (4.0.8.1) and need to have a way for the users to retrieve a
> report in .csv format so that they may easily 'download' the file and
> use it in Excel. I could do this in some PLSQL (Oracle native language)
> but would much rather do this using Java if possible. Anyone have any
> ideas, information, experience doing this? It would be much appreciated.
>
> Thanks,
> Ryan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jan 03 2000 - 12:54:09 CET