ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
01pharSimple.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);
32date_default_timezone_set('Europe/London');
33
34define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
35
37require_once '../Build/PHPExcel.phar';
38
39
40// Create new PHPExcel object
41echo date('H:i:s') , " Create new PHPExcel object" , EOL;
43
44// Set document properties
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");
53
54
55// Add some data
56echo date('H:i:s') , " Add some data" , EOL;
57$objPHPExcel->setActiveSheetIndex(0)
58 ->setCellValue('A1', 'Hello')
59 ->setCellValue('B2', 'world!')
60 ->setCellValue('C1', 'Hello')
61 ->setCellValue('D2', 'world!');
62
63// Miscellaneous glyphs, UTF-8
64$objPHPExcel->setActiveSheetIndex(0)
65 ->setCellValue('A4', 'Miscellaneous glyphs')
66 ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç');
67
68// Rename worksheet
69echo date('H:i:s') , " Rename worksheet" , EOL;
70$objPHPExcel->getActiveSheet()->setTitle('Simple');
71
72
73// Set active sheet index to the first sheet, so Excel opens this as the first sheet
74$objPHPExcel->setActiveSheetIndex(0);
75
76
77// Save Excel 2007 file
78echo date('H:i:s') , " Write to Excel2007 format" , EOL;
79$callStartTime = microtime(true);
80
82$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
83$callEndTime = microtime(true);
85
86echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
87echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
88// Echo memory usage
89echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
90
91
92// Save Excel5 file
93echo date('H:i:s') , " Write to Excel5 format" , EOL;
94$callStartTime = microtime(true);
95
97$objWriter->save(str_replace('.php', '.xls', __FILE__));
98$callEndTime = microtime(true);
100
101echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
102echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
103// Echo memory usage
104echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
105
106
107// Echo memory peak usage
108echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
109
110// Echo done
111echo date('H:i:s') , " Done writing files" , EOL;
112echo 'Files have been created in ' , getcwd() , EOL;
const EOL
$callEndTime
memory_get_peak_usage(true)/1024/1024)
$callTime
$callStartTime
memory_get_usage(true)/1024/1024)
$objWriter
$objPHPExcel
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.
Definition: IOFactory.php:132