31docproperties_write-xls.php File Reference

Go to the source code of this file.

Namespaces
	PHPExcel

Variables
const	EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'
	$inputFileType = 'Excel5'
	Include PHPExcel. More...
	$inputFileName = 'templates/31docproperties.xls'
Load Tests from $inputFileType	file
	$callStartTime = microtime(true)
	$objPHPExcelReader = PHPExcel_IOFactory::createReader($inputFileType)
	$objPHPExcel = $objPHPExcelReader->load($inputFileName)
	$callEndTime = microtime(true)
	$callTime = $callEndTime - $callStartTime
sprintf('%.4f', $callTime)	seconds
memory_get_usage(true)/1024/1024)	MB
Adjust	properties
Write to Excel5	format
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5')
File written	to
Peak memory	usage
	$objPHPExcelRead = PHPExcel_IOFactory::load(str_replace('.php', '.xls', __FILE__))
	date ( 'd-M-Y', $objPHPExcel->getProperties() ->getCreated())
	$customProperties = $objPHPExcel->getProperties()->getCustomProperties()
	foreach ( $customProperties as $customProperty)

Variable Documentation

$callEndTime

$callEndTime = microtime(true)

Definition at line 51 of file 31docproperties_write-xls.php.

$callStartTime

$callStartTime = microtime(true)

Definition at line 46 of file 31docproperties_write-xls.php.

$callTime

$callTime = $callEndTime - $callStartTime

Definition at line 52 of file 31docproperties_write-xls.php.

$customProperties

$customProperties = $objPHPExcel->getProperties()->getCustomProperties()

Definition at line 104 of file 31docproperties_write-xls.php.

$inputFileName

$inputFileName = 'templates/31docproperties.xls'

Definition at line 42 of file 31docproperties_write-xls.php.

$inputFileType

$inputFileType = 'Excel5'

Include PHPExcel.

Definition at line 41 of file 31docproperties_write-xls.php.

$objPHPExcel

$objPHPExcel = $objPHPExcelReader->load($inputFileName)

Definition at line 49 of file 31docproperties_write-xls.php.

$objPHPExcelRead

$objPHPExcelRead = PHPExcel_IOFactory::load(str_replace('.php', '.xls', __FILE__))

Definition at line 79 of file 31docproperties_write-xls.php.

$objPHPExcelReader

$objPHPExcelReader = PHPExcel_IOFactory::createReader($inputFileType)

Definition at line 48 of file 31docproperties_write-xls.php.

$objWriter

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

Definition at line 67 of file 31docproperties_write-xls.php.

date

date

Definition at line 86 of file 31docproperties_write-xls.php.

