Question about Emailing Excel file(.xls) from browser

[Qgh Rohgy <qu...@yahoo.com>]

Hello,

Kindly Let me know if this is feasible :-

I am displaying data from a Database table on the
browser in an excel format.
i.e by setting
response.setContentType("application/msexcel");

Once the User is OK with the data he has got, he wants
the same to be emailed to him in an excel sheet format
(i.e xls file).

My Question :-

Is it possible for me to get the excel file .xls from
the data displayed on the browser(which is also in
excel format).??

I know that if I set the 
response.setContentType("application/vnd.ms-excel");
I can give user the option to save or open the excel
file.

I do not want the user to save the file directly. The
file needs to be emailed to him along with some other
files.

Hence, again, my question is - is it possible to write
to an excel file directly from the browser excel
format.
How could this be done?

Thanks much,
qgh



__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

RE: Question about Emailing Excel file(.xls) from browser

[Michael Zalewski <za...@optonline.net>]

Are you asking if it is possible have a web application send an .xls format
file as an E-Mail attachment? Or are you asking if it is possible to
download an .xls which can be saved from the client? I guess I don't
understand what you mean by 'the browser excel format'.

Either one is possible. But I don't think you can prevent a user from saving
the .xls if you send it by setting
response.setContentType("application/msexcel")

Or are you wanting to download some initial data in a .xls file, have the
user make some additional changes, then save the modified .xls back to the
webserver?

To send the E-Mail attachment, check out commons Email (here at Jakarta).
You will need to instal Java-Mail on your web server, and give your Web
Server access to some SMTP mail server.

To have the user be able to save the sheet you send, you probably need to
implement Web-DAV.  Check out Slide (also here at Jakarta).

To control whether the sheet opens inside Internet Explorer or launches
Excel in another window -- that is a client browser setting. I think the
default is to open the sheet inside Internet Explorer, but it might change
with the various point releases and patches to IE.

-----Original Message-----
From: Qgh Rohgy [mailto:questanser@yahoo.com]
Sent: Tuesday, February 04, 2003 6:16 PM
To: poi-user@jakarta.apache.org
Subject: Question about Emailing Excel file(.xls) from browser


Hello,

Kindly Let me know if this is feasible :-

I am displaying data from a Database table on the
browser in an excel format.
i.e by setting
response.setContentType("application/msexcel");

Once the User is OK with the data he has got, he wants
the same to be emailed to him in an excel sheet format
(i.e xls file).

My Question :-

Is it possible for me to get the excel file .xls from
the data displayed on the browser(which is also in
excel format).??

I know that if I set the
response.setContentType("application/vnd.ms-excel");
I can give user the option to save or open the excel
file.

I do not want the user to save the file directly. The
file needs to be emailed to him along with some other
files.

Hence, again, my question is - is it possible to write
to an excel file directly from the browser excel
format.
How could this be done?

Thanks much,
qgh



__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org