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.