poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 36345] - How to find corrupted record
Date Fri, 09 Sep 2005 20:53:24 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=36345>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=36345





------- Additional Comments From sujatha_pasam@yahoo.com  2005-09-09 22:53 -------
Hi Jason,

Thanks for the reply. The excel file was re-written by VB team by reviewing all 
the macros and formulae. The POI is now able to read this file. So the problem 
is solved for now ... but may occur again, in which case I will send you the 
file. 

Tx, 
Sujatha


(In reply to comment #0)
> Hi,
> I am getting File error: Data may have been lost while opening an excel file. 
> My java code gets the file from db, which is put in by another application in 
> VB. The VB team keeps on adding lots of formulae to the sheet, when webapp 
> reads, the POI doesn't understand all of them and throws above error. 
> Even though I debug with eclipse, I am unable to figure out which record teh 
> POI doesn't understand. The data is chunks of byte arrays and all numbers in 
> hex. I tried using biffViwer, it generated lots of unknown records, how do I 
> read these numbers to figure out which record is corrupt. How do i read 
> recordid below ? How do I know which records or values are bad for POI ?? 
> -----UNKNOWN----------------------------------
> Offset 0xa8 (168)
> recordid = 0x13d, size = 28
> [TABID]
>     .elements        = 14
>     .element_0       = 41
>     .element_1       = 39
>     .element_2       = 176
>     .element_3       = 37
>     .element_4       = 223
>     .element_5       = 10
>     .element_6       = 217
>     .element_7       = 145
>     .element_8       = 215
>     .element_9       = 216
>     .element_10       = 224
>     .element_11       = 221
>     .element_12       = 222
>     .element_13       = 218
> [/TABID]
> -----UNKNOWN----------------------------------
> Thanks for your time,
> Sujatha.



-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


Mime
View raw message