Not able to read Amazon xml 2003 xls spreadsheet

Topics: Developer Forum, Project Management Forum, User Forum
Nov 6, 2013 at 8:34 AM

First of all i would like to thank for this great package.It is successfully read and wirte both .xls and .xlsx formats. But i am having one amazon xml 2003 xls spreadsheet. I used the below code to read this file.
$inputFileName = './AmazonPOs_1236260_20131009_142318_New.xls';
include 'PHPExcel/IOFactory.php';

$objReader = PHPExcel_IOFactory::createReader('Excel2003XML');
$objPHPExcel = $objReader->load($inputFileName);

In that xls file i am having 29 columns. But this code able to read only 7 columns and in partial read. But when i save as that file into xlsx it is successfully read and write with the code.Can you please suggest me if i wrong in this?