15datavalidation-xls.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	data
Set data	validation
	$objValidation = $objPHPExcel->getActiveSheet()->getCell('B3')->getDataValidation()
Write to Excel5	format
	$callStartTime = microtime(true)
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5')
	$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 128 of file 15datavalidation-xls.php.

$callStartTime

$callStartTime = microtime(true)

Definition at line 124 of file 15datavalidation-xls.php.

$callTime

$callTime = $callEndTime - $callStartTime

Definition at line 129 of file 15datavalidation-xls.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 44 of file 15datavalidation-xls.php.

$objValidation

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

Definition at line 78 of file 15datavalidation-xls.php.

Referenced by PHPExcel_Reader_Excel5\_readDataValidation().

$objWriter

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

Definition at line 126 of file 15datavalidation-xls.php.

data

Add data

Definition at line 59 of file 15datavalidation-xls.php.

EOL

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

Definition at line 34 of file 15datavalidation-xls.php.

file

Done writing file

Definition at line 141 of file 15datavalidation-xls.php.

format

Write to Excel5 format

Definition at line 123 of file 15datavalidation-xls.php.

MB

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

Definition at line 134 of file 15datavalidation-xls.php.

object

Create new PHPExcel object

Definition at line 39 of file 15datavalidation-xls.php.

properties

Set document properties

Definition at line 48 of file 15datavalidation-xls.php.

seconds

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

Definition at line 132 of file 15datavalidation-xls.php.

to

File written to

Definition at line 131 of file 15datavalidation-xls.php.

usage

Peak memory usage

Definition at line 138 of file 15datavalidation-xls.php.

validation

Set data validation

Definition at line 77 of file 15datavalidation-xls.php.

Referenced by ilExportIDTableGUI\__construct(), ilHelpMappingTableGUI\__construct(), ilConditionHandler\__construct(), ilConditionHandler\enableAutomaticValidation(), ilExportIDTableGUI\fillRow(), and ilConditionHandler\storeCondition().