there is a faq on this on the poi pages. but its mostly observations and workarounds rather than answers to your q.
-------Original Message------- > From: <[EMAIL PROTECTED]> > Subject: RE: IE loads Excel-Sheet twice > Sent: 22 Jul 2003 11:54:03 > > You might well be right - but that only intensifies the mystery : > > - why doesn't it send a 'HEAD' request? (i sniffed the packets - the > requests are almost identical GETs), and > > - why does it only do that after a bit of time? it certainly doesn't happen > on quick responses! and it doesn't seem to make the second request if a > huge file is sent back straight away, but still does it if a tiny file > takes a while... that's what led me to think it was some sort of a time out > > > > > > > > ������������������������������������������������������������������������������������������������������������������������������������������������ > [EMAIL PROTECTED] > ����������������������e.net��������������������To:������ [EMAIL PROTECTED] > ���������������������������������������������� cc:���������������������������������������������������������������������������������������������� > ����������������������22/07/03 03:54���������� Subject:��RE: IE loads Excel-Sheet twice���������������������������������������������������������� > ����������������������Please respond to���������������������������������������������������������������������������������������������������������� > ����������������������poi-user������������������������������������������������������������������������������������������������������������������ > ������������������������������������������������������������������������������������������������������������������������������������������������ > ������������������������������������������������������������������������������������������������������������������������������������������������ > > > > > You are mis-interpreting the reason for the double download. It has nothing > to do with a timeout. > > The first download is from IE, which examines the header of the file to > determine that the file really contains an Excel spreadsheet. > > The second download is from Excel itself, which may be embedded inside IE > or > launched in a separate window (it depends on registry settings). > > You will not get the double download if you open directly in Excel. (Did > you > know you can go into Excel, choose File | Open from the menu bar, and type > in a URL like > http://nagoya.apache.org/bugzilla/showattachment.cgi?attach_id=2551). In > this situation, the file gets downloaded only one time. > > Here is something that I can't figure out. It should work from the command > line as well. (Open a command window and give the command > > c:Program FilesMicrosoft OfficeOfficeExcel > "http://nagoya.apache.org/bugzilla/showattachment.cgi?attach_id=2551" > > This should work but actually downloads an error page. Probably because > Excel actually asks for > "http://nagoya.apache.org/bugzilla/showattachment.cgi?attach_id=2551.xls" > which Bugzilla does not understand. > > None of this trivia is really very important. But it may help you to > diagnose problems. One thing to consider - the first download may not > consume the entire output stream. IE closes the first download as soon as > it > determines that the file is valid for Excel. Another thing - IE and Excel > will often ignore whatever you have set for mime type. It determines that > the file is Excel by examining the output stream header. And the last thing > to consider is that you may not always get a double download. For example, > I > gave two methods of opening an .xls over the web (directly from Excel) and > neither will cause the double download. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 11:03 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: IE loads Excel-Sheet twice > > > I have indeed seen this behaviour - IE has some internal timeout which it > reaches on longer operations and then 'cleverly' tries to get it again... > > However, there are no simple ways of solving it, i've personally done it in > a completely async way (which might be a bit of an overkill), where browser > polls the page for the export, which performs the export in a threaded > manner, and only attempts to return the big file once it's ready. > > so, simplified: > > 1. > start exporting the file in a thread, get it's id and return that to the > browser with aim to refresh: > i.e > > > 2. > then in your jsp, just check if your thread's done (maybe saved its details > in some cache), if it is, simply return the content... if not.. go back to > step.1 > > - this way you give ie no chance of making you start the export twice, > (unless it takes a very long time to do step 1) > > ... hope that helps... > > > > > > > [EMAIL PROTECTED] > ����������������������.com�������������������� To: > [EMAIL PROTECTED] > ���������������������������������������������� cc: > ����������������������21/07/03 15:33���������� Subject:��Re: IE loads > Excel-Sheet twice > ����������������������Please respond to > ����������������������poi-user > > > > > > > For some reason IE sends a request twice. It was something I ran into as > well, however, I never ran into an issue where session variables were > unaccessible. So I have no idea what that could be. > > Christoph Jaeger wrote:Hi, > > I apologize if this is a bit off topic, but I thought someone on this > list may have experienced the same problems and found a solution > already. > > I use POI to generate reports from a database. POI is used in a servlet, > which serves the Excel sheet to a web-browser. > > Everything is fine for small sheets (several hundred to a few thousand > rows). The result is just as expected. But when I try to do a bigger > query (say, 7000 rows) IE behaves strangely: first a request is sent to > the server to generate the Excel file. This file is downloaded (as it > seems), but when the next page comes up in IE, showing Excel, the Excel > program sends a second request to load the sheet. This time, the session > information (included in a cookie) is "forgotten", and so the query does > not work (does only work for logged in users, but without session > information I can not determine the user). > > The same thing works without any problems on my Linux box using Galeon > as a web browser (and Gnumeric or Open Office to view the Excel sheet). > > Has anyone on this list already experienced a similar problem? > > Thanks a lot, > > Best Regards, > > Christoph J�ger > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------- > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > > > > > This communication is for informational purposes only.��It is not intended > as > an offer or solicitation for the purchase or sale of any financial > instrument > or as an official confirmation of any transaction. All market prices, data > and other information are not warranted as to completeness or accuracy and > are subject to change without notice. Any comments or statements made > herein > do not necessarily reflect those of J.P. Morgan Chase & Co., its > subsidiaries and affiliates. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > This communication is for informational purposes only.��It is not intended as > an offer or solicitation for the purchase or sale of any financial instrument > or as an official confirmation of any transaction. All market prices, data > and other information are not warranted as to completeness or accuracy and > are subject to change without notice. Any comments or statements made herein > do not necessarily reflect those of J.P. Morgan Chase & Co., its > subsidiaries and affiliates. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -------Original Message-------
