06largescale-with-cellcaching-sqlite3.php File Reference

Go to the source code of this file.

Namespaces
	PHPExcel

Variables
const	EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'
	$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_sqlite3
	Include PHPExcel. More...
if(PHPExcel_Settings::setCacheStorageMethod($cacheMethod))	else
Create new PHPExcel	object
	$objPHPExcel = new PHPExcel()
Set	properties
Add	data
Hide and	columns
Set outline	levels
Freeze	panes
Rows to repeat at	top
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

$cacheMethod

$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_sqlite3

Include PHPExcel.

Definition at line 40 of file 06largescale-with-cellcaching-sqlite3.php.

$callEndTime

$callEndTime = microtime(true)

Definition at line 115 of file 06largescale-with-cellcaching-sqlite3.php.

$callStartTime

$callStartTime = microtime(true)

Definition at line 111 of file 06largescale-with-cellcaching-sqlite3.php.

$callTime

$callTime = $callEndTime - $callStartTime

Definition at line 116 of file 06largescale-with-cellcaching-sqlite3.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 50 of file 06largescale-with-cellcaching-sqlite3.php.

$objWriter

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

Definition at line 113 of file 06largescale-with-cellcaching-sqlite3.php.

columns

Hide and columns

Definition at line 74 of file 06largescale-with-cellcaching-sqlite3.php.

data

Add data

Definition at line 64 of file 06largescale-with-cellcaching-sqlite3.php.

else

if (PHPExcel_Settings::setCacheStorageMethod( $cacheMethod)) else

Initial value:

{
    echo date('H:i:s') , " Unable to set Cell Caching using " , $cacheMethod , " method, reverting to memory" , EOL

Definition at line 43 of file 06largescale-with-cellcaching-sqlite3.php.

EOL

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

Definition at line 33 of file 06largescale-with-cellcaching-sqlite3.php.

file

Done writing file

Definition at line 128 of file 06largescale-with-cellcaching-sqlite3.php.

format

Write to Excel2007 format

Definition at line 110 of file 06largescale-with-cellcaching-sqlite3.php.

levels

Set outline levels

Definition at line 80 of file 06largescale-with-cellcaching-sqlite3.php.

MB

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

Definition at line 121 of file 06largescale-with-cellcaching-sqlite3.php.

object

Create new PHPExcel object

Definition at line 49 of file 06largescale-with-cellcaching-sqlite3.php.

panes

Freeze panes

Definition at line 86 of file 06largescale-with-cellcaching-sqlite3.php.

properties

Set properties

Definition at line 53 of file 06largescale-with-cellcaching-sqlite3.php.

seconds

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

Definition at line 119 of file 06largescale-with-cellcaching-sqlite3.php.

to

File written to

Definition at line 118 of file 06largescale-with-cellcaching-sqlite3.php.

top

Rows to repeat at top

Definition at line 91 of file 06largescale-with-cellcaching-sqlite3.php.

usage

Peak memory usage

Definition at line 125 of file 06largescale-with-cellcaching-sqlite3.php.