RE: IE loads Excel-Sheet twice

2003-07-22 Thread max . nam
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

RE: Excel File Download using JSP

2003-07-22 Thread Kartik Money
Hi, My question (to anyone out there that might have a clue) is - Is there any way you can determine if any of these file formats is password protected? If so, could you please send me some sample code that might help me? Basically what I want to do is if any of these files is password protected

Re: RE: IE loads Excel-Sheet twice

2003-07-22 Thread Avik Sengupta
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

Password Protected MS Office Files

2003-07-22 Thread Kartik Money
Hi, My question (to anyone out there that might have a clue) is - Is there any way you can determine if any of these file formats is password protected? If so, could you please send me some sample code that might help me? Basically what I want to do is if any of these files is password

Re: IE loads Excel-Sheet twice

2003-07-22 Thread Andrew C. Oliver
You are setting the mimetype to application/vnd.ms-excel (or something very close to that...I forget the exact string)? I always found that the different buggy versions of IE worked best when I mapped *.xls to a servlet, used the /folders/as/parameters and passed the mime type. Each release of

Re: RE: IE loads Excel-Sheet twice

2003-07-22 Thread max . nam
I wasnt' really asking questions - these were simply in reply to another user's comment on my comment about POI. And I do think it's quite relevant to this list, since server/ web-based uses of POI *must be* the primary applications as there are very few alternatives. -max

RE: IE loads Excel-Sheet twice

2003-07-22 Thread Christoph Jaeger
Yes, I set the mime type to application/vnd.ms-excel. Additionally the request looks like /path/to/reports/report.xls?parameter1=1parameter2=2, where /path/to/reports/* is mapped to my Excel sheet producing servlet. I think I found out that with this combination it works* for IE (which seems to

EXCELL DATE

2003-07-22 Thread prasad guru
Hi, Can any one help me in finding exact cell Type either Datecell or Numeric cell.. I tried with both 1. if (HSSFDateUtil.isValidExcelDate(dCellValue)) then Cell Containd Date Value It takes numerical values as Date, say if (HSSFDateUtil.isValidExcelDate(22.4)) returns

Re: IE loads Excel-Sheet twice

2003-07-22 Thread Andrew C. Oliver
Right, the problem is that some versions of IE ingore the mime type entirely. They use the file extension. Which is in this case .xls?parameter1=1parameter2=2 so they need to read part of the file. If you do /path/to/reports/parameter1/value1/parameter2/value2/bla.xls then the extension will

RE: IE loads Excel-Sheet twice

2003-07-22 Thread Savino, Matt C
FYI - there is a lot on the FOP-user mailing list about this issue. Here is the FAQ portion: http://xml.apache.org/fop/servlets.html#ie But if you have dynamic content and need to set IE to not cache, I don't think any of these suggestions will work by themselves. Here is our solution as

FW: IE loads Excel-Sheet twice

2003-07-22 Thread Michael Zalewski
BTW, I got it to work from the command line. c:\Program Files\Microsoft Office\Office\Excel http://nagoya.apache.org/bugzilla/showattachment.cgi?attach_id=2551bill_ga tes=dummy.xls I used 'bill_gates' as a dummy parameter :) If you drop off the bill_gates=dummy.xls, (which means nothing to

RE: IE loads Excel-Sheet twice

2003-07-22 Thread Michael Zalewski
IE does not do a HEAD request because it is checking to see that the file is really an Excel file. To do so, it must examine some part of the header. A HEAD request does not allow IE to examine the file contents. BTW, IE often uses a GET request where you would expect a HEAD request. I think

what is the Ptg?

2003-07-22 Thread hotmail
Hi, I found a lot of class names have included the word Ptg, for example, org.apache.poi.hssf.record.formula.Ptg.AddPtg. So Who can tell me the meaning of the word. Thanks Regards Alan

How about the chat?

2003-07-22 Thread hotmail
Hi,everybody: I have two request: 1.I want to use the POI to write my data to a existed Excel file. 2.I want to use the POI to draw a pie chat in that file, according to the data I just wrote. Only the first I can handle, please help me to accomplish the second. Thank a lot for community