help for large content.

2002-06-11 Thread 박남규
Hello, Rainer Klute. I use POI well for access to Excel. It's great for user. But there is one problem. I want to write 4 line(row)s by Excel Format using POI. It may be 300,000 cells. Then, when executes, JVM has many memories and finally memory out. It's first time for me to be out of m

RE: Open an EXCEL file from IE: An example

2002-06-11 Thread Michael Zalewski
I'm not understanding the goTo method. After writing the bytes from a HSSFWorkbook, you forward the request (with a closed outputstream) to "Nombre.xls"? This should cause the File Serving Servlet to send the file "Nombre.xls", relative to your web application's document root. Not sure what happen

RE: case studies wanted.

2002-06-11 Thread Michael Zalewski
How big does the table have to be before HTML import no longer works? I've seen it work for 1000 rows or so. Haven't really tried to stretch it to the limit though. -- To unsubscribe, e-mail: For additional commands, e-mail:

Re: Need help getting HSSF up and running

2002-06-11 Thread Andrew C. Oliver
oooh, you may need to recompile POI under JDK 1.2.2. We intend to work under 1.2.2, but I admit that I don't test it there. In general we compile under 1.3.1_xx -Andy Glen Stampoultzis wrote: >Nope. I don't even have it installed. > >-- Glen > > >- Original Message - >From: "Avik

Re: Open an EXCEL file from IE: An example

2002-06-11 Thread Andrew C. Oliver
Might be able to help more if you ran an org.apache.poi.dev.BiffViewer on the files and compared them. I wonder if this is some kind of little endian big endian thing. What version of POI btw? -Andy Torbert Brian IT56 wrote: >I am using Websphere Application Server 3.5.3 and using the code

Re: Need help getting HSSF up and running

2002-06-11 Thread Glen Stampoultzis
Nope. I don't even have it installed. -- Glen - Original Message - From: "Avik Sengupta" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 12, 2002 1:15 PM Subject: RE: Need help getting HSSF up and running > Glen, is the poi-1.5-final compiled under 1.4 by any chanc

RE: Need help getting HSSF up and running

2002-06-11 Thread Avik Sengupta
Glen, is the poi-1.5-final compiled under 1.4 by any chance? Thats known to give problems -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 11:01 AM To: [EMAIL PROTECTED] Subject: Need help getting HSSF up and running Hello. I'm try

POI usage with Word

2002-06-11 Thread Martin van den Bemt
Hi, (Andrew, maybe this is going to be a nice case study..) We are currently looking at a refactoring of our corespondence module in our softwarepackage. Since the main stream use at our (potential) customers is Ms word, a lot of focus from the "sales' people is towards that. I "hate" the ide

RE: Open an EXCEL file from IE: An example

2002-06-11 Thread Torbert Brian IT56
I am using Websphere Application Server 3.5.3 and using the code below. The excel file opens but it is corrupted and displays a bunch of binary data. What is strange is when I run this application in VAJ3.5.3's WTE everything works fine. Does anyone have any ideas? Are there compatibility issue

Re: case studies wanted.

2002-06-11 Thread Andrew C. Oliver
Michael Zalewski wrote: >>Early on, to my suprise, most folks were using it for reading, but >>I think that was mostly a perception/marketing problem. >> >> Thanks for your reply. See my responses in-line. This may sound defensive, its not. I just want to clarify the use cases a bit. >I

RE: Need help getting HSSF up and running

2002-06-11 Thread Hoffman, Jason
Well, I'm not sure about the specific problem you're having, but I can say that HSSF does RUN okay with JDK1.2.2. That said, I cannot compile on JDK1.2.2 using the POI 1.6 source release. I receive compiler errors about explicit casts. -Original Message- From: [EMAIL PROTECTED] [mai

Need help getting HSSF up and running

2002-06-11 Thread Isaac.Goldstein
Hello. I'm trying to get HSSF working and I get the following message at compile-time: "cannot access class org.apache.poi.hssf.usermodel.HSSFWorkbook; class file has wrong version 46.0" My classpath includes the POI and commons jars. Does anyone know what this is? Does HSSF work with JDK 1.2

Re: Open an EXCEL file from IE: An example

2002-06-11 Thread Jürgen Molderings
I also try to send a Poi generated Excel Sheet to a browser, with the difference, that will only save the file for offline processing by the user. My problem is, there something is going wrong whem I 'flush' the workbook to a servlet output stream. It seems the header is corrupted cause I see a lo

Re: case studies wanted.

2002-06-11 Thread Andrew C. Oliver
[EMAIL PROTECTED] wrote: >Some other reasons to use POI : > >- we want to generate XLS file on a server (not allways Win$ + Office). Usually >Office is not installed on servers. > That and if you use it, its single threaded as an OLE server. Meaning if you open two sheets at once, then it figh

RE: case studies wanted.

2002-06-11 Thread Riley, Cameron
Andrew, >Part of what I think would bring more momentum to the project is >if we had real concrete examples for POI's use. We'd >really appreciate some content for this on our web page. If you >wouldn't mind, please submit a few short paragraphs >describing who you are (what company, industry

Compilation questions

2002-06-11 Thread bsegonnes
Hi, I'm trying to comile the POI 1.6.0 source files using the JDK 1.2.1 and I got some errors like : - deprecated API in HSSFRow.java for instance - and some "Excplicit cast needed to convert short to byte" mostly in the formula package. My questions are : what JDK are you using ? Is there a f

Re: String from Db using utf-8

2002-06-11 Thread Skondras P.
I have found it sorry for the question it was en error in the code ... "Skondras P." wrote: > Hi > i want to put some greek chars in an xls file and works ok if i put them > with encoding UTF_16 in the java code. > But there is always a but > When i read the string from the database which is utf

RE: case studies wanted.

2002-06-11 Thread bsegonnes
Some other reasons to use POI : - we want to generate XLS file on a server (not allways Win$ + Office). Usually Office is not installed on servers. - then those files would need to be printed (margin), have graph, logo (image ion cell), and coordinates would need to be in inches, cm, mm :-) - th