<?php
	ini_set('include_path', ini_get('include_path').';../Classes/');
	require_once 'PHPExcel.php';
	require_once 'PHPExcel/IOFactory.php';
	//include 'PHPExcel/Writer/Excel2007.php';

// Create new PHPExcel object
for($r=0;$r<=5;$r++)
{
	$objPHPExcel = new PHPExcel();
	
	for($y=0;$y<=5;$y++)
	{
		// Create a first sheet, representing sales data
		$objPHPExcel->setActiveSheetIndex($y);
		$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Something');
		// Rename sheet
		$objPHPExcel->getActiveSheet()->setTitle('Name of Sheet '.$y);

		// Create a new worksheet, after the default sheet
		$objPHPExcel->createSheet();
	}

	// Redirect output to a client’s web browser (Excel5)
	header('Content-Type: application/vnd.ms-excel');
	header('Content-Disposition: attachment;filename="name_of_file'.$r.'.xls"');
	header('Cache-Control: max-age=0');
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
	$objWriter->save('php://output');
	
		//$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
		//$objWriter->save(dirname($file).'/file.xlsx');
	$objPHPExcel->disconnectWorksheets();
	unset($objPHPExcel);
}
?>

скопировать код в буфер обмена
//header('Content-Type: application/vnd.ms-excel');
//header('Content-Disposition: attachment;filename="name_of_file'.$r.'.xls"');
//header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save($r.'.xls');