29error_reporting(E_ALL);
 
   30ini_set(
'display_errors', TRUE);
 
   31ini_set(
'display_startup_errors', TRUE);
 
   33define(
'EOL',(PHP_SAPI == 
'cli') ? 
PHP_EOL : 
'<br />');
 
   35date_default_timezone_set(
'Europe/London');
 
   38require_once dirname(__FILE__) . 
'/../Classes/PHPExcel.php';
 
   42echo 
date(
'H:i:s') , 
" Create new PHPExcel object" , 
EOL;
 
   46echo 
date(
'H:i:s') , 
" Set document properties" , 
EOL;
 
   47$objPHPExcel->getProperties()->setCreator(
"Maarten Balliauw")
 
   48                                                         ->setLastModifiedBy(
"Maarten Balliauw")
 
   49                                                         ->setTitle(
"Office 2007 XLSX Test Document")
 
   50                                                         ->setSubject(
"Office 2007 XLSX Test Document")
 
   51                                                         ->setDescription(
"Test document for Office 2007 XLSX, generated using PHP classes.")
 
   52                                                         ->setKeywords(
"office 2007 openxml php")
 
   53                                                         ->setCategory(
"Test result file");
 
   57echo 
date(
'H:i:s') , 
" Add some data" , 
EOL;
 
   58for ($i = 1; $i < 200; $i++) {
 
   59        $objPHPExcel->getActiveSheet()->setCellValue(
'A' . $i, $i);
 
   60        $objPHPExcel->getActiveSheet()->setCellValue(
'B' . $i, 
'Test value');
 
   64echo 
date(
'H:i:s') , 
" Set header/footer" , 
EOL;
 
   65$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader(
'&L&G&C&HPlease treat this document as confidential!');
 
   66$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter(
'&L&B' . 
$objPHPExcel->getProperties()->getTitle() . 
'&RPage &P of &N');
 
   69echo 
date(
'H:i:s') , 
" Add a drawing to the header" , 
EOL;
 
   77echo 
date(
'H:i:s') , 
" Set page orientation and size" , 
EOL;
 
   82echo 
date(
'H:i:s') , 
" Rename worksheet" , 
EOL;
 
   91echo 
date(
'H:i:s') , 
" Write to Excel2007 format" , 
EOL;
 
   95$objWriter->save(str_replace(
'.php', 
'.xlsx', __FILE__));
 
   99echo 
date(
'H:i:s') , 
" File written to " , str_replace(
'.php', 
'.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , 
EOL;
 
  106echo 
date(
'H:i:s') , 
" Write to Excel5 format" , 
EOL;
 
  110$objWriter->save(str_replace(
'.php', 
'.xls', __FILE__));
 
  114echo 
date(
'H:i:s') , 
" File written to " , str_replace(
'.php', 
'.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , 
EOL;
 
  124echo 
date(
'H:i:s') , 
" Done writing files" , 
EOL;
 
  125echo 
'Files have been created in ' , getcwd() , 
EOL;
 
memory_get_peak_usage(true)/1024/1024)
memory_get_usage(true)/1024/1024)
sprintf('%.4f', $callTime)
date( 'd-M-Y', $objPHPExcel->getProperties() ->getCreated())
An exception for terminatinating execution or to throw for unit testing.
static createWriter(PHPExcel $phpExcel, $writerType='')
Create PHPExcel_Writer_IWriter.
const ORIENTATION_LANDSCAPE