poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Qgh Rohgy <questan...@yahoo.com>
Subject Question about Emailing Excel file(.xls) from browser
Date Wed, 05 Feb 2003 20:05:49 GMT
Hello,

Thanks Brian Glick  and Michael Zalewski for your
replies.
Unfortunately it doesnt answer my questions :(

I am a newbie to this whole reading writing excel and
also to POI. I am trying to find a best solution for
my problem.

I have tried to explain in detail by problem below...

Let me know if you need me to explain my poroblem in
further details.

Thanks much

===
By excel format on the browser,
I mean displaying the contents using
response.setcontent("application/msexcel");

Step 1: 
The user selects some parameters (from couple of
dropdowns) and makes a search. The database is
searched to match the paramters he has selected and
the results are dynamically displayed on in the excel
format on the browser. When the results are displayed,
on the same screen, the user can still make another
search - till the time he is happy with his searched
results.

Step 2:
The user then moves on to other screens to select some
other components.

Step 3:
Finally, after navigation to a couple of screens, he
wants the entire package to be emailed to him. i.e the
Excel Sheet in Step 1 and couple of other files.

Hence,
1) I cannot just display the excel from the server on
the browser. There are tons of other functionalities 
also like 'Searching using the dropdown parameters'
which have to happen on the same screen .

2) Now that the database has been queried for the
parameters and the results are got on the browser, I
do not want to make the same search on the database
just to create the excel sheet to be emailed.

Question:
Hence I ask, is it possible for me to create an excel
file automatically when the user moves on to Step2
from Step 1 above and finally email the same to him?
The excel file needs to be created without querying
the databse again and from the displayed data on the
browser.

I know that the user can still save the excel on his
machine anyways in Step 1 itself. We are fine with
that.
But I want to email him this file along with other
files in Step 3.



--- Brian Glick <B.Glick@Freightek.com> wrote:
> I think what you would want to do is the following:
> 
> 1) Create the xls file on the server
> 2) Serve the file to the browser
> 3) If the user likes the data, email the file that
> resides on the server
> 4) Delete the file from the server.
> 
> Brian Glick
> Freightek, Inc.
> (215) 887-6100
> b.glick@freightek.com
> 
> -----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
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> poi-user-help@jakarta.apache.org
> 



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

Mime
View raw message