mergeExcel

<?php

/** PHPExcel */
require_once 'Classes/PHPExcel.php';

/** PHPExcel_IOFactory - Reader */
include 'Classes/PHPExcel/IOFactory.php';
// print_r($_POST['file']);
// exit();
$namedDataArray = array();
$r = -1;
foreach ($_POST['file'] as $filename) {
    # code...
$inputFileName = $filename;
$inputFileType = PHPExcel_IOFactory::identify($inputFileName);

$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($inputFileName);

$objWorksheet = $objPHPExcel->setActiveSheetIndex(0);
$highestRow = $objWorksheet->getHighestRow();
$highestColumn = $objWorksheet->getHighestColumn();

$headingsArray = $objWorksheet->rangeToArray('A1:'.$highestColumn.'1',null, true, true, true);
$headingsArray = $headingsArray[1];




$i = 0;
for ($row = 2; $row <= $highestRow; ++$row) {
    $dataRow = $objWorksheet->rangeToArray('A'.$row.':'.$highestColumn.$row,null, true, true, true);
    // print_r($dataRow);
    // echo "<br>";
    if ((isset($dataRow[$row]['A'])) && ($dataRow[$row]['A'] > '')) {
        ++$r;
        foreach($headingsArray as $columnKey => $columnHeading) {
            $namedDataArray[$r][$columnHeading] = $dataRow[$row][$columnKey];

        }
        // print_r($namedDataArray);
        // echo "<br>";

        //echo "$i\n";
    }


}
}
// $objReader = PHPExcel_IOFactory::createReader();

  // Create new PHPExcel object
        $objPHPExcel = new PHPExcel();

        // Fill worksheet from values in array
        $objPHPExcel->getActiveSheet()->fromArray($namedDataArray, null, 'A1');

       $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
        $objWriter->save('output.xlsx');

// $obj = $objReader->load($namedDataArray);
// print_r($namedDataArray);
// $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel1, "Excel5");
// header("Content-Type: application/vnd.ms-excel");
// header("Content-Disposition: attachment; filename=$outputFile");
// header("Cache-Control: max-age=0");
// $objWriter->save('php://output');

// $merge = $objPHPExcel->getActiveSheet()->fromArray($namedDataArray, null, 'A1');
// $objPHPExcelWriter = PHPExcel_IOFactory::createWriter($merge);
// $objPHPExcelWriter->save('output');
?>
<table width="500" border="1">
  <tr>
    <td>CustomerID</td>
    <td>Name</td>
    <td>Email</td>
    <td>CountryCode</td>
    <td>Budget</td>
    <td>Used</td>
  </tr>
<?php
foreach ($namedDataArray as $result) {
?>
      <tr>
        <td><?=$result["CustomerID"];?></td>
        <td><?=$result["Name"];?></td>
        <td><?=$result["Email"];?></td>
        <td><?=$result["CountryCode"];?></td>
        <td><?=$result["Budget"];?></td>
        <td><?=$result["Used"];?></td>
      </tr>
<?php
}
?>
</table>