--
http://www.superlinksoftware.com
http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound
Document
format to java
http://developer.java.sun.com/developer/bugParade/bugs/4487555.html
- fix java generics!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh
--- Begin Message ---
Oh, I've got another one!
The methods for setRow() and getRow() for LabelSSTRecord take and return
short values.
But the maximum value for short is 32767 while Excel can generate
spreadsheets of up to 65536 rows.
I think I can do a cross-cast to char, and then a promotion to int, but I
think row values should be int.
Carey Sublette
-----Original Message-----
From: Marc Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 11:30 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Fwd: POI HSSF Comments
Andy: can you pass this on to the list? I'm not subscribed from my hotmail
acct and can't access my apache addy from here.
Carey: you raise some very good points; not the "can you guys add xyz
feature please? oh, and fix my code too?" type we usually get. Also, Andy is
checking with the list ownership to see if maybe your domain is blocked.
Could happen.
>From: Carey Sublette <[EMAIL PROTECTED]>
>
>[Outloook decided to send my message on before I had finished it. Her eis
>the complete version.]
Ctrl-Enter strikes again?
>
>Marc:
>
>I have been generating comments and questions, and sending them to the
>'[EMAIL PROTECTED]', but they never show up on the mailing list.
>
>Am I missing something about how to do this?
>
>Issues I have raised include:
> HSSF Event API Behavior
> Hi:
>
> I have been conducting testing of reading a simple Excel spreadsheet
>using the HSSF Event API, and I encounter termination of the read with the
>exception:
>
> org.apache.poi.hssf.record.RecordFormatException: Error reading
>bytes
> at
>org.apache.poi.hssf.eventmodel.HSSFEventFactory.processEvents(HSSFEventFact
o
>ry.java:179)
> at
>com.go2.dummy.XLSFormatParser.<init>(XLSFormatParser.java:76)
> at
>com.go2.dummy.SheetParserFactory.getSheetParser(SheetParserFactory.java:63)
> at com.go2.test.SSEventProcDev.main(SSEventProcDev.java:42)
>
> As far as I can tell by printing out the data records all of the
>spreadsheet was correctly read, at least as far as the actual data goes. Is
>this "normal" termination of a spreadsheet file read by the
>HSSFEventFactory?
>
> Carey Sublette
>
>
>and:
>
> HSSF Event Model API Design Problem
> Hi:
>
> While working on developing an application using the HSSF event
>model, I have encountered what appears to me a serious problem with the
>current API design.
>
> It appears to require that I pass the thread of control to the
>HSSFEventFactory, which process the input stream and invokes my registered
>handlers to process the records., after which it returns (with a data read
>exception, which isn't nice, but that's another story).
>
> BUT - there seems to be no provision for my handlers aborting the
>processing if an error is detected. The HSSFListener interface declares no
>Exceptions, so none can be thrown.
>
> This is a serious problem because if a fatal problem (from my
>requirements) is detected at the beginning of processing (in the
>DimensionRecord for example), there is no way to avoid crunching through
>what may be an excessively large spreadsheet (65556 rows by 1000 columns,
>say) and crashing my enterprise's app server.
>
> It should add and Exception that can be thrown by the API user (with
>appropriate revisions to the HSSFEventFactory) so that processing can be
>aborted with a user generated message.
>
> Carey Sublette
>
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
--- End Message ---
