phpexcel-codeplex Follow @yiiframework

Yii::import('application.vendors.PHPExcel',true);
            $objReader = new PHPExcel_Reader_Excel5;
            $objPHPExcel = $objReader->load(@$_FILES['xls']['tmp_name']);
            $objWorksheet = $objPHPExcel->getActiveSheet();
            $highestRow = $objWorksheet->getHighestRow(); // e.g. 10
            $highestColumn = $objWorksheet->getHighestColumn(); // e.g 'F'
            $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); // e.g. 5
            echo '<table>' . "\n";
            for ($row = 2; $row <= $highestRow; ++$row) {
              echo '<tr>' . "\n";
              for ($col = 0; $col <= $highestColumnIndex; ++$col) {
                echo '<td>' . $objWorksheet->getCellByColumnAndRow($col, $row)->getValue() . '</td>' . "\n";
              }
              echo '</tr>' . "\n";
            }
            echo '</table>' . "\n";