Re: Opening an application and sending data...

[Karthisanker.K.M,AMB Chennai]

Thanx Richards...It works but ... when I say "Open from it's current
location", it asks for the application with which to open the sheet... why
doesn't it open it with Excel sheet by default? Doesn't
response.setContentType("application/msexcel" ) suggest it to open it with
Excel...
I would also like to know how to format the data and to give it a colorful
look etc...
can u suggest a way.


U'rs,
Karthisanker K.M.

> -----Original Message-----
> From: Jim Richards [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, January 31, 2000 12:33 PM
> To:   [EMAIL PROTECTED]
> Subject:      Re: Opening an application and sending data...
>
> I think what you want to to have a stream of data sent from the server
> to the client, and have the client open the application with the
> data.
>
> The best way to do this is look at the content types that are boing sent
> when
> you have the response object being created, so where most of us have
>
>         response.setContentType("text/html");
>
> at the start of a sevlet, you'd want to have
>
>         response.setContentType("application/msexcel");
>
> or
>
>         response.setContentType("application/xlc");
>
> as the reponse then send the excel file ( file with an xls extension, not
> comma
> separated), as a stream ...
>
> If you are sending a CSV, or similar you'd send it with a different mime
> type,
> I can't find it at the moment, but look through your navigator
>
>         Edit > Preferences
>
> then
>
>         Navigator > Applications
>
> and you'll see the list of applications, their extensions and applications
> they are
> associated with ...
>
> If you are using Apache, look at the conf/mime.types file for more
> examples
> of mime types ...
>
>
>
>
>
> At 12:08 PM 31/01/00 +0530, you wrote:
> >Hi Friends,
> >I would like to know how a servlet can open an application like an excel
> >sheet and transfer data to it. Just as the servlet throws html and
> >corresponding data onto the browser, I would like to know if an
> application
> >can be opened and data sent to it. I know that an application can be
> opened
> >using exec method, but how can I send data to that application like data
> >that is picked from the database.
> >Please let me know.
> >Thanx
> >
> >
> >Karthisanker K.M.
> >
> >_________________________________________________________________________
> __
> >To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> >of the message "signoff SERVLET-INTEREST".
> >
> >Archives: http://archives.java.sun.com/archives/servlet-interest.html
> >Resources: http://java.sun.com/products/servlet/external-resources.html
> >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> >
> --
>  An army marches as fast as its slowest stomach.
>   Mr Grumpy - what are you on about?
>     http://www.cyber4.org/members/grumpy/index.html
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html