33chartcreate-stock.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_RIGHT, NULL, false)
	$title = new PHPExcel_Chart_Title('Test Stock Chart')
	$xAxisLabel = new PHPExcel_Chart_Title('Counts')
	$yAxisLabel = new PHPExcel_Chart_Title('Values')
	$chart
Write to Excel2007	format
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')
	$filename = str_replace('.php', '.xlsx', __FILE__)
File written	to
Peak memory	usage
Peak memory memory_get_peak_usage(true)/1024/1024)	MB
Done writing	file

Variable Documentation

$chart

$chart

Initial value:

= new PHPExcel_Chart(
        'stock-chart',  
        $title,                 
        $legend,                
        $plotArea,              
        true,                   
        0,                              
        $xAxisLabel,    
        $yAxisLabel             
)

Definition at line 115 of file 33chartcreate-stock.php.

$dataSeriesLabels

$dataSeriesLabels

Initial value:

= array(
        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), 
        new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$E$1', NULL, 1), 
)

Definition at line 65 of file 33chartcreate-stock.php.

$dataSeriesValues

$dataSeriesValues

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$B$2:$B$6', NULL, 5),
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$C$2:$C$6', NULL, 5),
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$D$2:$D$6', NULL, 5),
        new PHPExcel_Chart_DataSeriesValues('Number', 'Worksheet!$E$2:$E$6', NULL, 5),
)

Definition at line 88 of file 33chartcreate-stock.php.

$filename

$filename = str_replace('.php', '.xlsx', __FILE__)

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

