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: [email protected]
For additional commands, e-mail: [email protected]
