ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
33chartcreate-area.php File Reference

Go to the source code of this file.

Namespaces

 PHPExcel
 

Variables

const EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'
 
 $objPHPExcel = new PHPExcel()
 PHPExcel. More...
 
 $objWorksheet = $objPHPExcel->getActiveSheet()
 
 $dataSeriesLabels
 
 $xAxisTickValues
 
 $dataSeriesValues
 
 $series
 
 $plotArea = new PHPExcel_Chart_PlotArea(NULL, array($series))
 
 $legend = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_TOPRIGHT, NULL, false)
 
 $title = new PHPExcel_Chart_Title('Test %age-Stacked Area Chart')
 
 $yAxisLabel = new PHPExcel_Chart_Title('Value ($k)')
 
 $chart
 
Write to Excel2007 format
 
 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')
 
File written to
 
Peak memory usage
 
Peak memory memory_get_peak_usage(true)/1024/1024) MB
 
Done writing file
 

Variable Documentation

◆ $chart

◆ $dataSeriesLabels

$dataSeriesLabels
Initial value:
new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),
new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),
new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),
)
Create styles array
The data for the language used.

Definition at line 62 of file 33chartcreate-area.php.

◆ $dataSeriesValues

$dataSeriesValues
Initial value:
new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
)
Create styles array
The data for the language used.

Definition at line 84 of file 33chartcreate-area.php.

◆ $legend

◆ $objPHPExcel

$objPHPExcel = new PHPExcel()

PHPExcel.

Definition at line 43 of file 33chartcreate-area.php.

◆ $objWorksheet

$objWorksheet = $objPHPExcel->getActiveSheet()

Definition at line 44 of file 33chartcreate-area.php.

◆ $objWriter

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

Definition at line 131 of file 33chartcreate-area.php.

◆ $plotArea

◆ $series

◆ $title

$title = new PHPExcel_Chart_Title('Test %age-Stacked Area Chart')
Examples:
/usr/local/src/ilias/release_5-2/libs/composer/vendor/filp/whoops/src/Whoops/Handler/PrettyPageHandler.php.

Definition at line 105 of file 33chartcreate-area.php.