Referenced by ilQuestionPoolExportTableGUI\__construct(), ilTestExportTableGUI\__construct(), ilFileVersionTableGUI\__construct(), PHPExcel_Writer_Excel5\_buildWorkbookEscher(), Image_XMP\_get_jpeg_header_data(), Image_XMP\_get_XMP_text(), PHPExcel_Reader_Gnumeric\_gzfileGetContents(), PHPExcel_Calculation\_loadLocales(), TCPDF\_putannotsobjs(), TCPDF\_putbookmarks(), TCPDF\_putEmbeddedFiles(), PHPExcel_Reader_Excel5\_readImData(), PHPExcel_Writer_HTML\_writeImageInCell(), PHPMailer\addAttachment(), HTML_Template_ITX\addBlockfile(), PHPMailer\addEmbeddedImage(), Gettext\Translation\addReference(), PHPMailer\addStringAttachment(), assKprimChoice\afterSyncWithOriginal(), ilTestArchiveService\archiveActivesPass(), ilTestPlayerAbstractGUI\archiveParticipantSubmission(), ilMimeMail\Attach(), ilBaseWorkflow\autoload(), benchmarkTest(), ilQuestionpoolExport\buildExportFileXLS(), ilTestExport\buildExportResultFile(), ilTestSubmissionReviewGUI\buildPdfFilename(), ilMultipleChoiceWizardInputGUI\checkInput(), ilImageWizardInputGUI\checkInput(), ilMatchingWizardInputGUI\checkInput(), ilSingleChoiceWizardInputGUI\checkInput(), assFileUpload\checkUpload(), ilKprimChoiceWizardInputGUI\checkUploads(), HTMLPurifier_DefinitionCache_Serializer\cleanup(), ilExportGUI\confirmDeletion(), assFlashQuestion\copyApplet(), assJavaApplet\copyApplet(), assImagemapQuestion\copyImage(), assOrderingQuestion\copyImages(), assMatchingQuestion\copyImages(), assMultipleChoice\copyImages(), assQuestion\copySuggestedSolutionFiles(), ilObjUserFolder\createCSVExport(), GuzzleHttp\Psr7\MultipartStream\createElement(), ilObjUserFolder\createExcelExport(), ilFileUtils\createFile(), ilObjFileBasedLMGUI\createFromDirectory(), ilHtmlToPdfTransformerFactory\createOneFileFromArray(), ilObjUserFolder\createXMLExport(), ilSCORM13Package\dbImportSco(), ilMailAttachmentGUI\deleteAttachments(), assMultipleChoice\deleteImage(), assMatchingQuestion\deleteImagefile(), ilExSubmission\deleteSelectedFiles(), ilMailFolderGUI\deliverFile(), ilObjTest\deliverPDFfromFO(), League\Flysystem\Util\MimeType\detectByFilename(), ilSoapUtils\disableSOAPCheck(), domxml_open_file(), ilObjFolderGUI\downloadFolderObject(), ilSCORM13Player\downloadLog(), ilExSubmission\downloadMultipleFiles(), ilObjLanguageExtGUI\downloadObject(), ilExSubmission\downloadSingleFile(), php4DOMDocument\dump_file(), sspmod_metarefresh_MetaLoader\dumpMetadataStdOut(), assFlashQuestion\duplicateApplet(), assJavaApplet\duplicateApplet(), assImagemapQuestion\duplicateImage(), assOrderingQuestion\duplicateImages(), assMatchingQuestion\duplicateImages(), assSingleChoice\duplicateImages(), SurveyQuestion\duplicateMaterials(), assQuestion\duplicateSuggestedSolutionFiles(), ilWikiStatGUI\export(), ilDclContentExporter\export(), ilMemberExportGUI\export(), ilSessionStatisticsGUI\exportCSV(), ilTable2GUI\exportData(), ilMemberExportGUI\exportExcel(), ilObjFileBasedLMGUI\exportHTML(), ilObjQuestionPoolGUI\exportQuestionObject(), ILIAS\Filesystem\Security\Sanitizing\FilenameSanitizerImpl\extractFileSuffix(), ilTemplate\fileExists(), getid3_lib\fileextension(), PHPMailer\filenameToType(), ilTemplate\fillCssFiles(), ilDclExportTableGUI\fillRow(), HTMLPurifier_DefinitionCache_Serializer\flush(), TCPDF_STATIC\fopenLocal(), assFlashQuestionImport\fromXML(), ilTestPDFGenerator\generatePDF(), assSingleChoice\generateThumbForFile(), assMultipleChoice\generateThumbForFile(), assKprimChoice\generateThumbForFile(), assOrderingQuestion\generateThumbForFile(), assMatchingQuestion\generateThumbForFile(), Magic\get_language(), cweagans\Composer\Patches\getAndApplyPatch(), ilObjTest\getCustomStyles(), assOrderingQuestion\getEncryptedFilename(), assMatchingQuestion\getEncryptedFilename(), ilDownloadFilesBackgroundTask\getEventFileNameFromId(), ilObjUserFolder\getExportFilename(), ilDclExportTableGUI\getExportFiles(), ilIndependentTemplate\getFile(), HTML_Template_IT\getFile(), ilAppointmentSessionFileHandler\getFiles(), PHPExcel_Shared_ZipArchive\getFromName(), ilMediaImageUtil\getImageSize(), ilUtil\getImageTagByType(), ilUtil\getJSLocation(), ilSCORM13Player\getMimetype(), CAS_PGTStorage_File\getPGTIouFilename(), ilImagemapPreview\getPreviewFilename(), ilSOAPStructureObjectAdministration\getStructureObjects(), ilUtil\getStyleSheetLocation(), ilTestSignaturePlugin\handInFileForArchiving(), ilExerciseXMLWriter\handleAssignmentFiles(), assKprimChoice\handleFileUpload(), ilObjFileGUI\handleFileUpload(), ilCertificate\importCertificate(), TCPDF_IMPORT\importPDF(), getid3_lib\IncludeDependency(), ilExAssignment\instructionFileInsertOrder(), ILIAS\FileUpload\Processor\BlacklistExtensionPreProcessor\isBlacklisted(), ILIAS\Filesystem\Security\Sanitizing\FilenameSanitizerImpl\isClean(), ILIAS\FileUpload\Processor\WhitelistExtensionPreProcessor\isWhitelisted(), ilTestExportGUI\listExportFiles(), Magic\load_file(), Core\load_file(), ilExcel\loadFromFile(), HTMLPurifier_Config\loadIni(), HTMLPurifier_LanguageFactory\loadLanguage(), sspmod_statistics_Aggregator\loadMetadata(), ilIndependentTemplate\loadTemplatefile(), HTML_Template_IT\loadTemplatefile(), ilTemplate\loadTemplatefile(), ilSCORM13Player\logFileName(), ilSCORM13Player\logTmpName(), GuzzleHttp\Psr7\mimetype_from_filename(), PHPMailer\msgHTML(), ilMultipleImagesInputGUI\onCheckInput(), ilSCORM13Player\openLog(), WavFile\openWav(), ilTestEvaluationGUI\outParticipantsResultsOverview(), LibRIS\RISReader\parseFile(), PHPMailerAutoload(), assJavaAppletGUI\populateQuestionSpecificFormPart(), ilSCORM13Player\postLogEntry(), ilStudyProgrammeType\processAndStoreIconFile(), ilOrgUnitType\processAndStoreIconFile(), ilExSubmission\processUploadedZipFile(), ilAccountMail\readAccountMail(), getid3_cue\readCueSheetFilename(), SimpleSAML\Locale\Translate\readDictionaryFile(), SimpleSAML\Locale\Translate\readDictionaryJSON(), SimpleSAML\Locale\Translate\readDictionaryPHP(), Twig_Tests_FilesystemHelper\removeDir(), assSingleChoiceGUI\removeimagechoice(), assMultipleChoiceGUI\removeimagechoice(), ilPDFGeneratorUtils\removePrintMediaDefinitionsFromStyleFile(), ilPDFGeneratorUtils\removeWrongPathFromStyleFiles(), ilObjFolder\renameDuplicateFile(), EasyPeasyICS\render(), HTML_Template_ITX\replaceBlockfile(), retrieveTicket(), GuzzleHttp\Psr7\rewind_body(), ILIAS\Filesystem\Security\Sanitizing\FilenameSanitizerImpl\sanitize(), ilDclContentExporter\sanitizeFilename(), PHPExcel_Shared_OLE_PPS_Root\save(), WavFile\save(), ilCertificate\saveCertificate(), ilChatroom\saveFileUploadToDb(), assMatchingQuestionImport\saveImage(), sspmod_statistics_Aggregator\saveMetadata(), ilUserImportParser\saveTempImage(), ilPageObject\send_paragraph(), ilObjSCORMLearningModule\sendExportFile(), ilBookmarkAdministrationGUI\sendmail(), phpCAS\setDebug(), ilFileXMLParser\setFileContents(), ilStaticMethodCallActivity\setIncludeFilename(), SimpleSAML_XHTML_Template\setupTwigTemplatepaths(), ilFileXMLWriter\start(), sspmod_statistics_Aggregator\store(), storeTicket(), ilFileDataForumDrafts\storeUploadedFile(), ilFileDataForum\storeUploadedFile(), ilSCORM13Player\summaryFileName(), ilFilePreviewRenderer\supports(), assSingleChoice\syncImages(), assMultipleChoice\syncImages(), assQuestion\syncSuggestedSolutionFiles(), Twig_Tests_FileExtensionEscapingStrategyTest\testGuess(), XEEValidatorTest\testInvalidXML(), ILIAS\FileUpload\Processor\BlacklistExtensionPreProcessorTest\testProcessWhichShouldSucceed(), ILIAS\FileUpload\Processor\WhitelistExtensionPreProcessorTest\testProcessWhichShouldSucceed(), ILIAS\FileUpload\Processor\FilenameOverridePreProcessorTest\testProcessWhichShouldSucceed(), ILIAS\FileUpload\Processor\BlacklistExtensionPreProcessorTest\testProcessWithBlacklistedEmptyExtensionWhichShouldGetRejected(), ILIAS\FileUpload\Processor\BlacklistExtensionPreProcessorTest\testProcessWithBlacklistedExtensionWhichShouldGetRejected(), ILIAS\FileUpload\Processor\WhitelistExtensionPreProcessorTest\testProcessWithoutExtensionWhichShouldSucceed(), ILIAS\FileUpload\Processor\WhitelistExtensionPreProcessorTest\testProcessWithoutWhitelistedExtensionWhichShouldGetRejected(), XEEValidatorTest\testValidXML(), Gettext\Languages\Exporter\Exporter\toFile(), ilObjFileGUI\update(), ilExerciseXMLParser\updateFile(), ilTestArchiver\updateTestArchive(), ilChatroomUploadFileGUI\uploadFile(), ilExAssignmentFileSystemGUI\uploadFile(), ilFSStorageExercise5069\uploadFile(), ilFSStorageExercise\uploadFile(), ilBadgeImageTemplate\uploadImage(), ILIAS\Filesystem\Security\Sanitizing\FilenameSanitizerImpl\validateFilename(), assMatchingQuestionGUI\writeAnswerSpecificPostData(), assSingleChoiceGUI\writeAnswerSpecificPostData(), assMultipleChoiceGUI\writeAnswerSpecificPostData(), ilChatroomConfigFileHandler\writeDataToFile(), SimpleSAML\Utils\System\writeFile(), SimpleSAML_Utilities\writeFile(), sspmod_metarefresh_MetaLoader\writeMetadataFiles(), assFlashQuestionGUI\writeQuestionSpecificPostData(), and ilExcel\writeToTmpFile().

