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';
 
   45echo 
date(
'H:i:s') , 
" Load Tests from $inputFileType file" , 
EOL;
 
   58echo 
date(
'H:i:s') , 
" Adjust properties" , 
EOL;
 
   59$objPHPExcel->getProperties()->setTitle(
"Office 95 XLS Test Document")
 
   60                                                         ->setSubject(
"Office 95 XLS Test Document")
 
   61                                                         ->setDescription(
"Test XLS document, generated using PHPExcel")
 
   62                                                         ->setKeywords(
"office 95 biff php");
 
   66echo 
date(
'H:i:s') , 
" Write to Excel5 format" , 
EOL;
 
   68$objWriter->save(str_replace(
'.php', 
'.xls', __FILE__));
 
   69echo 
date(
'H:i:s') , 
" File written to " , str_replace(
'.php', 
'.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , 
EOL;
 
   78echo 
date(
'H:i:s') , 
" Reread Excel5 file" , 
EOL;
 
   82echo 
date(
'H:i:s') , 
" Get properties" , 
EOL;
 
   84echo 
'Core Properties:' , 
EOL;
 
   85echo 
'    Created by - ' , 
$objPHPExcel->getProperties()->getCreator() , 
EOL;
 
   86echo 
'    Created on - ' , 
date(
'd-M-Y',
$objPHPExcel->getProperties()->getCreated()) , 
' at ' ,
 
   88echo 
'    Last Modified by - ' , 
$objPHPExcel->getProperties()->getLastModifiedBy() , 
EOL;
 
   89echo 
'    Last Modified on - ' , 
date(
'd-M-Y',
$objPHPExcel->getProperties()->getModified()) , 
' at ' ,
 
   93echo 
'    Description - ' , 
$objPHPExcel->getProperties()->getDescription() , 
EOL;
 
   94echo 
'    Keywords: - ' , 
$objPHPExcel->getProperties()->getKeywords() , 
EOL;
 
   97echo 
'Extended (Application) Properties:' , 
EOL;
 
   98echo 
'    Category - ' , 
$objPHPExcel->getProperties()->getCategory() , 
EOL;
 
  103echo 
'Custom Properties:' , 
EOL;
 
  106        $propertyValue = 
$objPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
 
  107        $propertyType = 
$objPHPExcel->getProperties()->getCustomPropertyType($customProperty);
 
  108        echo 
'    ' , $customProperty , 
' - (' , $propertyType , 
') - ';
 
  110                echo 
date(
'd-M-Y H:i:s',$propertyValue) , 
EOL;
 
  112                echo (($propertyValue) ? 
'TRUE' : 
'FALSE') , 
EOL;
 
  114                echo $propertyValue , 
EOL;
 
memory_get_peak_usage(true)/1024/1024)
$inputFileType
Include PHPExcel.
date( 'd-M-Y', $objPHPExcel->getProperties() ->getCreated())
memory_get_usage(true)/1024/1024)
sprintf('%.4f', $callTime)
An exception for terminatinating execution or to throw for unit testing.
const PROPERTY_TYPE_BOOLEAN
constants
static createWriter(PHPExcel $phpExcel, $writerType='')
Create PHPExcel_Writer_IWriter.
static createReader($readerType='')
Create PHPExcel_Reader_IReader.
static load($pFilename)
Loads PHPExcel from file using automatic PHPExcel_Reader_IReader resolution.