02types-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
Set default	font
Add some	data
	$dateTimeNow = time()
	$objRichText = new PHPExcel_RichText()
	$objPayable = $objRichText->createTextRun('你 好 吗？')
	$objRichText2 = new PHPExcel_RichText()
	$objRed = $objRichText2->createTextRun("red text")
Rename	worksheet
Write to Excel5	format
	$callStartTime = microtime(true)
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5')
File written	to
	$callEndTime = microtime(true)
	$callTime = $callEndTime - $callStartTime
sprintf('%.4f', $callTime)	seconds
memory_get_usage(true)/1024/1024)	MB
Reload workbook from saved	file
Peak memory	usage

Variable Documentation

$callEndTime

$callEndTime = microtime(true)

Definition at line 154 of file 02types-xls.php.

$callStartTime

$callStartTime = microtime(true)

Definition at line 149 of file 02types-xls.php.

$callTime

$callTime = $callEndTime - $callStartTime

Definition at line 155 of file 02types-xls.php.

$dateTimeNow

$dateTimeNow = time()

Definition at line 93 of file 02types-xls.php.

$objPayable

$objPayable = $objRichText->createTextRun('你 好 吗？')

Definition at line 114 of file 02types-xls.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 42 of file 02types-xls.php.

$objRed

$objRed = $objRichText2->createTextRun("red text")

Definition at line 128 of file 02types-xls.php.

$objRichText

$objRichText = new PHPExcel_RichText()

Definition at line 112 of file 02types-xls.php.

Referenced by DefaultValueBinderTest\testDataTypeForRichTextObject().

$objRichText2

$objRichText2 = new PHPExcel_RichText()

Definition at line 125 of file 02types-xls.php.

$objWriter

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

Definition at line 151 of file 02types-xls.php.

data

Add some data

Definition at line 60 of file 02types-xls.php.

EOL

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

Definition at line 34 of file 02types-xls.php.

file

Done writing file

Definition at line 163 of file 02types-xls.php.

Referenced by testDataFileIterator\__construct(), ilSimpleXMLTableDataParser\__construct(), ilPortfolioExerciseGUI\__construct(), ilBlogExerciseGUI\__construct(), LangCheck\__construct(), ilICalParser\__construct(), ilFileXMLParser\__construct(), ilLanguage\__construct(), Slim\Http\UploadedFile\__construct(), testDataFileIterator\__destruct(), testDataFileIterator\_parseNextDataset(), ilObjLanguage\check(), ilObjLanguageFolder\checkAllLanguages(), ilLanguage\checkLanguage(), ilSCORM13Package\dbImportSco(), ilUpdateUtilsMailMigration\delDir(), ilUpdateUtils\delDir(), ILIAS\FileDelivery\FileDeliveryTypes\PHP\deliver(), ilSubversionInformation\detect(), MagicConfig\detect_awk(), MagicConfig\detect_bash(), MagicConfig\detect_bmp(), MagicConfig\detect_cpp(), MagicConfig\detect_diff(), MagicConfig\detect_env(), MagicConfig\detect_genericshell(), MagicConfig\detect_gif(), MagicConfig\detect_html(), MagicConfig\detect_jpeg(), MagicConfig\detect_lex(), MagicConfig\detect_lisp(), MagicConfig\detect_magic(), MagicConfig\detect_mime(), MagicConfig\detect_perl(), MagicConfig\detect_png(), MagicConfig\detect_postscript(), MagicConfig\detect_psfont(), MagicConfig\detect_rc(), MagicConfig\detect_rtf(), MagicConfig\detect_sgml(), MagicConfig\detect_swf(), MagicConfig\detect_tif(), MagicConfig\detect_xdiff(), MagicConfig\detect_xml(), ilTermsOfServiceFileSystemDocument\determine(), ilBlogExerciseGUI\downloadExcAssFile(), ilPortfolioExerciseGUI\downloadExcAssFile(), Twig_Profiler_Dumper_Blackfire\dump(), dump_hash(), sspmod_core_Stats_Output_File\emit(), ilECSSetting\fetchSerialID(), ilObjTermsOfServiceGUI\getAgreementTextByFilenameAsynch(), Slim\Http\UploadedFile\getStream(), GuzzleHttp\Psr7\UploadedFile\getStream(), ilFileXMLParser\handlerBeginTag(), ilFileXMLParser\handlerEndTag(), ilAuthFrontendCredentialsApache\hasValidTargetUrl(), ilObjLanguage\insert(), ilLanguage\insertLanguage(), Monolog\Handler\DeduplicationHandler\isDuplicate(), MYPDF\LoadData(), LangCheck\loadFile(), Slim\Http\UploadedFile\moveTo(), GuzzleHttp\Psr7\UploadedFile\moveTo(), sspmod_core_Stats_Output_File\openLog(), LibRIS\RISReader\parseFile(), XMLSchema\parseFile(), nusoap_xmlschema\parseFile(), phorum_htmlpurifier_show_config_info(), ILIAS\FileDelivery\FileDeliveryTypes\PHP\prepare(), printHelp(), ilLanguageFile\read(), ilDBUpdate\readCustomUpdatesInfo(), ilDBUpdate\readDBUpdateFile(), ilDBUpdate\readHotfixInfo(), ilDBUpdate\readLastUpdateFile(), ilObjSCORMLearningModule\readObject(), ilObjSCORM2004LearningModule\readObject(), ilValidator\readScanLog(), testDataFileIterator\rewind(), ilCalFileZipJob\run(), ilMediaAnalyzer\setFile(), ilMediaPlayerGUI\setFile(), ilFileXMLWriter\setFile(), ilFileXMLParser\setFileContents(), ilCalFileZipJob\setInput(), PHPExcel_Calculation\setLocale(), GuzzleHttp\Psr7\UploadedFile\setStreamOrFile(), showHelp(), ilFileXMLWriter\start(), Twig_Tests_Profiler_Dumper_BlackfireTest\testDump(), ilFileXMLParser\updateFileContents(), ilPlugin\updateLanguages(), Twig_Error\updateRepr(), testDataFileIterator\valid(), and sspmod_metarefresh_MetaLoader\writeMetadataFiles().

font

Set default font

Definition at line 55 of file 02types-xls.php.

Referenced by Slim\Handlers\NotAllowed\renderHtmlNotAllowedMessage(), Slim\Handlers\NotFound\renderHtmlNotFoundOutput(), and showHelp().

format

Write to Excel5 format

Definition at line 148 of file 02types-xls.php.

MB

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

Definition at line 160 of file 02types-xls.php.

object

Create new PHPExcel object

Definition at line 37 of file 02types-xls.php.

properties

Set document properties

Definition at line 45 of file 02types-xls.php.

seconds

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

Definition at line 158 of file 02types-xls.php.

to

File written to

Definition at line 153 of file 02types-xls.php.

usage

Peak memory usage

Definition at line 179 of file 02types-xls.php.

worksheet

Rename worksheet

Definition at line 139 of file 02types-xls.php.