<?php
function exportDataToXLSX()
{
   require_once(dirname(__FILE__) . "/../Classes//PHPExcel.php");
   require_once(dirname(__FILE__) . "/../Classes/PHPExcel/Writer/Excel2007.php");
 
   $outputFileName = 'so.xlsx'; //TODO hash pour le nom
   $outputFilePath = dirname(__FILE__) . '/so/' . $outputFileName;
   //$outputFilePath = 'so/' . $outputFileName;
   $outputFileType = 'Excel2007';
 
   //Creates a PHPExcel object
   $objPHPExcel = new PHPExcel();
 
   //– Les Données
   $objPHPExcel->setActiveSheetIndex(0);
   $activeSheet = $objPHPExcel->getActiveSheet();
   $activeSheet->setCellValueByColumnAndRow(1, 1, "Test");
 
   //– On sauvegarde notre fichier (Format Excel 2007)
   $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
   $objWriter->save($outputFilePath);
 
   header("Content-Disposition: attachment; filename=\"" . basename($outputFilePath) . "\"");
   header("Content-Type: application/force-download");
   header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=utf-8');
   header("Content-Length: " . filesize($outputFilePath));
   header("Connection: close");
 
   @readfile($outputFilePath);
   exit();
}
 
exportDataToXLSX();
?>

PD9waHAKZnVuY3Rpb24gZXhwb3J0RGF0YVRvWExTWCgpCnsKICAgcmVxdWlyZV9vbmNlKGRpcm5hbWUoX19GSUxFX18pIC4gIi8uLi9DbGFzc2VzLy9QSFBFeGNlbC5waHAiKTsKICAgcmVxdWlyZV9vbmNlKGRpcm5hbWUoX19GSUxFX18pIC4gIi8uLi9DbGFzc2VzL1BIUEV4Y2VsL1dyaXRlci9FeGNlbDIwMDcucGhwIik7CiAgIAogICAkb3V0cHV0RmlsZU5hbWUgPSAnc28ueGxzeCc7IC8vVE9ETyBoYXNoIHBvdXIgbGUgbm9tCiAgICRvdXRwdXRGaWxlUGF0aCA9IGRpcm5hbWUoX19GSUxFX18pIC4gJy9zby8nIC4gJG91dHB1dEZpbGVOYW1lOwogICAvLyRvdXRwdXRGaWxlUGF0aCA9ICdzby8nIC4gJG91dHB1dEZpbGVOYW1lOwogICAkb3V0cHV0RmlsZVR5cGUgPSAnRXhjZWwyMDA3JzsKCiAgIC8vQ3JlYXRlcyBhIFBIUEV4Y2VsIG9iamVjdAogICAkb2JqUEhQRXhjZWwgPSBuZXcgUEhQRXhjZWwoKTsKCiAgIC8v4oCTIExlcyBEb25uw6llcwogICAkb2JqUEhQRXhjZWwtPnNldEFjdGl2ZVNoZWV0SW5kZXgoMCk7CiAgICRhY3RpdmVTaGVldCA9ICRvYmpQSFBFeGNlbC0+Z2V0QWN0aXZlU2hlZXQoKTsKICAgJGFjdGl2ZVNoZWV0LT5zZXRDZWxsVmFsdWVCeUNvbHVtbkFuZFJvdygxLCAxLCAiVGVzdCIpOwoKICAgLy/igJMgT24gc2F1dmVnYXJkZSBub3RyZSBmaWNoaWVyIChGb3JtYXQgRXhjZWwgMjAwNykKICAgJG9ialdyaXRlciA9IG5ldyBQSFBFeGNlbF9Xcml0ZXJfRXhjZWwyMDA3KCRvYmpQSFBFeGNlbCk7CiAgICRvYmpXcml0ZXItPnNhdmUoJG91dHB1dEZpbGVQYXRoKTsKCiAgIGhlYWRlcigiQ29udGVudC1EaXNwb3NpdGlvbjogYXR0YWNobWVudDsgZmlsZW5hbWU9XCIiIC4gYmFzZW5hbWUoJG91dHB1dEZpbGVQYXRoKSAuICJcIiIpOwogICBoZWFkZXIoIkNvbnRlbnQtVHlwZTogYXBwbGljYXRpb24vZm9yY2UtZG93bmxvYWQiKTsKICAgaGVhZGVyKCdDb250ZW50LVR5cGU6IGFwcGxpY2F0aW9uL3ZuZC5vcGVueG1sZm9ybWF0cy1vZmZpY2Vkb2N1bWVudC5zcHJlYWRzaGVldG1sLnNoZWV0OyBjaGFyc2V0PXV0Zi04Jyk7CiAgIGhlYWRlcigiQ29udGVudC1MZW5ndGg6ICIgLiBmaWxlc2l6ZSgkb3V0cHV0RmlsZVBhdGgpKTsKICAgaGVhZGVyKCJDb25uZWN0aW9uOiBjbG9zZSIpOwoKICAgQHJlYWRmaWxlKCRvdXRwdXRGaWxlUGF0aCk7CiAgIGV4aXQoKTsKfQoKZXhwb3J0RGF0YVRvWExTWCgpOwo/Pg==