Error reading stream from FAT area.


My attached file are export from DevExpress.XtraGrid control
When read this file via Excel Data Reader it's raise error at \ExcelDatareader\Excel\Core\BinaryFormat\XlsBiffStream.cs
public XlsBiffStream(XlsHeader hdr, uint streamStart)
        : base(hdr, streamStart)
        bytes = base.ReadStream(); //<-- erorr here
        m_size = bytes.Length;
        m_offset = 0;
and exception message is: Error reading stream from FAT area.

file attachments

Closed Jan 17, 2013 at 10:54 AM by Ian1971


iciobanu wrote Aug 24, 2009 at 7:22 PM

Indeed is a problem.
The cause for this can be from DevExpress.XtraGrid control because when I've opened the file with Ms Excel App and save-it the test passed.

sudhAnsu63 wrote Dec 21, 2012 at 9:10 AM

i am also having the same problem after the file is edited with OpenOffice 3.3.0

i need a way to overcome this. Please help.
As i have the requirement that people will edit the file and upload.

Ian1971 wrote Dec 21, 2012 at 2:20 PM

@sudhAnsu63 are you able to attach a file exhibiting this problem?

sudhAnsu63 wrote Dec 22, 2012 at 4:12 PM

Original File was created in MS Office 2007. --Book1.xlsx

Modified by OpenOffice and Saved as Book1.xls as Save as .xlsx this format is not available in OpenOffice.
I Guess thats why i get this error.

sudhAnsu63 wrote Dec 22, 2012 at 4:15 PM

Modified by OpenOffice 3.3.0

sudhAnsu63 wrote Dec 24, 2012 at 8:47 AM

Any xls File Created by OpenOffice 3.3.0 are not readable and i get "Error reading stream from FAT area."
Check the Attached file OpenOffice Book 1.xls
File is created by OpenOffice.

wrote Jan 17, 2013 at 10:54 AM

Resolved with changeset 82317: Should now read open office 3 excel binary files.

KarteekPanakani wrote Oct 3, 2014 at 6:29 AM

Hi, I am also getting same problem for OpenOffice 3.3.0 files. how can i solve this error?