08conditionalformatting2.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
Add conditional	formatting
	$objConditional1 = new PHPExcel_Style_Conditional()
	$objConditional3 = new PHPExcel_Style_Conditional()
	$conditionalStyles = $objPHPExcel->getActiveSheet()->getStyle('A1')->getConditionalStyles()
Duplicate the conditional formatting across a range of	cells
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 111 of file 08conditionalformatting2.php.

$callStartTime

$callStartTime = microtime(true)

Definition at line 107 of file 08conditionalformatting2.php.

$callTime

$callTime = $callEndTime - $callStartTime

Definition at line 112 of file 08conditionalformatting2.php.

$conditionalStyles

$conditionalStyles = $objPHPExcel->getActiveSheet()->getStyle('A1')->getConditionalStyles()

Definition at line 91 of file 08conditionalformatting2.php.

$objConditional1

$objConditional1 = new PHPExcel_Style_Conditional()

Definition at line 79 of file 08conditionalformatting2.php.

$objConditional3

$objConditional3 = new PHPExcel_Style_Conditional()

Definition at line 85 of file 08conditionalformatting2.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 43 of file 08conditionalformatting2.php.

$objWriter

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

Definition at line 109 of file 08conditionalformatting2.php.

cells

Duplicate the conditional formatting across a range of cells

Definition at line 98 of file 08conditionalformatting2.php.

data

Add some data

Definition at line 57 of file 08conditionalformatting2.php.

EOL

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

Definition at line 33 of file 08conditionalformatting2.php.

file

Done writing file

Definition at line 135 of file 08conditionalformatting2.php.

format

Write to Excel5 format

Definition at line 106 of file 08conditionalformatting2.php.

formatting

Add conditional formatting

Definition at line 78 of file 08conditionalformatting2.php.

MB

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

Definition at line 128 of file 08conditionalformatting2.php.

object

Create new PHPExcel object

Definition at line 38 of file 08conditionalformatting2.php.

properties

Set document properties

Definition at line 46 of file 08conditionalformatting2.php.

seconds

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

Definition at line 115 of file 08conditionalformatting2.php.

to

File written to

Definition at line 114 of file 08conditionalformatting2.php.

usage

Peak memory usage

Definition at line 132 of file 08conditionalformatting2.php.