Referenced by ilObjectXMLWriter\__appendObject(), ilObjectFeedWriter\__construct(), ilUserFeedWriter\__construct(), ilSurveyCategory\__construct(), ilCalendarBlockGUI\__construct(), PHPExcel_Chart\__construct(), ilLocalUserGUI\__showRolesTable(), ilBookmarkImportExport\_exportBookmark(), PHPExcel_Chart_Renderer_jpgraph\_renderCartesianPlotArea(), PHPExcel_Chart_Renderer_jpgraph\_renderTitle(), PHPExcel_Writer_Excel2007_Chart\_writeTitle(), assClozeTestGUI\addBasicQuestionFormProperties(), assQuestionGUI\addBasicQuestionFormProperties(), ilObjTestSettingsGeneralGUI\addGeneralProperties(), ilContainerRenderer\addHeaderRow(), ilContainerGUI\addHeaderRow(), ilPDSelectedItemsBlockGUI\addHeaderRow(), ilObjContentObjectGUI\addLocations(), ilObjPortfolioBaseGUI\addLocatorItems(), ilObjMediaPoolGUI\addLocatorItems(), ilObjQuestionPoolGUI\addLocatorItems(), ilObjSessionGUI\addLocatorItems(), ilPDSelectedItemsBlockGUI\addParentRow(), ilChatroom\addPrivateRoom(), ilTestExpressPageObjectGUI\addQuestion(), ilObjTestGUI\addQuestionObject(), ilCalendarCategoryGUI\addReferenceLinks(), ilSystemStyleIconsGUI\addSelectIconToolbar(), ilPDSelectedItemsBlockGUI\addStandardRow(), Monolog\Formatter\HtmlFormatter\addTitle(), ilChatroomFormFactory\applyValues(), ilConditionHandlerGUI\askDelete(), ilContainerStartObjectsGUI\askDeleteStarterObject(), ilObjCategoryGUI\assignRolesObject(), ilObjQuestionPoolSettingsGeneralGUI\buildForm(), ilContainerObjectiveGUI\buildObjectiveMap(), ilLOUtils\buildQplTitleByDefinition(), ilContainerReferenceXmlWriter\buildTitle(), ilECSNodeMappingCmsExplorer\buildTitle(), ilECSNodeMappingLocalExplorer\buildTitle(), ilvCard\buildVCard(), ilCalendarAppointmentGUI\cancelBooking(), ILIAS\UI\Implementation\Factory\card(), ilDclFieldEditGUI\checkInput(), ilDclTableEditGUI\checkInput(), ilObjForumGUI\cloneWizardPageObject(), Parser\closeList(), ilSurveyConstraintsGUI\confirmDeleteConstraintsObject(), ilExSubmissionFileGUI\confirmDeleteDeliveredObject(), ilBasicSkillGUI\confirmLevelResourcesRemoval(), ilObjPortfolioBaseGUI\confirmPortfolioPageDeletion(), ilObjMediaPoolGUI\confirmRemove(), ilRepUtilGUI\confirmRemoveFromSystemObject(), ilPDSelectedItemsBlockGUI\confirmRemoveObject(), SurveyQuestionGUI\confirmSavePhrase(), ilSurveyConstraintsGUI\constraintForm(), ilContainerGUI\copyFile(), ilRbacAdmin\copyLocalRoles(), ilObjTestGUI\copyQuestionObject(), ilChatroomPrivateRoomGUI\create(), ilLMObjectGUI\create(), ilECSCourseCreationHandler\createCourseData(), Monolog\Handler\PushoverHandlerTest\createHandler(), ilContainerXmlParser\createObject(), ilECSCourseCreationHandler\createParallelCourse(), ilECSCourseCreationHandler\createParallelGroup(), ilObjPortfolioGUI\createPortfolioFromTemplate(), ilObjPortfolioGUI\createPortfolioFromTemplateProcess(), ilObjBlogGUI\createPosting(), ilObjTestGUI\createQuestionPoolAndCopyObject(), ilSessionStatisticsGUI\current(), ilObjStudyProgrammeTreeGUI\delete(), ilBookmarkAdministrationGUI\delete(), ilSurveyParticipantsGUI\deleteCodesConfirmObject(), ilObject2GUI\deleteConfirmation(), ilSurveySkill\determineSkillLevelsForAppraisee(), ilECSMappingSettingsGUI\dInitFormTreeSettings(), ilGlossaryLocatorGUI\display(), ilContObjLocatorGUI\display(), ilBookmarkAdministrationGUI\displayLocator(), ilBlogExerciseGUI\downloadExcSubFile(), ilPortfolioExerciseGUI\downloadExcSubFile(), Monolog\Handler\BrowserConsoleHandler\dump(), Title\equals(), ilWikiHandlerGUI\executeCommand(), ilImprintGUI\executeCommand(), ilDclDetailedViewDefinitionGUI\executeCommand(), ilDclContentExporter\export(), ilObjAssessmentFolderGUI\exportLogObject(), ilECSSettingsGUI\exportMappings(), ilTestExport\exportToExcel(), Parser\fetchScaryTemplateMaybeFromCache(), ilWikiImportantPagesBlockGUI\fillDataSection(), ilRegistrationGUI\fillMembershipLimitation(), ilOrgUnitTypeFormGUI\fillObject(), ilStudyProgrammeTypeFormGUI\fillObject(), ilWorkspaceFolderExplorer\formatHeader(), ilECSNodeMappingCmsExplorer\formatHeader(), ilECSNodeMappingLocalExplorer\formatHeader(), ilWorkspaceExplorer\formatHeader(), ilPasteIntoMultipleItemsExplorer\formatHeader(), ilRepositoryExplorer\formatHeader(), GetId3\Module\Tag\Id3v1\GenerateID3v1Tag(), ilOrgUnitType\getAllTypes(), ilStudyProgrammeType\getAllTypesArray(), ilPermanentLinkGUI\getBookmarksSelectionList(), ilTestRandomQuestionSetConfig\getCommaSeparatedSourceQuestionPoolLinks(), ilParticipants\getDefaultMemberRole(), ilPublicUserProfileGUI\getEmbeddable(), ilObjMediaCastGUI\getFeedIconsHTML(), ilDclIliasReferenceRecordRepresentation\getHTML(), ilObjWikiSubItemListGUI\getHTML(), ilFileUploadGUI\getHTML(), ilCalendarAppointmentPanelGUI\getHTML(), ilPathGUI\getHTML(), ilPermanentLinkGUI\getHTML(), ilSoapStructureObjectFactory\getInstance(), ilPDSelectedItemsBlockGUI\getIntroduction(), ilNavigationHistory\getItems(), ilDclIliasReferenceRecordRepresentation\getLinkHTML(), ilWikiStatGUI\getListData(), ilPDNotesBlockGUI\getListRowData(), ilObjGroupGUI\getLocalRoles(), ilObjCourseGUI\getLocalRoles(), ilImageMapEditorGUI\getMapAreaLinkString(), ilGroupParticipants\getMemberRoles(), ilCourseParticipants\getMemberRoles(), ilPDSelectedItemsBlockGUI\getMembershipItemsPerType(), ilParticipant\getMembershipRoleType(), ilCronManagerGUI\getMultiActionData(), ilUserUtil\getNamePresentation(), ilSkillTreeExplorerGUI\getNodeContent(), ilAdministrationExplorerGUI\getNodeContent(), ilSkillTemplateTreeExplorerGUI\getNodeContent(), ilRepositoryExplorerGUI\getNodeContent(), ilRepositorySelectorExplorerGUI\getNodeContent(), ilVirtualSkillTreeExplorerGUI\getNodeContent(), ilPersonalSkillExplorerGUI\getNodeContent(), ilAdministrationExplorerGUI\getNodeIconAlt(), ilRepositoryExplorerGUI\getNodeIconAlt(), ilRepositorySelectorExplorerGUI\getNodeIconAlt(), ilVirtualSkillTree\getNodeTitle(), ilNoteGUI\getNoteListHTML(), ilPDSelectedItemsBlockGUI\getObjectsByMembership(), ilExSubmissionFileGUI\getOverviewContent(), ilPCInteractiveImage\getPopups(), SurveyQuestionGUI\getPrintViewQuestionTitle(), ilObjContentObjectGUI\getPropertiesFormValues(), ilObjTestGUI\getQuestionpoolCreationForm(), ilCourseObjectivesGUI\getRandomTestQplOptions(), ilPDSelectedItemsBlockGUI\getSelectedItemsPerType(), ilObjTestSettingsGeneralGUI\getSettingsTemplateMessageHTML(), ilObjTestDynamicQuestionSetConfig\getSourceQuestionPoolLink(), ilObjGlossaryGUI\getTemplate(), ilMailTemplateGUI\getTemplateForm(), ilWikiPage\getTitle(), ilSCORM2004Node\getTitle(), ilMDCreator\getTitle(), ilLMMenuEditor\getTitle(), ilObjSessionListGUI\getTitle(), ilManifestParser\getTitle(), ilObjCourseGrouping\getTitle(), ilLinkResourceItems\getTitle(), ilMediaPoolItem\getTitle(), ilGlossaryDefinition\getTitle(), ilExternalFeedItem\getTitle(), ilHierarchyFormGUI\getTitle(), ilPermanentLinkGUI\getTitle(), ilPropertyFormGUI\getTitle(), ilMDGeneral\getTitle(), ilBlockGUI\getTitle(), ilFileSystemGUI\getTitle(), ilCourseObjective\getTitle(), ilExplorer\getTitle(), ilObjectListGUI\getTitle(), ilStudyProgrammeIndividualPlanProgressListGUI\getTitleForItem(), ilChatroom\getUniquePrivateRoomTitle(), ilTestLearningObjectivesStatusGUI\getUsersObjectivesStatus(), ilDclTextRecordFieldModel\getValueFromExcel(), ilSoapGroupAdministration\groupExists(), ilSoapFunctions\groupExists(), ilMembershipRegistrationCodeUtils\handleCode(), ilLMPresentationGUI\handleCodeParagraph(), ilObjFileGUI\handleFileUpload(), SurveyImportParserPre38\handlerEndTag(), SurveyImportParser\handlerEndTag(), ilQTIParser\handlerVerifyBeginTag(), ilSCORM13Package\il_import(), ilLMPresentationGUI\ilLMSubMenu(), ilECSSettingsGUI\importMappings(), ilSCORM2004SeqTemplate\importTemplate(), ilCalendarInboxGUI\inbox(), Title\indexTitle(), ilPCMediaObjectGUI\initAliasForm(), ilBadgeManagementGUI\initBadgeForm(), ilObjPortfolioTemplateGUI\initCopyPageFormOptions(), ilObjPortfolioGUI\initCreatePortfolioFromTemplateForm(), ilObjSurveyQuestionPoolGUI\initEditForm(), SurveyQuestionGUI\initEditForm(), ilObjCategoryGUI\initEditForm(), ilObjCourseGUI\initEditForm(), ilDidacticTemplateSettingsGUI\initEditTemplate(), ilOrgUnitTypeFormGUI\initForm(), ilStudyProgrammeTypeFormGUI\initForm(), ilBookingScheduleGUI\initForm(), ilCalendarAppointmentGUI\initForm(), ilExcCriteriaCatalogueGUI\initForm(), ilExcCriteriaGUI\initForm(), ilObjCourseGroupingGUI\initForm(), ilBookingObjectGUI\initForm(), ilObjMediaObjectGUI\initForm(), ilContainerReferenceGUI\initForm(), ilAdvancedMDSettingsGUI\initForm(), ilObjGroupGUI\initForm(), ilObjSessionGUI\initForm(), ilCalendarCategoryGUI\initFormCategory(), ilCalendarAppointmentGUI\initFormConfirmBooking(), ilObjectActivationGUI\initFormEdit(), ilObjLinkResourceGUI\initFormLink(), ilObjRoleGUI\initFormRoleProperties(), ilObjRoleTemplateGUI\initFormRoleTemplate(), ilAdvancedMDSettingsGUI\initFormSubstitutions(), ilCourseObjectivesGUI\initFormTitle(), ilConsultationHoursGUI\initGroupForm(), ilObjBadgeAdministrationGUI\initImageTemplateForm(), ilContainerXmlParser\initItem(), ilObjectCustomUserFieldsGUI\initMemberForm(), ilObjContentObjectGUI\initMenuEntryForm(), ilObjUserFolderGUI\initNewAccountMailForm(), ilObjRepositorySettingsGUI\initNewItemGroupForm(), ilExSubmissionObjectGUI\initPortfolioTemplateForm(), ilPCBlogGUI\initPostingForm(), ilObjFileGUI\initPropertiesForm(), ilObjSurveyGUI\initPropertiesForm(), ilSurveyEditorGUI\initQuestionblockForm(), ilPermissionGUI\initRoleForm(), ilMailSearchGUI\initSearchForm(), ilObjGlossaryGUI\initSettingsForm(), ilBlogPostingGUI\initTitleForm(), ilUnitConfigurationGUI\initUnitCategoryForm(), ilCourseObjectivesGUI\initWizard(), ilContactGUI\inviteToChat(), ilRbacReview\isSystemGeneratedRole(), ilGlossaryPresentationGUI\listDefinitions(), ilSkillSelfEvaluationGUI\listSelfEvaluations(), ilObjOrgUnitTree\loadArrayOfStaff(), ilObjOrgUnitTree\loadStaff(), ilObjOrgUnitTree\loadStaffRecursive(), ilObjAssessmentFolderGUI\logAdminObject(), ilSessionStatisticsGUI\long(), ilSearchResultPresentation\lookupDescription(), ilParticipants\lookupNumberOfMembers(), ilLOUtils\lookupQplBySequence(), ilSearchResultPresentation\lookupTitle(), make_header(), Title\makeName(), Title\makeTitle(), Title\makeTitleSafe(), SurveyQuestionGUI\material(), Title\newFromID(), ilDclFieldFactory\parseDatatypeTitle(), ilMembershipCronNotifications\parseNewsItem(), ilPortfolioPageGUI\parseObjectives(), ilObjectAddNewItemGUI\parseRepository(), ilDclMobRecordFieldModel\parseValue(), ilSurveyPageGUI\paste(), ilContainerGUI\performPasteIntoMultipleObjectsObject(), ilSessionStatisticsGUI\periodic(), ilObjRoleTemplateGUI\permObject(), ilSurveyPhrasesGUI\phraseEditor(), ilECSSettingsGUI\prepareFieldSelection(), ilGlossaryPresentationGUI\prepareOutput(), ilObjSessionGUI\prepareOutput(), ilSystemStyleIconsGUI\preview(), CAS_Client\printHTMLHeader(), PHPExcel_Reader_Excel2007_Chart\readChart(), ilAdvancedMDRecordExportFiles\readFilesInfo(), ilParticipant\readParticipant(), ilParticipants\readParticipants(), ilContainerGUI\recurseFolder(), ilNotificationSetupHelper\registerChannel(), ilNotificationDatabaseHandler\registerChannel(), ilNotificationSetupHelper\registerType(), ilNotificationDatabaseHandler\registerType(), ilTaggingClassificationProvider\render(), ilObjBlogGUI\render(), ilSurveyEvaluationGUI\renderDetails(), ilKSDocumentationEntryGUI\renderEntry(), ilChatroomViewGUI\renderFileUploadForm(), ilExPeerReviewGUI\renderInfoWidget(), ilTestQuestionSideListGUI\renderList(), ilObjBlogGUI\renderList(), ilMainMenuGUI\renderMainMenuListEntries(), ilPortfolioPageGUI\renderMyCoursesTeaser(), ilPersonalSkillsGUI\renderObjectEvalRow(), ilContainerObjectiveGUI\renderObjective(), ilExSubmissionObjectGUI\renderResourceSelection(), ilPersonalSkillsGUI\renderSkillHTML(), ilObjBookingPoolGUI\renderSlots(), ilPersonalSkillsGUI\renderSuggestedResources(), ilContainerObjectiveGUI\renderTest(), ilUtil\replaceLinkProperties(), ILIAS\UI\Implementation\Component\Panel\Factory\report(), ilObjUserGUI\roleassignmentObject(), ilObjFileGUI\save(), ilDclFieldEditGUI\save(), ilObjSkillManagementGUI\saveAllTemplateTitles(), ilObjSkillManagementGUI\saveAllTitles(), ilObjSCORM2004LearningModuleGUI\saveAllTitles(), ilObjMediaCastGUI\saveCastItemObject(), ilSurveyEditorGUI\saveDefineQuestionblockObject(), ilLOEditorGUI\saveObjectiveCreation(), ilObjMediaObjectGUI\savePropertiesObject(), ilPortfolioRepositoryGUI\saveTitles(), ilTestMailNotification\sendAdvancedNotification(), ilSurveyParticipantsGUI\sendCodesMailObject(), ilChatroomServerConnector\sendCreatePrivateRoom(), ilMembershipCronMinMembers\sendMessage(), ilNote\sendNotifications(), ilTestMailNotification\sendSimpleNotification(), ilMediaAliasItem\setAreaExtLink(), ilMediaAliasItem\setAreaIntLink(), ilObjMediaObjectGUI\setObjectPerCreationForm(), Parser\setOutputType(), Whoops\Handler\PrettyPageHandler\setPageTitle(), SurveyQuestionGUI\setQuestionTabsForClass(), ilExSubmissionObjectGUI\setSelectedPortfolioTemplateObject(), ilSkillSelfEvaluationGUI\setSelfEvaluationPresentationForm(), PHPExcel_Chart\setTitle(), SeqActivity\setTitle(), ilvCard\setTitle(), ilObjWorkspaceRootFolderGUI\setTitleAndDescription(), ilObjPortfolioGUI\setTitleAndDescription(), ilObjQuestionPoolGUI\setTitleAndDescription(), ilSessionStatisticsGUI\short(), ilCalendarDayGUI\showAppointment(), ilCalendarWeekGUI\showAppointment(), ilColumnGUI\showBlocks(), ilContainerGUI\showCustomIconsEditing(), ilRepUtilGUI\showDeleteConfirmation(), ilCalendarMonthGUI\showEvents(), ilNewsForContextBlockGUI\showFeedUrl(), ilNoteGUI\showTargets(), ilRepositoryGUI\showTree(), ilUnitConfigurationGUI\showUnitCreationForm(), ilOrgUnitSimpleImport\simpleImportElement(), ILIAS\UI\Implementation\Component\Panel\Factory\standard(), ILIAS\UI\Implementation\Component\Panel\Factory\sub(), assQuestionGUI\suggestedsolution(), ilPlainTextHandler\tablesContent(), ilLoggingErrorFileStorage\tablesContent(), Title\trackbackRDF(), ilLMTracker\trackLastPageAccess(), ilObjFileGUI\update(), ilObjMediaCastGUI\updateCastItemObject(), ilECSCourseCreationHandler\updateCourseData(), ilObjMediaCastGUI\updateMediaItem(), ilConsultationHoursGUI\updateMulti(), ilObjCategoryGUI\updateObject(), ilMediaPoolItem\updateObjectTitle(), ilECSCourseCreationHandler\updateParallelCourses(), ilECSCourseCreationHandler\updateParallelGroups(), ilMembershipGUI\updateParticipants(), ilBadgeAssignment\updatePositions(), ilObjSAHSLearningModuleGUI\uploadObject(), and ilPDNewsGUI\view().

◆ $xAxisTickValues

$xAxisTickValues
Initial value:
new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),
)
Create styles array
The data for the language used.

Definition at line 74 of file 33chartcreate-area.php.

◆ $yAxisLabel

◆ EOL

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

Definition at line 9 of file 33chartcreate-area.php.

◆ file

Done writing file

Definition at line 141 of file 33chartcreate-area.php.

◆ format

Write to Excel2007 format

Definition at line 130 of file 33chartcreate-area.php.

◆ MB

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

Definition at line 138 of file 33chartcreate-area.php.

◆ to

File written to

Definition at line 134 of file 33chartcreate-area.php.

◆ usage

Peak memory usage

Definition at line 138 of file 33chartcreate-area.php.