phpExcel not able to process worksheet v2.1

I have a problem in reading and displaying excel using phpExcel. the excel work开发者_开发问答sheet version is 2.1, and only this version have the issue.

Please help.

the data read using phpExcel is not displaying correctly. And this happens only with older version of excel file (v2.1)

Excel v2.1 is nearly 25 years old now (released in 1987), and is not supported by PHPExcel. The file structure for all Office files has evolved quite significantly over the years; and most Excel readers, including PHPExcel, only read files from version 5 (released in 1993) and which saw a major reorganisation of the file structure to the OLE2 compound document format.

You might be able to read an Excel BIFF2 file using COM; but you're likely to find that very few 3rd party libraries in any language support an Excel format that old.

Alternatively, read the file using MS Excel itself, and save it in a more recent version of the BIFF format before trying to read it into PHP.

EDIT

As a third option, it would also be possible to write an Excel2 Reader for PHPExcel, although this would be a significant piece of work.

There are a few inconsistencies with phpExcel and certain Excel versions. I had not problem using Excel5 for example for some of my templates and then that broke from one version to the next. I recommend you to work using the latest xlsx readers and writers when using PHPExcel if possible since these seem to be the most robust ones.

Hay vimal you can use some other methods to read excel file

Hope these links will help you

http://phpexcelreader.sourceforge.net/

http://www.ibm.com/developerworks/opensource/library/os-phpexcel/

Thanks