poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric B." <ebe...@hotmail.com>
Subject Re: Anyway to ignore LeftoverDataException?
Date Fri, 08 Jul 2011 02:55:06 GMT
On 07/07/2011 03:54 PM, Dave Fisher wrote:
>
>
> The first step is to identify where the problem is in the file.
>
> Take two files. One is the bad file, and two is the bad file after it is fixed by re-saving
in Excel.
>
> Try the BiffViewer[1] on both and see how the dump differs. Report back with the differences
and someone will help.
>

Thanks for the tip.  I tried BiffViewer, and the problem is that both 
files differ significantly.  (Bad file is 9.5K, Good file is 14K).  I 
generated the bad file with only 1 row to minimize the number of cells 
and records generated.

Bad file has 149 records.  Good file has 151 records.

The biggest problem is that some records are signficantly different. 
Some just have different record numbers,   I don't know if it is 
important to list all the differences/changes, or just to list the 
problem record.

In the bad file, Record 54 is problematic.  I'm listing both files in 
case someone knows or can pinpoint what the issue might be.:

Bad File:
Offset=0x000003C4(964) recno=53 sid=0x0085 size=0x000E(14)
[BOUNDSHEET]
     .bof        = 0x000006E9
     .options    = 0x0000
     .unicodeflag= 0x00
     .sheetname  = Sheet2
[/BOUNDSHEET]

[BOOKBOOL]
     .savelinkvalues  = 7
[/BOOKBOOL]

Offset=0x000003D6(982) recno=54 sid=0x00DA size=0x0004(4)
Offset=0x000003DE(990) recno=55 sid=0x00FC size=0x00D3(211)
[SST]
     .numstrings     = f
     .uniquestrings  = f
     .string_0      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 0
     .string          = Category
[/UNICODESTRING]

     .string_1      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 0
     .string          = Instance
[/UNICODESTRING]

     .string_2      = [UNICODESTRING]
     .charcount       = 5
     .optionflags     = 0
     .string          = Token
[/UNICODESTRING]

     .string_3      = [UNICODESTRING]
     .charcount       = 5
     .optionflags     = 0
     .string          = Flags
[/UNICODESTRING]

     .string_4      = [UNICODESTRING]
     .charcount       = 4
     .optionflags     = 0
     .string          = Text
[/UNICODESTRING]

     .string_5      = [UNICODESTRING]
     .charcount       = b
     .optionflags     = 0
     .string          = Description
[/UNICODESTRING]

     .string_6      = [UNICODESTRING]
     .charcount       = a
     .optionflags     = 0
     .string          = Translated
[/UNICODESTRING]

     .string_7      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 0
     .string          = Modified
[/UNICODESTRING]

     .string_8      = [UNICODESTRING]
     .charcount       = 7
     .optionflags     = 0
     .string          = Details
[/UNICODESTRING]

     .string_9      = [UNICODESTRING]
     .charcount       = 4
     .optionflags     = 1
     .string          = Date
[/UNICODESTRING]

     .string_10      = [UNICODESTRING]
     .charcount       = 13
     .optionflags     = 1
     .string          = 2011-07-07 13:41:02
[/UNICODESTRING]

     .string_11      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 1
     .string          = Username
[/UNICODESTRING]

     .string_12      = [UNICODESTRING]
     .charcount       = 5
     .optionflags     = 1
     .string          = admin
[/UNICODESTRING]

     .string_13      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 1
     .string          = Language
[/UNICODESTRING]

     .string_14      = [UNICODESTRING]
     .charcount       = 2
     .optionflags     = 1
     .string          = en
[/UNICODESTRING]

[/SST]

Offset=0x000004B5(1205) recno=56 sid=0x000A size=0x0000(0)
[EOF]
[/EOF]





Good File:
Offset=0x00000538(1336) recno=59 sid=0x0085 size=0x000E(14)
[BOUNDSHEET]
     .bof        = 0x0000085D
     .options    = 0x0000
     .unicodeflag= 0x00
     .sheetname  = Sheet2
[/BOUNDSHEET]

Offset=0x0000054A(1354) recno=60 sid=0x008C size=0x0004(4)
[COUNTRY]
     .defaultcountry  = 1
     .currentcountry  = 1
[/COUNTRY]

Offset=0x00000552(1362) recno=61 sid=0x01C1 size=0x0008(8)
[RECALCID]
     .reserved = 0x0000
     .engineId = 0x00013880
[/RECALCID]

Offset=0x0000055E(1374) recno=62 sid=0x00FC size=0x00A5(165)
[SST]
     .numstrings     = f
     .uniquestrings  = f
     .string_0      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 0
     .string          = Category
[/UNICODESTRING]

     .string_1      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 0
     .string          = Instance
[/UNICODESTRING]

     .string_2      = [UNICODESTRING]
     .charcount       = 5
     .optionflags     = 0
     .string          = Token
[/UNICODESTRING]

     .string_3      = [UNICODESTRING]
     .charcount       = 5
     .optionflags     = 0
     .string          = Flags
[/UNICODESTRING]

     .string_4      = [UNICODESTRING]
     .charcount       = 4
     .optionflags     = 0
     .string          = Text
[/UNICODESTRING]

     .string_5      = [UNICODESTRING]
     .charcount       = b
     .optionflags     = 0
     .string          = Description
[/UNICODESTRING]

     .string_6      = [UNICODESTRING]
     .charcount       = a
     .optionflags     = 0
     .string          = Translated
[/UNICODESTRING]

     .string_7      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 0
     .string          = Modified
[/UNICODESTRING]

     .string_8      = [UNICODESTRING]
     .charcount       = 7
     .optionflags     = 0
     .string          = Details
[/UNICODESTRING]

     .string_9      = [UNICODESTRING]
     .charcount       = 4
     .optionflags     = 0
     .string          = Date
[/UNICODESTRING]

     .string_10      = [UNICODESTRING]
     .charcount       = 13
     .optionflags     = 0
     .string          = 2011-07-07 13:41:02
[/UNICODESTRING]

     .string_11      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 0
     .string          = Username
[/UNICODESTRING]

     .string_12      = [UNICODESTRING]
     .charcount       = 5
     .optionflags     = 0
     .string          = admin
[/UNICODESTRING]

     .string_13      = [UNICODESTRING]
     .charcount       = 8
     .optionflags     = 0
     .string          = Language
[/UNICODESTRING]

     .string_14      = [UNICODESTRING]
     .charcount       = 2
     .optionflags     = 0
     .string          = en
[/UNICODESTRING]

[/SST]

Offset=0x00000607(1543) recno=63 sid=0x00FF size=0x0012(18)
[EXTSST]
     .dsst           = 8
     .numInfoRecords = 2
     .inforecord     = 0
     .streampos      = 56a
     .sstoffset      = c
     .inforecord     = 1
     .streampos      = 5bd
     .sstoffset      = 5f
[/EXTSST]

Offset=0x0000061D(1565) recno=64 sid=0x0863 size=0x0015(21)
[BOOKEXT] (0x863)
   rawData=[63, 08, 00, 00, 00, 00, 00, 00, 00, 00, 00, 00, 15, 00, 00, 
00, 00, 00, 00, 00, 02]
[/BOOKEXT]

Offset=0x00000636(1590) recno=65 sid=0x000A size=0x0000(0)
[EOF]
[/EOF]



Thanks!

Eric


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message