ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
31docproperties_write-xls.php
Go to the documentation of this file.
1<?php
29error_reporting(E_ALL);
30ini_set('display_errors', TRUE);
31ini_set('display_startup_errors', TRUE);
32
33define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
34
35date_default_timezone_set('Europe/London');
36
38require_once dirname(__FILE__) . '/../Classes/PHPExcel.php';
39
40
41$inputFileType = 'Excel5';
42$inputFileName = 'templates/31docproperties.xls';
43
44
45echo date('H:i:s') , " Load Tests from $inputFileType file" , EOL;
46$callStartTime = microtime(true);
47
50
51$callEndTime = microtime(true);
53echo 'Call time to read Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
54// Echo memory usage
55echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
56
57
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");
63
64
65// Save Excel 95 file
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;
70
71
72// Echo memory peak usage
73echo date('H:i:s') , " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB" , EOL;
74
75
76echo EOL;
77// Reread File
78echo date('H:i:s') , " Reread Excel5 file" , EOL;
79$objPHPExcelRead = PHPExcel_IOFactory::load(str_replace('.php', '.xls', __FILE__));
80
81// Set properties
82echo date('H:i:s') , " Get properties" , EOL;
83
84echo 'Core Properties:' , EOL;
85echo ' Created by - ' , $objPHPExcel->getProperties()->getCreator() , EOL;
86echo ' Created on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getCreated()) , ' at ' ,
87 date('H:i:s',$objPHPExcel->getProperties()->getCreated()) , EOL;
88echo ' Last Modified by - ' , $objPHPExcel->getProperties()->getLastModifiedBy() , EOL;
89echo ' Last Modified on - ' , date('d-M-Y',$objPHPExcel->getProperties()->getModified()) , ' at ' ,
90 date('H:i:s',$objPHPExcel->getProperties()->getModified()) , EOL;
91echo ' Title - ' , $objPHPExcel->getProperties()->getTitle() , EOL;
92echo ' Subject - ' , $objPHPExcel->getProperties()->getSubject() , EOL;
93echo ' Description - ' , $objPHPExcel->getProperties()->getDescription() , EOL;
94echo ' Keywords: - ' , $objPHPExcel->getProperties()->getKeywords() , EOL;
95
96
97echo 'Extended (Application) Properties:' , EOL;
98echo ' Category - ' , $objPHPExcel->getProperties()->getCategory() , EOL;
99echo ' Company - ' , $objPHPExcel->getProperties()->getCompany() , EOL;
100echo ' Manager - ' , $objPHPExcel->getProperties()->getManager() , EOL;
101
102
103echo 'Custom Properties:' , EOL;
104$customProperties = $objPHPExcel->getProperties()->getCustomProperties();
105foreach($customProperties as $customProperty) {
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;
111 } elseif ($propertyType == PHPExcel_DocumentProperties::PROPERTY_TYPE_BOOLEAN) {
112 echo (($propertyValue) ? 'TRUE' : 'FALSE') , EOL;
113 } else {
114 echo $propertyValue , EOL;
115 }
116}
117
118// Echo memory peak usage
119echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) . " MB" , 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.
static createWriter(PHPExcel $phpExcel, $writerType='')
Create PHPExcel_Writer_IWriter.
Definition: IOFactory.php:132
static createReader($readerType='')
Create PHPExcel_Reader_IReader.
Definition: IOFactory.php:161
static load($pFilename)
Loads PHPExcel from file using automatic PHPExcel_Reader_IReader resolution.
Definition: IOFactory.php:190