29error_reporting(E_ALL);
 
   30ini_set(
'display_errors', TRUE);
 
   31ini_set(
'display_startup_errors', TRUE);
 
   32date_default_timezone_set(
'Europe/London');
 
   34define(
'EOL',(PHP_SAPI == 
'cli') ? 
PHP_EOL : 
'<br />');
 
   37require_once 
'../Build/PHPExcel.phar';
 
   41echo 
date(
'H:i:s') , 
" Create new PHPExcel object" , 
EOL;
 
   45echo 
date(
'H:i:s') , 
" Set document properties" , 
EOL;
 
   46$objPHPExcel->getProperties()->setCreator(
"Maarten Balliauw")
 
   47                                                         ->setLastModifiedBy(
"Maarten Balliauw")
 
   48                                                         ->setTitle(
"PHPExcel Test Document")
 
   49                                                         ->setSubject(
"PHPExcel Test Document")
 
   50                                                         ->setDescription(
"Test document for PHPExcel, generated using PHP classes.")
 
   51                                                         ->setKeywords(
"office PHPExcel php")
 
   52                                                         ->setCategory(
"Test result file");
 
   56echo 
date(
'H:i:s') , 
" Add some data" , 
EOL;
 
   58            ->setCellValue(
'A1', 
'Hello')
 
   59            ->setCellValue(
'B2', 
'world!')
 
   60            ->setCellValue(
'C1', 
'Hello')
 
   61            ->setCellValue(
'D2', 
'world!');
 
   65            ->setCellValue(
'A4', 
'Miscellaneous glyphs')
 
   66            ->setCellValue(
'A5', 
'éàèùâêîôûëïüÿäöüç');
 
   69echo 
date(
'H:i:s') , 
" Rename worksheet" , 
EOL;
 
   78echo 
date(
'H:i:s') , 
" Write to Excel2007 format" , 
EOL;
 
   82$objWriter->save(str_replace(
'.php', 
'.xlsx', __FILE__));
 
   86echo 
date(
'H:i:s') , 
" File written to " , str_replace(
'.php', 
'.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , 
EOL;
 
   93echo 
date(
'H:i:s') , 
" Write to Excel5 format" , 
EOL;
 
   97$objWriter->save(str_replace(
'.php', 
'.xls', __FILE__));
 
  101echo 
date(
'H:i:s') , 
" File written to " , str_replace(
'.php', 
'.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , 
EOL;
 
  111echo 
date(
'H:i:s') , 
" Done writing files" , 
EOL;
 
  112echo 
'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.