You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by An...@faa.gov on 2008/11/14 18:19:10 UTC
IE hangs trying to open Excel
hello -
The resultset only has 6-700 rows that is displayed on the JSP, still, IE
just hangs when it's trying to open up Excel (there is plenty of memory
available). Anybody has any idea why...? Thanks a lot in advance.
Andrea
Andrea Abraham
Senior Systems Engineer
Obstruction Repository System
L-3 Titan Group
office:301-713-2920 ext.145
cell: 301-793-7049
Re: IE hangs trying to open Excel
Posted by David Fisher <df...@jmlafferty.com>.
It is likely that you need to do something like this:
response.setContentType("application/vnd.ms-excel" );
response.setHeader("Content-disposition",
"inline;filename="+filename);
before streaming out your file.
Also make sure your JSP has not output whitespace in front of your
Excel.
This is easy to do.
Here is the proper way.
<%@ page language="java" session="false" import="java.lang.*" %><%
response.setContentType("application/vnd.ms-excel" );
response.setHeader("Content-disposition",
"inline;filename="+filename);
// your code
%>
And here is the accidental whitespace way:
<%@ page language="java" session="false" import="java.lang.*" %>
<%
response.setContentType("application/vnd.ms-excel" );
response.setHeader("Content-disposition",
"inline;filename="+filename);
// your code
%>
If either of these clues fail you then you'll need get help from
someone who knows OC4J and/or struts. We use Tomcat and rolled our own
framework.
HTH,
Dave
On Nov 14, 2008, at 12:14 PM, Andrea.CTR.Abraham@faa.gov wrote:
> We're using OC4J, unfortunately (not the best behaving container). And
> yes, we're using POI to generate the workbook; also using Struts for
> framework, so a custom action is doing all that. So what is to
> blame...?
>
> thank you!
>
>
> Andrea Abraham
> Senior Systems Engineer
> Obstruction Repository System
> L-3 Titan Group
> office:301-713-2920 ext.145
> cell: 301-793-7049
>
>
>
> David Fisher <df...@jmlafferty.com>
> 11/14/2008 12:26 PM
> Please respond to
> "POI Users List" <us...@poi.apache.org>
>
>
> To
> "POI Users List" <us...@poi.apache.org>
> cc
>
> Subject
> Re: IE hangs trying to open Excel
>
>
>
>
>
>
> Hi -
>
> This sounds more like a web server issue. What is your servlet
> container? Are you using POI to create the workbook from within a JSP?
> If so that can be trouble because Excel is a binary format and JSP is
> text.
>
> In our experience we served up Excel OK with a JSP until we upgraded
> our Tomcat from 4.1.29 to 4.1.31. At that point the catalina connector
> for Tomcat got more strict and we had to take a servlet approach. I
> can share some servlet code if this is correct.
>
> Regards,
> Dave
>
> On Nov 14, 2008, at 11:19 AM, Andrea.CTR.Abraham@faa.gov wrote:
>
>> hello -
>> The resultset only has 6-700 rows that is displayed on the JSP,
>> still, IE
>> just hangs when it's trying to open up Excel (there is plenty of
>> memory
>> available). Anybody has any idea why...? Thanks a lot in advance.
>>
>> Andrea
>>
>> Andrea Abraham
>> Senior Systems Engineer
>> Obstruction Repository System
>> L-3 Titan Group
>> office:301-713-2920 ext.145
>> cell: 301-793-7049
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: IE hangs trying to open Excel
Posted by An...@faa.gov.
The problem is that the dialog box that would ask you if you wanted to
open it or save it, never appears. so you can't save it either.
Unless in the code I'd force the file to be saved - I will actually test
that, thanks. Then it narrows down the problem a bit.
Andrea Abraham
Senior Systems Engineer
Obstruction Repository System
L-3 Titan Group
office:301-713-2920 ext.145
cell: 301-793-7049
Ulf Dittmer <ud...@yahoo.com>
11/14/2008 01:43 PM
Please respond to
"POI Users List" <us...@poi.apache.org>
To
POI Users List <us...@poi.apache.org>
cc
Subject
Re: IE hangs trying to open Excel
Are there any problems opening the file if you have
the web app save the file, and then open it manually
using Excel or IE?
Ulf
--- Andrea.CTR.Abraham@faa.gov wrote:
> > The resultset only has 6-700 rows that is
> displayed on the JSP, still, IE
> > just hangs when it's trying to open up Excel
> (there is plenty of memory
> > available). Anybody has any idea why...? Thanks a
> lot in advance.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: IE hangs trying to open Excel
Posted by Ulf Dittmer <ud...@yahoo.com>.
Are there any problems opening the file if you have
the web app save the file, and then open it manually
using Excel or IE?
Ulf
--- Andrea.CTR.Abraham@faa.gov wrote:
> > The resultset only has 6-700 rows that is
> displayed on the JSP, still, IE
> > just hangs when it's trying to open up Excel
> (there is plenty of memory
> > available). Anybody has any idea why...? Thanks a
> lot in advance.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: IE hangs trying to open Excel
Posted by An...@faa.gov.
We're using OC4J, unfortunately (not the best behaving container). And
yes, we're using POI to generate the workbook; also using Struts for
framework, so a custom action is doing all that. So what is to blame...?
thank you!
Andrea Abraham
Senior Systems Engineer
Obstruction Repository System
L-3 Titan Group
office:301-713-2920 ext.145
cell: 301-793-7049
David Fisher <df...@jmlafferty.com>
11/14/2008 12:26 PM
Please respond to
"POI Users List" <us...@poi.apache.org>
To
"POI Users List" <us...@poi.apache.org>
cc
Subject
Re: IE hangs trying to open Excel
Hi -
This sounds more like a web server issue. What is your servlet
container? Are you using POI to create the workbook from within a JSP?
If so that can be trouble because Excel is a binary format and JSP is
text.
In our experience we served up Excel OK with a JSP until we upgraded
our Tomcat from 4.1.29 to 4.1.31. At that point the catalina connector
for Tomcat got more strict and we had to take a servlet approach. I
can share some servlet code if this is correct.
Regards,
Dave
On Nov 14, 2008, at 11:19 AM, Andrea.CTR.Abraham@faa.gov wrote:
> hello -
> The resultset only has 6-700 rows that is displayed on the JSP,
> still, IE
> just hangs when it's trying to open up Excel (there is plenty of
> memory
> available). Anybody has any idea why...? Thanks a lot in advance.
>
> Andrea
>
> Andrea Abraham
> Senior Systems Engineer
> Obstruction Repository System
> L-3 Titan Group
> office:301-713-2920 ext.145
> cell: 301-793-7049
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: IE hangs trying to open Excel
Posted by David Fisher <df...@jmlafferty.com>.
Hi -
This sounds more like a web server issue. What is your servlet
container? Are you using POI to create the workbook from within a JSP?
If so that can be trouble because Excel is a binary format and JSP is
text.
In our experience we served up Excel OK with a JSP until we upgraded
our Tomcat from 4.1.29 to 4.1.31. At that point the catalina connector
for Tomcat got more strict and we had to take a servlet approach. I
can share some servlet code if this is correct.
Regards,
Dave
On Nov 14, 2008, at 11:19 AM, Andrea.CTR.Abraham@faa.gov wrote:
> hello -
> The resultset only has 6-700 rows that is displayed on the JSP,
> still, IE
> just hangs when it's trying to open up Excel (there is plenty of
> memory
> available). Anybody has any idea why...? Thanks a lot in advance.
>
> Andrea
>
> Andrea Abraham
> Senior Systems Engineer
> Obstruction Repository System
> L-3 Titan Group
> office:301-713-2920 ext.145
> cell: 301-793-7049
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: IE hangs trying to open Excel
Posted by "Knudsen, Joe" <Jo...@state.mn.us>.
Is that just happening on some files and not others. I've had problems
with an Altiris Agent that cause Excel to open very slowly but not hang.
-----Original Message-----
From: Andrea.CTR.Abraham@faa.gov [mailto:Andrea.CTR.Abraham@faa.gov]
Sent: Friday, November 14, 2008 11:19 AM
To: user@poi.apache.org
Subject: IE hangs trying to open Excel
hello -
The resultset only has 6-700 rows that is displayed on the JSP, still,
IE
just hangs when it's trying to open up Excel (there is plenty of memory
available). Anybody has any idea why...? Thanks a lot in advance.
Andrea
Andrea Abraham
Senior Systems Engineer
Obstruction Repository System
L-3 Titan Group
office:301-713-2920 ext.145
cell: 301-793-7049
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org