Namespaces
	PHPExcel

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

	$objPHPExcel = new PHPExcel()
	Include PHPExcel. More...

	$startYear = $endYear = $currentYear = date('Y')

	$endYear

	$years = range($startYear,$endYear)

	$periods = range(1,12)

	$countries

	$row = 2

	$autoFilter = $objPHPExcel->getActiveSheet()->getAutoFilter()

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

Variable Documentation

◆ $autoFilter

$autoFilter = $objPHPExcel->getActiveSheet()->getAutoFilter()

Definition at line 134 of file 10autofilter-selection-2.php.

◆ $callEndTime

$callEndTime = microtime(true)

Definition at line 184 of file 10autofilter-selection-2.php.

◆ $callStartTime

$callStartTime = microtime(true)

Definition at line 180 of file 10autofilter-selection-2.php.

◆ $callTime

$callTime = $callEndTime - $callStartTime

Definition at line 185 of file 10autofilter-selection-2.php.

◆ $countries

$countries

Initial value:

= array(        'United States',        'UK',           'France',       'Germany',
                                        'Italy',                        'Spain',        'Portugal',     'Japan'
                                  )