ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
04printing.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// Create new PHPExcel object
42echo date('H:i:s') , " Create new PHPExcel object" , EOL;
44
45// Set document properties
46echo date('H:i:s') , " Set document properties" , EOL;
47$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
48 ->setLastModifiedBy("Maarten Balliauw")
49 ->setTitle("Office 2007 XLSX Test Document")
50 ->setSubject("Office 2007 XLSX Test Document")
51 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
52 ->setKeywords("office 2007 openxml php")
53 ->setCategory("Test result file");
54
55
56// Add some data, we will use printing features
57echo date('H:i:s') , " Add some data" , EOL;
58for ($i = 1; $i < 200; $i++) {
59 $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
60 $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
61}
62
63// Set header and footer. When no different headers for odd/even are used, odd header is assumed.
64echo date('H:i:s') , " Set header/footer" , EOL;
65$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&G&C&HPlease treat this document as confidential!');
66$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');
67
68// Add a drawing to the header
69echo date('H:i:s') , " Add a drawing to the header" , EOL;
71$objDrawing->setName('PHPExcel logo');
72$objDrawing->setPath('./images/phpexcel_logo.gif');
73$objDrawing->setHeight(36);
74$objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, PHPExcel_Worksheet_HeaderFooter::IMAGE_HEADER_LEFT);
75
76// Set page orientation and size
77echo date('H:i:s') , " Set page orientation and size" , EOL;
78$objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
79$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
80
81// Rename worksheet
82echo date('H:i:s') , " Rename worksheet" , EOL;
83$objPHPExcel->getActiveSheet()->setTitle('Printing');
84
85
86// Set active sheet index to the first sheet, so Excel opens this as the first sheet
87$objPHPExcel->setActiveSheetIndex(0);
88
89
90// Save Excel 2007 file
91echo date('H:i:s') , " Write to Excel2007 format" , EOL;
92$callStartTime = microtime(true);
93
95$objWriter->save(str_replace('.php', '.xlsx', __FILE__));
96$callEndTime = microtime(true);
98
99echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
100echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
101// Echo memory usage
102echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
103
104
105// Save Excel 95 file
106echo date('H:i:s') , " Write to Excel5 format" , EOL;
107$callStartTime = microtime(true);
108
110$objWriter->save(str_replace('.php', '.xls', __FILE__));
111$callEndTime = microtime(true);
113
114echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
115echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
116// Echo memory usage
117echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
118
119
120// Echo memory peak usage
121echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
122
123// Echo done
124echo date('H:i:s') , " Done writing files" , EOL;
125echo 'Files have been created in ' , getcwd() , EOL;
memory_get_peak_usage(true)/1024/1024)
Definition: 04printing.php:121
const EOL
Definition: 04printing.php:33
$callEndTime
Definition: 04printing.php:96
$callTime
Definition: 04printing.php:97
$objDrawing
Definition: 04printing.php:70
$callStartTime
Definition: 04printing.php:92
memory_get_usage(true)/1024/1024)
Definition: 04printing.php:102
$objWriter
Definition: 04printing.php:94
$objPHPExcel
Definition: 04printing.php:43
sprintf('%.4f', $callTime)
Definition: 04printing.php:100
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