It is probably from file /xlrd/compdoc.py
I geeting this message on beginning reading one big (77MB) .xls file
with 5 sheet. First 4 sheet have 65535 rows of data. row 1 and row
65536 are empty. (I know it is crazy to have such data in excel, but
it is from external source.)
The data can be clearly readed from that file. Writing is not needed.
The file header says that a particular data collection (Short Sector Container Stream) is empty. It also says that a data structure (Short Sector Allocation Table) used to access that collection is NOT empty.
This indicates that either (1) the file is corrupt or (2) the author of the file-creating software is somewhat slack about initialisation.
> It is probably from file /xlrd/compdoc.py
Probably? What's stopping you from looking at the file?
> I geeting this message on beginning reading one big (77MB) .xls file > with 5 sheet. First 4 sheet have 65535 rows of data. row 1 and row > 65536 are empty.
Isn't there an off-by-one error in there somewhere?
> (I know it is crazy to have such data in excel, but > it is from external source.)
> The data can be clearly readed from that file. Writing is not needed.
As you have a medium-size file, the SSCS won't be used for storing the Workbook stream. If the data that you extract appears OK, you can just ignore the warning.
> Probably? What's stopping you from looking at the file?
I found the error message string in that file with Google. I look
inside and look at a part where the message is, but there was not
useful information for me. Maybe, explanation from your message to me,
should be given there as commentary.
RE. If the data that you extract appears OK, you can just ignore the
warning.:
Yes, te extracted data looks to by OK, so I will ignore that
warning.