ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
19namedrange.php File Reference

Go to the source code of this file.

Namespaces

 PHPExcel
 

Variables

const EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'
 
Create new PHPExcel object
 
 $objPHPExcel = new PHPExcel()
 
Set document properties
 
Add some data
 
Define named ranges
 
Rename worksheet
 
Resolve range
 
Write to Excel2007 format
 
 $callStartTime = microtime(true)
 
 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')
 
 $callEndTime = microtime(true)
 
 $callTime = $callEndTime - $callStartTime
 
File written to
 
sprintf('%.4f', $callTime) seconds
 
memory_get_usage(true)/1024/1024) MB
 
Peak memory usage
 
Done writing file
 

Variable Documentation

◆ $callEndTime

$callEndTime = microtime(true)

Definition at line 115 of file 19namedrange.php.

◆ $callStartTime

$callStartTime = microtime(true)

Definition at line 111 of file 19namedrange.php.

◆ $callTime

$callTime = $callEndTime - $callStartTime

Definition at line 116 of file 19namedrange.php.

◆ $objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 44 of file 19namedrange.php.

◆ $objWriter

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')

Definition at line 113 of file 19namedrange.php.

◆ data

Add some data

Definition at line 58 of file 19namedrange.php.

◆ EOL

getcwd () EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'

Definition at line 34 of file 19namedrange.php.

◆ file

Done writing file

Definition at line 128 of file 19namedrange.php.

◆ format

Write to Excel2007 format

Definition at line 110 of file 19namedrange.php.

◆ MB

Peak memory memory_get_peak_usage (true)/1024/1024) MB

Definition at line 121 of file 19namedrange.php.

◆ object

Create new Worksheet object

Definition at line 39 of file 19namedrange.php.

◆ properties

Set document properties

Definition at line 47 of file 19namedrange.php.

◆ range

◆ ranges

Rename named ranges

Definition at line 68 of file 19namedrange.php.

◆ seconds

sprintf ('%.4f', $callTime) seconds

Definition at line 119 of file 19namedrange.php.

◆ to

File written to

Definition at line 118 of file 19namedrange.php.

◆ usage

Peak memory usage

Definition at line 125 of file 19namedrange.php.

◆ worksheet

Rename worksheet

Definition at line 77 of file 19namedrange.php.