$legend

$legend = new PHPExcel_Chart_Legend(PHPExcel_Chart_Legend::POSITION_RIGHT, NULL, false)

Definition at line 108 of file 33chartcreate-stock.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

PHPExcel.

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

$objWorksheet

$objWorksheet = $objPHPExcel->getActiveSheet()

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

$objWriter

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

Definition at line 136 of file 33chartcreate-stock.php.

$plotArea

$plotArea = new PHPExcel_Chart_PlotArea(NULL, array($series))

Definition at line 106 of file 33chartcreate-stock.php.

$series

$series

Initial value:

= new PHPExcel_Chart_DataSeries(
        PHPExcel_Chart_DataSeries::TYPE_STOCKCHART,     
        null,                                                                           
        range(0, count($dataSeriesValues)-1),           
        $dataSeriesLabels,                                                      
        $xAxisTickValues,                                                       
        $dataSeriesValues                                                       
)

Definition at line 96 of file 33chartcreate-stock.php.

$title

$title = new PHPExcel_Chart_Title('Test Stock Chart')

Definition at line 110 of file 33chartcreate-stock.php.

$xAxisLabel

$xAxisLabel = new PHPExcel_Chart_Title('Counts')

Definition at line 111 of file 33chartcreate-stock.php.

$xAxisTickValues

$xAxisTickValues

Initial value:

= array(
        new PHPExcel_Chart_DataSeriesValues('String', 'Worksheet!$A$2:$A$6', NULL, 5),  
)

Definition at line 78 of file 33chartcreate-stock.php.

$yAxisLabel

$yAxisLabel = new PHPExcel_Chart_Title('Values')

Definition at line 112 of file 33chartcreate-stock.php.

EOL

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

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

file

Done writing file

Definition at line 150 of file 33chartcreate-stock.php.

format

Write to Excel2007 format

Definition at line 135 of file 33chartcreate-stock.php.

MB

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

Definition at line 147 of file 33chartcreate-stock.php.

to

File written to

Definition at line 143 of file 33chartcreate-stock.php.

usage

Peak memory usage

Definition at line 147 of file 33chartcreate-stock.php.