On Wed, 2002-02-13 at 10:19, acoliver wrote:
We voted on this and everyone agreed a 1.5 production release with the new
jakarta namespaces was called for. The hold up right now is someone from
jakarta with sufficient karma must copy the already existing webpage over to
the main jakarta site.
of the excellent hard work on this project. It has really
benefited me!
R
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 16, 2002 9:22 PM
To: [EMAIL PROTECTED]
Subject: Re: Protected Sheet
Unfortunately, that switch actually
Nope it sure doesn't! Its an ISAM database and uses an ISAM b-tree
based format
-Andy
On Mon, 2002-03-04 at 18:42, Glen Stampoutlzis wrote:
NO! Thats totally bogus! OLE 2 CDF is formatted as such to make this
impossible (downstream pointers to upstream things and vice versa)
Marc,
Cool, thanks man! So all we have our first submission. I'll start a
page.
On Fri, 2002-03-15 at 06:50, Michael Mosmann wrote:
my submission for poi logo contest
http://www.mosmann.de/michael/
mm:)
--
http://www.superlinksoftware.com
http://jakarta.apache.org/poi - port of
On Sun, 2002-03-17 at 17:15, Thomas Linden wrote:
Hi,
On Sun, Mar 17, 2002 at 03:06:30PM -0500, Andrew C. Oliver wrote:
Hi Tom,
Logging in POI is primarily for tracing. We're of the opinion that
logging is a prevalent concern of everything! Class libraries need it
for debugging
Hi,
Just wanted to point out that the POI site now works fine in Netscape
4.x. Sorry it took so long, somebody who will remain nameless forgot to
update the site in CVS after he changed it. (Same issue with the broken
images at the bottom)
-Andy
--
http://www.superlinksoftware.com
You'll need to get a CVS copy of POI (which uses commons logging to get
around this problem). Otherwise you'll have to recompile POI to work
with specific versions of log4j.
We'll be releasing 1.5 shortly so the CVS edition is close to that level.
-Andy
Steven Citron-Pousty wrote:
Just so everyone knows (who has submitted logos and thinks they've
disappeared). We're having a bit of trouble updating the site. I've
made the edits and one day they shall appear. Be patient.
Thanks for your submissions.
Russell, think you can cut those up for me? One big image is going to
://www.russellbeattie.com/images/poi_button1.png
http://www.russellbeattie.com/images/poi_button2.png
-Russ
Andrew C. Oliver wrote:
Just so everyone knows (who has submitted logos and thinks they've
disappeared). We're having a bit of trouble updating the site. I've
made the edits and one
Are you getting some header information in there? This error is
generated when the first 8 bytes of the file don't match the Magic
Number Identifier that is at the top of all XLS files. So if I had to
guess I'd say either you've somehow reversed the byte order (which
doesn't make sense) or you
Hey Ken, I forgot what I was suppose to do to fix this for you. Can you
fix this?
-Andy
Loïc Lefèvre wrote:
Hi,
Can anyone tell me where
I can find the tidy package?
That's because I encountered the following error with the test ant-target.
java.lang.NoClassDefFoundError:
Interesting, we'll need to take a look at it. I've tried it with all
the way up to about 1.0.2 or so which generated a file designated as v8.
Unfortunately the mail lists for gnumeric don't give me much of a clue
as to what's going on.
Anyhow, if for the moment you use .8 - 1.0.2 it should
1.0.4 should also work.
On Wed, 2002-04-03 at 02:30, Sven Kuenzler wrote:
Hi,
I am currently developing an application that has to provide data in excel
format. As the Excel spreadsheet is given, my plan was to convert it to xml
via gnumeric, to create a stylesheet of it and finally
1.4583 still uses log4j directly. I recommend you do a CVS
extract and do a build from there. We're pretty close to 1.5 being
released.
Otherwise if you get the latest beta of log4j (someone snuck that in
under the door) then that should work as well.
Thanks,
-Andy
On Wed, 2002-04-03 at
find more information about the Gnumeric file
format? I mean where can I find a dtd or xml schema about how a Gnumeric
file should be build up?
Thanks,
Edgar
-Oorspronkelijk bericht-
Van: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Verzonden: zondag 7 april 2002 19:12
Aan: poi
On Tue, 2002-04-09 at 03:58, Sven Kuenzler wrote:
| 7813|New|Maj|2002-04-07|[PATCH] HSSF Serializer support new Gnumeric
1.04+|
Give it a try and let me know. Otherwise just encapsulate cell values
in Content/Content tags. (thats what changed and understandably
broke HSSF
:\\temp\\test.xls);
// write the workbook to the output stream
wb.write(out);
out.close();
return true;
}
-Ursprüngliche Nachricht-
Von: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 9. April 2002 14:29
An: poi users
Betreff: Re: Adding rows
The CVS edition has a class called HSSFDateUtil. It should appear in
the 1.5 release when it comes out.
-andy
[EMAIL PROTECTED] wrote:
Hi Lorenzo
I've a similar problem (same country, same problems?). I need the german
JJMM but this is not an official excel format. For the moment I'm
bug reports guys, xls samples (create bug, edit bug, then you can attach
things to the bug).
As a POI developer there is absolutely no way this kind of
internationalization gets done unless I have a sample file. This stuff
isn't documented, and we're all bad guessers -- we also don't have
Why yes! Thats great! Glad I could help!
1.5 - as soon as we get another dev release out, have all the docs up to
spec and people have run it and don't have logging issues. All the
trouble that log4j etc has been, it would have been faster to write our
own logging! sheesh! Hopefully this is
Tell you what.. We're planning a new Dev build shortly that will
hopefully eliminate all these irritating issues with log4j... use it.
Alternatively, if you can't wait a couple days, grab the latest sources
from CVS and build. (use jar target)
-Andy..
PS don't put two versions of POI in
pass -Xmx128m to your JVM. You're running out of heap space. For more
info:
java -X
-Andy
On Fri, 2002-04-12 at 08:25, Míguel Ángel Mulero Martínez wrote:
I'm trying to create a Excel file with POI. I want to create a file with
25000 rows aprox, but I recive an OutOfMemory java Exception.
Have you ever been able to open zipped xls files in Excel? (news to me)
On Tue, 2002-04-16 at 02:06, V.Jaishankar wrote:
Hai,
I have created a .xls file using poi.Then i zipped the file.I am unable to
open the zipped .xls file.
Please do help me.
Thanks
Jaishankar
--
Message -
From: Andrew C. Oliver [EMAIL PROTECTED]
To: poi users [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 5:43 PM
Subject: Re: Could not open xls file
Have you ever been able to open zipped xls files in Excel? (news to me)
On Tue, 2002-04-16 at 02:06, V.Jaishankar wrote:
Hai,
I have
Alexandre Luti Telles wrote:
Hi
I haven't studied the xls format yet, but how difficult it would be to read the
macros, store it in a binary variable, and write it back to the file?
Would this work?
possibly. I think they're stored in a seperate entry in the POIFS part
of the file (OLE 2
Thats not 1.5 thats a pre-1.5 version.
Glen, I was afraid of that. In the future we need to set these names
more appropriately.
In the current development version of HSSF it does not handle custom
formats. So if its not in HSSFDataFormat then its going to resolve to
General.
-Andy
On Thu,
Yes this is a documentation bug. We're using double. double rounding
is not 100% accurate. Future versions may support BigDecimal as well,
but not the current dev version. If you round to the expected decimal
places you should get acceptable results.
If someone wants to do a BigDecimal
Note to self.. . Put this in the FAQ and put this in big bold letters
over the constant.
Andrew C. Oliver wrote:
Set the foreground color when you set the solid fill pattern. Its
filling SOLIDLY with the FOREGROUND color. Just like the other patterns
fill with dots for instance...they fill
Okay. No. You want a SOLIDLY filled pattern of the FOREGROUND color.
So Fill patterns have two colors. Foreground and background. The
background color is between the fill. So if you set the foreground to
yellow and the background to while and you select the dots constant,
you'll get
No...if there is not dataformat set, then it will always be 0.
Glen Stampoultzis wrote:
Dates are actually stored by Excel as numeric. getDataFormat() sounds like
a bug. We will investigate.
Regards,
Glen Stampoultzis (TriNexus Pty Ltd)
+63 3 9753-6850 0402 835 458
ICQ: 62722370
If it has the date format set then sure.
Glen Stampoultzis wrote:
Yes but if it's displaying as a date in a sheet then the data format must be
set - right?
- Original Message -
From: Andrew C. Oliver [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 12:15 AM
Subject
There is not a real date cell type. Its just a number that is formatted
to be a date. To experiment with this set it to general data type.
Then it will just be a straight number.
Hoffman, Jason wrote:
Oliver,
I also have the same question. This is the way I've implemented, which
So why don't you just use that for now? Or submit a bugfix patch for
getDataFormat(). At the very least why not supply a bug report in our
bug tracker?
-Andy
Oliver Fuerniss wrote:
as i know the ExcelRead version 1.6.x from Andy Kahn has a function to find
out if the cell is a date. But
There are no plans to support protected anything as it would get us in
the business of encrypting things. Because much of the development
takes place in the USA which has chosen to take a rather medieval view
of encryption, and none of the US based committers are interested in
seeing the inside
get the correct result.
I think this is a step back.
Uwe
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 2:05 PM
To: '[EMAIL PROTECTED]'
Subject: Re: Wrong result from numberic cell value with
v1.5.0-dev-20020416
task complete please crosscheck.
On Tue, 2002-04-16 at 19:23, Nikhil Karmokar wrote:
Hi Andrew,
I had posted, about 2 weeks ago, the URL for the POI
logos that I had designed but didn't receive any
replies or suggestions on the matter.
I have uploaded the logos to a new URL in case
Yeah it was taken off line like over a year ago AFAIK. IF it had
reappeared, I'm sure it was a mistake.
On Mon, 2002-04-22 at 17:53, James, Randy wrote:
Maybe I am crazy, but last week it seems that the MSDN site removed some
parts of the Excel Dev Kit - notably the Excel Structure Chapter.
started. It is too late for the pebbles to
vote.
-Ambassador Kosh
---BeginMessage---
Andrew C. Oliver wrote:
Great, I'll stick them up probably this weekend.
We have several new poi logos. Please check them.
On Tue, 2002-04-23 at 05:37, [EMAIL PROTECTED] wrote:
Dear Andy:
Please
The feature is not yet available in HSSF. If your images are relatively
small it should be relatively simple to add. I can only speak fro
myself but I do not know of anyone currently working on this for HSSF
2.0. (Formulas and Graphing are the hot topics for the upcoming
release, I expect
You should see UnknownRecord with an ID = 0x1c in the
org.apache.poi.hssf.dev.BiffViewer output. This is the Note and/or
Comment record. However it appears you'd also have to work with OBJ
records. Perhaps you and Rodney could collaborate on that part (since I
think Images will require OBJ
Hi All,
If you click on Download on the main page
(http://jakarta.apache.org/poi) you will notice a new directory called
nightly. From this point on every night at 2:00am or so a nightly
build of POI will be uploaded. For the moment these are just the jar
files, but I hope at some point in the
Daniel Carnes wrote:
I am new to POI, and I need some help finding out the best way to
password protect an excel workbook. I have used all of the examples
and looked in the javadocs, but none of the hssf examples mention how
to do this. Any help would be greatly appreciated.
Thanks
Unfortunately POI does not yet support Far Eastern languages. We'll
need more help from fine folks like you who can work on adding this
support.
The Far east version of excel has some different settings and things
that are not documented. It would be difficult to actually figure these
That's correct. Andy is working furiously and making good progress. It
Correction, Avik made the most progress. I just helped.
-Andy
will be released as part of 2.0. Take a look at the Poi 2.0 vision document
for more information on what we hope to achieve with the 2.0 release.
Lars Tynelius wrote:
Hi!
Is there a way to freeze panes in a sheet with POI. I can't find
anything in the API
Thanks!
Lars
It hasn't been implemented yet. We'd be happy to take a contribution.
Adding this shouldn't be too hard.
-Andy
But you missed this: http://jakarta.apache.org/poi/hssf/how-to.html
On Tue, 2002-04-30 at 15:01, Seth Ladd wrote:
Hello,
I've looked through the Javadocs and the mailing list, but I can't seem
to figure out what the API call is for setting a column's width. Any
tips or hints would be
Glen Stampoultzis wrote:
http://www.coolsurveys.com/cgi-bin/Survey?POI
cool man, add that to the home page. Let the people be heard!
Not there yet. . Post an [RFE] in bugzilla paste your email. This would
be very easy to add, its just not at the top of my list (everything
formulas IS)
-andy
*how does one freeze a row so that it doesn't scroll?*
The code to do this in the Spreadsheet::WriteExcel module is:
my
[EMAIL PROTECTED] wrote:
I looked through the HSSF project and couldn't find anything regarding
pagebreaks other than SavedInPAgeBreakPreview at the WindowTwoRecord class.
How do you set the Horizontal PageBreak for a worksheet?
Regards,
Joann T.M. Shie
IT hasn't been implemneted yet. It
Agarwal, Vinay (Cognizant) wrote:
Hi, I am not sure if this is a bug .
I am trying to read a xls file which has a cell with Date format.
I have used EventExample.java for this purpose. What is happening is
that
instead of date it returns me a number. I looked at the APIs for DateRecord
hummm...that was somewhat contentless.
On Thu, 2002-05-02 at 21:03, Glen Stampoultzis wrote:
- Original Message -
From: Andrew C. Oliver [EMAIL PROTECTED]
To: poi users [EMAIL PROTECTED]
Sent: Friday, May 03, 2002 10:31 AM
Subject: Re: Logo Ideas
Those are cool!
Think
I'd rather see an isDateFormat) in HSSFFormat.
-Andy
Glen Stampoultzis wrote:
HSSFCell makes sense. Patch away.
-- Glen
- Original Message -
From: Jason Hoffman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 03, 2002 10:12 PM
Subject: Re: Dates!!
Glen,
If this method
Hi all,
There is a new Apache mail archive that seems pretty zippy. Its located
at http://nagoya.apache.org/ . There are no messages in the POI one
yet but thats because it didn't start indexing until last night.
Anyhow, I'll probably change the link in a couple months or so on the
Lorenzo Resta wrote:
Hi Folks,
Is there a way to get the Excel Format String of a cell from POI? I know,
there is a class that contains all default formats (HSSFDataFormat). But
what can i do if i want to get the custom format from the cell?
Thanks and keep the good work going ;-)
Lorenzo
with
the angry mask big spear etc...currently working on a PG version for those
that feel that might not be appropiatewill be sending in a couple hours
Thanks this has been fun to work on
Randy
Andrew C. Oliver wrote:
And hopefully you don't think that that means I don't like it... I
think its
(out); // write the workbook to the output stream
out.close();
}
catch (Exception e) {
System.out.println(Exception + e);
}
}
}
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: 07 May 2002 2:12
To: POI Users List
Subject: Re
tried both jakarta-poi-1.5.0-dev-20020427.jar and
jakarta-poi-1.6.0-dev-20020508.jar. Same result.
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 08, 2002 5:10 PM
To: POI Users List
Subject: Re: got IOException from
wants to
handle this scenario or I have to change RawDataBlock locally.
an
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 10:27 AM
To: POI Users List
Subject: Re: got IOException from poi.poifs.storage.RawDataBlock.init(
R awDat aBlock.java
Dagnon, Chris wrote:
Some questions:
1. HSSFFont: Are the font's IDs the same for every machine? If so, is it
just a matter of someone putting in all the fonts other than Arial as
constants in this class?
Nope. The font ID refers to the font record added. These are
sequential
Johannsen, Cory wrote:
The spreadsheet I am generating has some cellls that will be shaded with a
background color, while other uise the default (white) background. I've
been playing around witht eh shadding patterns, and find that most of them
distort the text within the cell. From Excel I
stuff.
We're getting closer to knowing every day. Thats why this is fun ;-)
-Andy
-Chris
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 9:10 AM
To: POI Users List
Subject: Re: HSSF formatting questions
Dagnon, Chris wrote
--
http://www.superlinksoftware.com - software solutions for business
http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in
Java
http://krysalis.sourceforge.net/centipede - the best build/project
structure
a guy/gal could have! -
On Sun, 2002-05-12 at 05:14, Glen Stampoultzis wrote:
The logo contest has been running for a while now and I think the time is
nearing where we have to close it and vote for the best one. If you have
been sitting on any logo's now would be the time to enter them.
+1 - shall we give a
Some formulas support is already in CVS and in nightly builds. It
depends on *which* formulas.
We're volunteers. It will be done when someone has enough time off from
their regular job to finish it or when enough folks contribute to the
effort. There are no solid deadlines only goals.
Johannsen, Cory wrote:
Is it possible with HSSF to create a border around a block of cells? I have
a spreadsheet that contains a block of 8 cells (2 cols, 4 rows), that I want
to place a border around to seperate them from the rest of the document.
The cells themselves don't need borders, just
Hi All,
Nightly Builds
You may or may not have noticed the POI nightly builds haven't been
working. I was doing some re-engineering of HPSF and had to do it in
steps so the build was broken. If the build is broken then obviously
the nightly builds don't upload. I've tested the build and I
Danny Angus wrote:
The variable WHITE in interface
org.apache.poi.hssf.usermodel.HSSFColorConstants has been deprecated.
What should I use instead of the colour values?
d.
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
looks fine to me: http://jakarta.apache.org/poi/hssf/how-to.html
Danny Angus wrote:
Thank you.
Someone should perhaps change the example in the how-to
-Original Message-
From: David Haskell [mailto:[EMAIL PROTECTED]]
Sent: 20 May 2002 17:17
To: POI Users List
Subject: RE:
Danny Angus wrote:
would you not find a spreadsheet that mysteriously crashed excel (or had
hidden incorrect values) MORE annoying?
Yes.
Then the casting the shorts is better ;-)
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL
Alexandre Luti Telles wrote:
On Tue, 21 May 2002 08:47:34 -0400
Andrew C. Oliver [EMAIL PROTECTED] wrote:
Start with o.a.c.p.h.usermodel.HSSFWorkbook/o.a.c.p.h.model.Workbook.
Anywhere there are calls to org.apache.poi.poifs.* make sure its
getting ALL files (within the OLE 2 CDF
Ferruccio Spagna wrote:
Personally I think JSPs are TOTALLY inappropriate for (well just about
everything other than demonstrating how to program non object oriented
code) binary output. I would highly recommend you use a servlet.
I can agree with you. Nevertheless I tried to write a
Fauzia Lala wrote:
Hi
I am using HSSF for making excel files. I need to be able to create more than a
single line in each cell. I have tried the usual \n, but that does
not seem to be working. Any Ideas?
Fauzia Lala
That is an increadibly simple question and I'm shocked that I've no
Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07, 2002 10:13 AM
To: POI Users List
Subject: Re: Page margin
Great, please submit a page (in bugzilla) as you propose and I shall
post it (use the same XML format as the
rest of the documentation). I prefer
a couple VERY SIMPLE properties that are
actually documented. No need for log4j logkit, commons logging,
bebopalooing just something USEABLE/USEFUL and not this huge headache.
-Andy
Eric
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07
Glen Stampoultzis wrote:
Same here. I mean realistically, unless you're patching code, you'll
probably not use POIs logging. The BiffViewer will tell you way more
than logging will. And if you had any *under load* type of error,
logging would slow it down so much that it wouldn't be useful
Hi All,
I'd like to ask you for a hand with something. Lots of folks are using
POI for different reasons but its hard to gear
development without having a clear handle as to what. Early on, to my
suprise, most folks were using it for reading, but
I think that was mostly a
[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
fights
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.
It
Daniel Carnes wrote:
I am a newbie trying to create a chart using poi in an xls file. Does
anyone have any code that shows how to do this?
_
Send and receive Hotmail on your mobile device: http://mobile.msn.com
--
To
Riley, Cameron wrote:
Andrew,
Hope the little blurb below helps. The application is for internal process
management to support engineering and maintenance services. POI HSSF
provides the invoicing component of the application. We use POI as write
only. The only addition I have been requested
I suggested the use of storing the correspondence in an xml format,
using xsl stylesheets to process it to the selected output (pdf, txt,
rtf, html, whatever else is out there).
I don't see much trouble with this, only I don't know if poi is yet
implemented in an xsl environment like FOP.
That would be HSSF not POIFS. HSSF cannot handle spreadsheets for/by
the Far East
version. None of the Far East records and the such are documented, and
until someone who
can tell if its right or not (meaning actually can read chinese, etc) to
work on this, it won't support it.
HSSF can
I'm using POI to read simple Excel sheets containing Japanese (and created
by Japanese versions of Excel). No problems to report so far - the DBCS
text comes through just fine.
Thats cool...and weird! Reports are the HSSF can't read/write
Russian, but it can Japanese...
Could you
Avik Sengupta wrote:
I would like to know what the limit is before Excel 'chokes'?
Programming wouldnt be that much fun if everything could be distilled to hard
numbers, would it?? ;-)
I used to stream HTML tables to excel of about 2MB. I had to switch to server
side generation, since
pain)
-Andy
On Thu, 2002-06-13 at 02:38, Glen Stampoultzis wrote:
1.5.1 is pretty much ready and sitting on my hard drive too...
Are you close ot wanting a new milestone release?
yeah, possible middle of next week.
Quoting Andrew C. Oliver [EMAIL PROTECTED]:
Avik Sengupta
Try passing this parameter:
-Xmx150m
- to your jvm. Ex: java -Xmx150m org.world-cup.MyProgThatUsesPOI
type java -X for an explanation.
¹Ú³²±Ô wrote:
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
You can't because the file has upstream pointers to downstream things.
We have to build it all in memory.
You can increase your heap size by passing -Xmx150m to your jvm. type
java -X for details.
[EMAIL PROTECTED] wrote:
Just wondering if it's possible to stream while building? We are
Glen Stampoultzis wrote:
You cannot stream an OLE Structured Document. Not even a part of it.
There
is a pointer in the very first two blocks of the file whose value cannot
be
known until the last cell is written.
The header contains a pointer to the file system's root
On Fri, 2002-06-14 at 14:19, Steven Peterson wrote:
Thanks for the info. I began using the named ranges and assume this is how to
use them:
//Find the file
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(path));
_hssfWorkbook = new HSSFWorkbook(fs);
//Find
There is no way in heck I would generate an ASP.NET anything for fun.
For lots and lots of moneyMAYBE...but I'd probably take a shower
afterwards.
However, my personal plans do include participating in the creation of
such a thing, but not as part of the POI project. It shall certainly
use
Based on the past few days messages which I've finally read and
digested, I've drawn the following inferences and conclusions. Please
correct this summary where appropriate.
1. There is currently a bug in HSSF where either the method for causing
formulas to be recalculated on open is not
No, you must start the jvm with -Xmx{size}m
Generally distribute your application with a run.bat and run.sh file.
Other successful programs that do this:
1. Tomcat
2. JBuilder
3. Netbeans
-Andy
On Sat, 2002-06-22 at 03:32, Ravi S Kodamarti wrote:
Hi,
I'm getting OutOfMemoryError
Hi All,
Don't ask my why I did this... but maybe it has to do with the
umpteenth private email asking me if HSSF has a gui app to show XLS
files.
I wrote this in the course of about an hour. Its in contrib, it reads
XLS files from streams and/or files, it can run as an applet.
It proves I'm
:08, Andrew C. Oliver wrote:
Hi All,
Don't ask my why I did this... but maybe it has to do with the
umpteenth private email asking me if HSSF has a gui app to show XLS
files.
I wrote this in the course of about an hour. Its in contrib, it reads
XLS files from streams and/or files, it can
of excel files
upto 5mb. Even if I inrease the heap size, the application is running pretty
slow. Is there any other process to increase the performance?
Thanks
Ravi.
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 6:27 PM
To: '[EMAIL
about 4 mins. Can
anyone see anything I am doing wrong that would cause this slow down? 90
milliseconds to build a cell seems high.
Thanks
Brian
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 24, 2002 6:17 PM
To: 'POI Users List'
Subject: RE
Not currently. It would be simple to add. You just need to modify HSSF
to maintain other files in the
underlying OLE 2 Compound Document (POIFS) file. For example, HSSF
primarily concerns itself with the
Workbook file in the OLE2CDF file. (Think of an XLS as an archive).
I plan to work on
. Once
turned off it was an unbelieveable difference. I had a feeling once turned
off it would speed things up a bit, but I didnt realize HOW much it would.
Thanks for your help.
Brian
-Original Message-
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 25, 2002 1:58 PM
Fine. I'll try to make this as obvious as I can. Please supply patches
to the documentation that would make this more
obvious to you.
cd /tmp
unzip ~/jakarta-poi-1.7.0-dev-bin.zip
export CLASSPATH=/tmp/build/jakarta-poi-1.7.0-dev-20020624.jar
if you need logging, scratchpad, examples,
POI 1.7?
Gosh, you must be a time traveller then ;-)
POI 1.5.1 (latest)
http://jakarta.apache.org/builds/jakarta-poi/release/bin/
needs that the POI jar is in the classpath.
What's the problem you had?
Um Ken The development release of POI is 1.7-dev
1 - 100 of 496 matches
Mail list logo
