08conditionalformatting.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
Set column	widths
Add conditional	formatting
	$objConditional1 = new PHPExcel_Style_Conditional()
	$objConditional2 = new PHPExcel_Style_Conditional()
	$objConditional3 = new PHPExcel_Style_Conditional()
	$conditionalStyles = $objPHPExcel->getActiveSheet()->getStyle('B2')->getConditionalStyles()
Duplicate the conditional formatting across a range of	cells
Set	fonts
Set header	footer
Set page orientation and	size
Rename	worksheet
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 164 of file 08conditionalformatting.php.

$callStartTime

$callStartTime = microtime(true)

Definition at line 160 of file 08conditionalformatting.php.

$callTime

$callTime = $callEndTime - $callStartTime

Definition at line 165 of file 08conditionalformatting.php.

$conditionalStyles

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

Definition at line 114 of file 08conditionalformatting.php.

Referenced by PHPExcel_Writer_Excel5_Worksheet\_writeCFHeader(), PHPExcel_Writer_Excel2007_Worksheet\_writeConditionalFormatting(), PHPExcel_Writer_Excel2007_Style\allConditionalStyles(), PHPExcel_Writer_Excel5_Worksheet\close(), PHPExcel_ReferenceHelper\insertNewBefore(), and PHPExcel_Reader_Excel2007\load().

$objConditional1

$objConditional1 = new PHPExcel_Style_Conditional()

Definition at line 89 of file 08conditionalformatting.php.

$objConditional2

$objConditional2 = new PHPExcel_Style_Conditional()

Definition at line 98 of file 08conditionalformatting.php.

$objConditional3

$objConditional3 = new PHPExcel_Style_Conditional()

Definition at line 106 of file 08conditionalformatting.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 43 of file 08conditionalformatting.php.

$objWriter

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

Definition at line 162 of file 08conditionalformatting.php.

cells

Duplicate the conditional formatting across a range of cells

Definition at line 122 of file 08conditionalformatting.php.

data

Add some data

Definition at line 57 of file 08conditionalformatting.php.

EOL

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

Definition at line 33 of file 08conditionalformatting.php.

file

Done writing file

Definition at line 188 of file 08conditionalformatting.php.

fonts

Set fonts

Definition at line 130 of file 08conditionalformatting.php.

footer

Set header footer

Definition at line 138 of file 08conditionalformatting.php.

format

Write to Excel5 format

Definition at line 159 of file 08conditionalformatting.php.

formatting

Add conditional formatting

Definition at line 88 of file 08conditionalformatting.php.

Referenced by Assetic\Filter\GoogleClosure\CompilerApiFilter\filterDump(), Assetic\Filter\GoogleClosure\CompilerJarFilter\filterDump(), HTML5TreeConstructer\getElementCategory(), HTMLPurifier_ElementDef\mergeIn(), and Assetic\Filter\GoogleClosure\BaseCompilerFilter\setFormatting().

MB

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

Definition at line 181 of file 08conditionalformatting.php.

object

Create new PHPExcel object

Definition at line 38 of file 08conditionalformatting.php.

properties

Set document properties

Definition at line 46 of file 08conditionalformatting.php.

seconds

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

Definition at line 168 of file 08conditionalformatting.php.

size

Set page orientation and size

Definition at line 144 of file 08conditionalformatting.php.

to

File written to

Definition at line 167 of file 08conditionalformatting.php.

usage

Peak memory usage

Definition at line 185 of file 08conditionalformatting.php.

widths

Set column widths

Definition at line 82 of file 08conditionalformatting.php.

worksheet

Rename worksheet

Definition at line 150 of file 08conditionalformatting.php.