I'm having problems reading '03 xls files

Jun 13, 2012 at 8:48 PM
Edited Jun 13, 2012 at 9:04 PM

So here it is .. I have been looking through the code to find out why and I am stuck.

I have tried this BOTH in the .NET and Silverlight versions.

I have a '03 format xls file.  Read it in using:

 

      Dim excelReader As IExcelDataReader = Nothing
            Debug.WriteLine("Stream health {0} ", sr.CanRead)
            excelReader = ExcelReaderFactory.CreateBinaryReader(sr)

            excelReader.WorkBookFactory = New ExcelDataReader.Silverlight.Data.Example.WorkBookFactory

            Dim workbook = excelReader.AsWorkBook(True)
            Dim sheets = workbook.WorkSheets

 

and in an Excel file with 2 workbooks, they are not cast (internally garbled) and do not return.

When I read the file into Excel '07 and write it as an xls file, it works a-ok.

 

Any clues as to where to look?  the original file was 266 kb, the saved: 234kb -- smaller?! Hmmm.....