Namespaces
	PHPExcel

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

Create new PHPExcel	object

	$objPHPExcel = new PHPExcel()

Set document	properties

Add	data

Set data	validation

	$objValidation = $objPHPExcel->getActiveSheet()->getCell('B3')->getDataValidation()

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 129 of file 15datavalidation.php.

◆ $callStartTime

$callStartTime = microtime(true)

Definition at line 125 of file 15datavalidation.php.

◆ $callTime

$callTime = $callEndTime - $callStartTime

Definition at line 130 of file 15datavalidation.php.

◆ $objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 44 of file 15datavalidation.php.

◆ $objValidation

$objValidation = $objPHPExcel->getActiveSheet()->getCell('B3')->getDataValidation()

Definition at line 78 of file 15datavalidation.php.

◆ $objWriter

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

Definition at line 127 of file 15datavalidation.php.

◆ data

Add data

Definition at line 59 of file 15datavalidation.php.

◆ EOL

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

Definition at line 34 of file 15datavalidation.php.

◆ file

Done writing file

Definition at line 142 of file 15datavalidation.php.

◆ format

Write to Excel2007 format

Definition at line 124 of file 15datavalidation.php.

◆ MB

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

Definition at line 135 of file 15datavalidation.php.

◆ object

Create new PHPExcel object

Definition at line 39 of file 15datavalidation.php.

◆ properties

Set document properties

Definition at line 48 of file 15datavalidation.php.

◆ seconds

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

Definition at line 133 of file 15datavalidation.php.

◆ to

File written to

Definition at line 132 of file 15datavalidation.php.

◆ usage

Peak memory usage

Definition at line 139 of file 15datavalidation.php.

◆ validation

Set data validation

Definition at line 77 of file 15datavalidation.php.

Namespaces

Variables