Referenced by ilChatroomHistoryGUI\__construct(), ilLPObjectStatisticsTypesTableGUI\__construct(), IMSGlobal\LTI\ToolProvider\MediaType\ToolProfile\__construct(), Gettext\Translations\__construct(), ilScorm2004Export\__construct(), ilMailSummaryNotification\__construct(), IMSGlobal\LTI\ToolProvider\Outcome\__construct(), ilLog\__construct(), ilForumPostsDeleted\__construct(), ilValidator\__construct(), ActiveRecord\__getConvertedDateFieldsAsArray(), ilObjUserGUI\__getDateSelect(), ilRegistrationSettingsGUI\__prepareDateSelect(), ilCourseContentGUI\__prepareDateSelect(), ilCourseContentGUI\__prepareTimeSelect(), ilCourseContentGUI\__renderItem(), PHPExcel_Worksheet_AutoFilter\_dynamicFilterDateRange(), ilBookmarkImportExport\_exportBookmark(), PHPExcel_Worksheet_AutoFilter\_filterTestInDateGroupSet(), PHPExcel_Worksheet_AutoFilter\_filterTestInPeriodDateSet(), ilExport\_generateIndexFile(), ilTimeZone\_getDefaultTimeZone(), ilObjUser\_getUserIdsByInactivationPeriod(), ilObjUser\_getUserIdsByInactivityPeriod(), ilChangeEvent\_recordObjStats(), ilChangeEvent\_recordReadEvent(), ilObjLanguageExt\_saveValues(), ilDiskQuotaChecker\_sendSummaryMails(), ilSessionAppointment\_timeToString(), ilObjUser\_updateLastLogin(), ilObjForum\_updateOldAccess(), ilForumPost\activateParentPosts(), ilForumPost\activatePost(), ilForumPost\activatePostAndChildPosts(), ilSessionStatisticsGUI\adaptDataToScale(), arEditGUI\addDateTimeInputField(), ilObjBookingPoolGUI\addDaysDate(), ilForumDraftsHistory\addDraftToHistory(), ilDclDatetimeFieldRepresentation\addFilterInputFieldToTable(), ilObjUser\addObjectToClipboard(), ilForum\addPostTree(), ilObjUser\addToPCClipboard(), sspmod_statistics_Aggregator\aggregate(), ilCalendarRecurrenceCalculator\applyBYWEEKNORules(), ilCalendarRecurrenceCalculator\applyBYYEARDAYRules(), ilLTIToolProvider\authenticate(), IMSGlobal\LTI\ToolProvider\ToolProvider\authenticate(), ilLanguageFile\build(), ilObjBookingPoolGUI\buildDatesBySchedule(), ilScorm2004Export\buildExportFileHTML(), ilScorm2004Export\buildExportFileHTMLOne(), ilScorm2004Export\buildExportFileISO(), ilScorm2004Export\buildExportFilePDF(), ilScorm2004Export\buildExportFileSCORM(), ilSurveyQuestionpoolExport\buildExportFileXML(), ilSurveyExport\buildExportFileXML(), ilQuestionpoolExport\buildExportFileXML(), ilContObjectExport\buildExportFileXML(), ilGlossaryExport\buildExportFileXML(), ilTestExport\buildExportFileXML(), ilTestExport\buildExportResultFile(), ilWikiStat\buildFullPeriodData(), ilChatroomKickGUI\buildMessage(), ilChatroomUploadFileGUI\buildMessage(), ActiveRecordList\buildRow(), ilObjExercise\checkDate(), ilSCORM2004StoreData\checkIfAllowed(), ilObjSCORMTracking\checkIfAllowed(), ilDclTable\checkLimit(), ilUserCronCheckAccounts\checkNotConfirmedUserAccounts(), ilObjSurvey\checkReminder(), ilCronJob\checkSchedule(), sspmod_statistics_LogCleaner\clean(), ilChatroomServerHandler\cleanupPrivateRooms(), ilSkillTreeNode\clipboardCopy(), ilSCORM2004Node\clipboardCopy(), ilLMObject\clipboardCopy(), Parser\closeList(), ilMailCronOrphanedMailsDeletionCollector\collect(), ilMailCronOrphanedMailsNotificationCollector\collect(), ilObjBookingPoolGUI\confirmedBookingNumbersObject(), ilPageObject\copyContents(), ilObjGlossaryGUI\copyTerms(), ilRegistrationSettingsGUI\createCodes(), ilTestArchiver\createPassMaterialsDirectory(), ilObjBlogGUI\createPosting(), ilObjTest\createRandomSolutions(), ilConsultationHoursGUI\createSequence(), cron_hook_cron(), PHPExcel_Calculation_DateTime\DATEVALUE(), ilMemberExportGUI\deliverData(), ilChatroomServerHandler\disconnectedUsers(), ilMemberExportGUI\downloadExportFile(), ilObjLanguageExtGUI\downloadObject(), ilCourseContentGUI\editTimings(), _database\error(), ilWikiStatGUI\export(), ilDclContentExporter\export(), ilAccountCodesGUI\exportCodes(), ilRegistrationSettingsGUI\exportCodes(), ilSessionStatisticsGUI\exportCSV(), ilSurveyEvaluationGUI\exportCumulatedResults(), ilSurveyEvaluationGUI\exportEvaluationUser(), ilObjQuestionPool\exportFileItems(), ilSCORM2004Asset\exportFileItems(), ilObjGlossary\exportFileItems(), ilObjSCORM2004LearningModule\exportFileItems(), ilObjContentObject\exportFileItems(), ilObjTest\exportFileItems(), ilECSSettingsGUI\exportImported(), ilObjTest\exportPagesXML(), ilECSSettingsGUI\exportReleased(), ilObjSCORM2004LearningModule\exportScorm(), ilStructureObject\exportXML(), ilObjGlossary\exportXML(), ilObjContentObject\exportXML(), ilObjGlossary\exportXMLGlossaryItems(), ilObjQuestionPool\exportXMLMediaObjects(), ilSCORM2004Asset\exportXMLMediaObjects(), ilObjGlossary\exportXMLMediaObjects(), ilObjContentObject\exportXMLMediaObjects(), ilObjTest\exportXMLMediaObjects(), ilObjQuestionPool\exportXMLPageObjects(), ilSCORM2004Asset\exportXMLPageObjects(), ilObjContentObject\exportXMLPageObjects(), ilObjTest\exportXMLPageObjects(), ilBPMN2ParserUtils\extractTimeDateEventDefinitionFromElement(), Parser\fetchScaryTemplateMaybeFromCache(), ilLPObjectStatisticsTypesTableGUI\fillRow(), ilObjGroup\findGroupsWithNotEnoughMembers(), ilDclDatetimeRecordRepresentation\formatDate(), ilLPCronObjectStatistics\gatherCourseLPData(), ilLPCronObjectStatistics\gatherTypesData(), ilLPCronObjectStatistics\gatherUserData(), ilForum\generatePost(), ilForum\generateThread(), ilForum\getAllThreads(), ilOrgUnitType\getAllTypes(), ilObjCourse\getArchiveEnd(), ilCalendarSchedule\getChangedEvents(), ilSessionStatisticsGUI\getChart(), ilWikiStatGUI\getChartData(), ilSessionStatistics\getCurrentSlot(), ilCourseParticipants\getDateTimeOfPassed(), ilFileDataForumDrafts\getDraftsPath(), ilSessionAppointment\getEnd(), ilSessionAppointment\getEndingTime(), ilCalendarBlockGUI\getEvents(), ilScorm2004Export\getExportSubDirectory(), ilFeedWriter\getFeed(), TCPDF_STATIC\getFormattedDate(), ilFileDataForum\getForumPath(), ilCalendarUtil\getHourSelection(), ilCalendarHeaderNavigationGUI\getHTML(), ilDclDatetimeFieldRepresentation\getInputField(), ilLPObjectStatisticsTypesTableGUI\getItems(), ilBookingReservation\getListByDate(), ilWikiStatGUI\getListData(), ilObjAssessmentFolderGUI\getLogDataOutputForm(), ilSCORM13Player\getLogFileList(), ilLPTableBaseGUI\getMonthsFilter(), ilLPTableBaseGUI\getMonthsYear(), ilNotification\getNotificationsForObject(), ilTrQuery\getObjectTypeStatisticsPerMonth(), ilTestArchiver\getPassDataDirectory(), ilPageObject\getRecentChanges(), ilSessionAppointment\getStart(), ilSessionAppointment\getStartingTime(), ilBirthdayInputGUI\getStartYear(), ilObjCourse\getSubItems(), ilWorkflowScaffold\getTimeDateEventDefinition(), Monolog\Handler\RotatingFileHandler\getTimedFilename(), ilWikiStat\getTimestamp(), ilDclDatetimeRecordFieldModel\getValueFromExcel(), ilTestArchiver\handInBestSolutionQuestionMaterial(), ilTestArchiver\handInParticipantMisc(), ilTestArchiver\handInParticipantQuestionMaterial(), ilTestArchiver\handInParticipantSubmission(), ilTestArchiver\handInTestBestSolution(), ilTestArchiver\handInTestResult(), ilTestArchiver\handInTestResultsOverview(), ilForumXMLParser\handlerEndTag(), ilNewsItem\handleTimePeriod(), ilUserImportParser\importEndTag(), ilSCORMPresentationGUI\increase_attemptAndsave_module_version(), ilSCORM13Player\increase_attemptAndsave_module_version(), ilLPObjectStatisticsDailyTableGUI\initFilter(), ilLPObjectStatisticsTableGUI\initFilter(), ilLPObjectStatisticsTypesTableGUI\initFilter(), ilLPObjectStatisticsLPTableGUI\initFilter(), ilBookingReservationsTableGUI\initFilter(), ilObjCalendarSettingsGUI\initFormSettings(), ilPersonalSettingsGUI\initGeneralSettingsForm(), ilCalendarPresentationGUI\initSeed(), ilCalendarUserSettingsGUI\initSettingsForm(), ilObjLanguage\insert(), ilLanguage\insertLanguage(), ilForum\insertPostNode(), ilSurveyParticipantsGUI\isAnonymousListActive(), ilBookingReservation\isObjectAvailableInPeriod(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_mysql\loadConsumerNonce(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_pdo\loadConsumerNonce(), ilLTIDataConnector\loadConsumerNonce(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_mysql\loadResourceLinkShareKey(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_pdo\loadResourceLinkShareKey(), ilLTIDataConnector\loadResourceLinkShareKey(), PHPExcel_Shared_OLE\LocalDate2OLE(), ilSCORM13Player\logFileName(), ilObjForum\lookupStatisticsByRefId(), ilObjUserFolderGUI\mailObject(), ilUtil\makeDateSelect(), ilUtil\makeTimeSelect(), ilMailCronOrphanedMailsNotifier\markAsNotified(), ilObjGroup\mayLeave(), ilObjCourse\mayLeave(), MDB2_Date\mdbNow(), MDB2_Date\mdbTime(), MDB2_Date\mdbToday(), ilAwarenessAct\notifyOnNewOnlineContacts(), ilUtil\now(), ilObjQuestionPool\objectToXmlWriter(), Securimage\outputAudioFile(), soap_server\parse_request(), ilCalendarWeekGUI\parseHourInfo(), ilCalendarDayGUI\parseInfoIntoRaster(), PHPExcel_Shared_Date\PHPToExcel(), ilForum\postCensorship(), ilSCORM13Player\postLogEntry(), sspmod_statistics_DateHandler\prettyDateEpoch(), ilObjTestGUI\printobject(), ilObjPortfolioGUI\printView(), sspmod_expirycheck_Auth_Process_ExpiryDate\process(), ilObjForumGUI\publishDraftObject(), ilValidator\purgeObjects(), sspmod_oauth_Registry\readonlyDateField(), ilStudyProgrammeUserProgress\recalculateFailedToDeadline(), ilObjGlossaryGUI\referenceTerms(), ilObjBookingPoolGUI\renderSlots(), PHPMailer\rfcDate(), Monolog\Handler\RotatingFileHandlerTest\rotationTests(), ilMembershipCronNotifications\run(), ilLPCronObjectStatistics\run(), ilLoggerCronCleanErrorFiles\run(), ilSkillNotifications\run(), ilForumCronNotification\run(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_mysql\saveConsumerNonce(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_pdo\saveConsumerNonce(), ilLTIDataConnector\saveConsumerNonce(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_mysql\saveContext(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_pdo\saveContext(), ilLTIDataConnector\saveContext(), ilForumPostDraft\saveDraft(), ilMailingListsGUI\saveForm(), ilObjLanguageExtGUI\saveNewEntryObject(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_mysql\saveResourceLink(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_pdo\saveResourceLink(), ilLTIDataConnector\saveResourceLink(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_mysql\saveResourceLinkShareKey(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_pdo\saveResourceLinkShareKey(), ilLTIDataConnector\saveResourceLinkShareKey(), ilObjTest\saveToDb(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_mysql\saveToolConsumer(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_pdo\saveToolConsumer(), ilLTIDataConnector\saveToolConsumer(), ilLTIDataConnector\saveToolConsumerILIAS(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_mysql\saveUser(), IMSGlobal\LTI\ToolProvider\DataConnector\DataConnector_pdo\saveUser(), ilLTIDataConnector\saveUser(), ilObjSCORMTracking\scorm12PlayerUnload(), ilSCORM2004StoreData\scormPlayerUnload(), ilSCORMOfflineMode\scormPlayerUnloadForSop2il(), ilMail\sendInternalMail(), ILIAS\FileDelivery\Delivery\sendLastModified(), ilObjUser\setActive(), ilSCORM2004StoreData\setCMIData(), ilMDAnnotation\setDate(), ilDateTimeInputGUI\setDate(), ilMDContribute\setDate(), ilExternalFeedItem\setDate(), ilFeedItem\setDate(), phpCAS\setDebug(), ilObjSCORMInitData\setHash(), ilGlossaryPresentationGUI\showDownloadList(), ilAdvancedMDRecordGUI\showECSStart(), ilObjSCORMTracking\syncGlobalStatus(), tdate(), ButtonMonthTest\test_render(), Monolog\Formatter\NormalizerFormatterTest\testBatchFormat(), Monolog\Formatter\LineFormatterTest\testBatchFormat(), Monolog\Formatter\LineFormatterTest\testContextAndExtraOptionallyNotShownIfEmpty(), Monolog\Formatter\LineFormatterTest\testDefFormatExtras(), Monolog\Formatter\LineFormatterTest\testDefFormatWithArrayContext(), Monolog\Formatter\LineFormatterTest\testDefFormatWithException(), Monolog\Formatter\LineFormatterTest\testDefFormatWithObject(), Monolog\Formatter\LineFormatterTest\testDefFormatWithPreviousException(), Monolog\Formatter\LineFormatterTest\testDefFormatWithString(), Monolog\Formatter\NormalizerFormatterTest\testFormat(), Monolog\Formatter\LineFormatterTest\testFormatExtras(), Symfony\Component\Yaml\Tests\ParserTest\testParseDateAsMappingValue(), Monolog\Handler\RotatingFileHandlerTest\testReuseCurrentFile(), Monolog\Handler\RotatingFileHandlerTest\testRotation(), Monolog\Handler\RotatingFileHandlerTest\testRotationCreatesNewFile(), timestamp_to_iso8601(), Gettext\Generators\Po\toString(), MDB2_Date\unix2Mdbstamp(), ilForumTopic\update(), ilObjForum\update(), ilForumPostDraft\updateDraft(), ilMail\updateDraft(), ilNotification\updateNotificationTime(), ilObjStudyProgrammeIndividualPlanGUI\updateStatus(), ilWikiStatGUI\view(), PHPExcel_Writer_OpenDocument_Meta\write(), PHPExcel_Writer_Excel2007_DocProps\writeDocPropsCore(), PHPExcel_Writer_Excel2007_DocProps\writeDocPropsCustom(), ilDAVServer\writelog(), ilLoggingActivity\writeLogMessage(), and ilLPStatus\writeStatus().

EOL

Peak memory memory_get_peak_usage (true)/1024/1024) . " MB" EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'

Definition at line 33 of file 31docproperties_write-xls.php.

file

Reread Excel5 file

Definition at line 45 of file 31docproperties_write-xls.php.

foreach

foreach($customProperties as $customProperty)

Definition at line 105 of file 31docproperties_write-xls.php.

format

Write to Excel5 format

Definition at line 66 of file 31docproperties_write-xls.php.

MB

memory_get_usage (true)/1024/1024) MB

Definition at line 55 of file 31docproperties_write-xls.php.

properties

Get properties

Definition at line 58 of file 31docproperties_write-xls.php.

seconds

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

Definition at line 53 of file 31docproperties_write-xls.php.

to

File written to

Definition at line 69 of file 31docproperties_write-xls.php.

usage

Peak memory usage

Definition at line 73 of file 31docproperties_write-xls.php.