05featuredemo.inc.php File Reference

Go to the source code of this file.

Namespaces
	PHPExcel

Variables
Create new PHPExcel	object
Create new PHPExcel	EOL
	$objPHPExcel = new PHPExcel()
Set document	properties
Add some	data
Add	comments
	$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun('PHPExcel:')
Add rich text	string
	$objRichText = new PHPExcel_RichText()
	$objPayable = $objRichText->createTextRun('payable within thirty days after the end of the month')
Merge	cells
Set cell number	formats
Set column	widths
Set	fonts
Set	alignments
Set thin black border outline around	column
	$styleThinBlackBorderOutline
Set thick brown border outline around	Total
	$styleThickBrownBorderOutline
Set	fills
Unprotect a	cell
Add a hyperlink to an external	website
Add a hyperlink to another cell on a different worksheet within the	workbook
Add a drawing to the	worksheet
	$objDrawing = new PHPExcel_Worksheet_Drawing()
Play around with inserting and removing rows and	columns
Set header	footer
Set page orientation and	size
	$sLloremIpsum = 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus eget ante. Sed cursus nunc semper tortor. Aliquam luctus purus non elit. Fusce vel elit commodo sapien dignissim dignissim. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Curabitur accumsan magna sed massa. Nullam bibendum quam ac ipsum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin augue. Praesent malesuada justo sed orci. Pellentesque lacus ligula, sodales quis, ultricies a, ultricies vitae, elit. Sed luctus consectetuer dolor. Vivamus vel sem ut nisi sodales accumsan. Nunc et felis. Suspendisse semper viverra odio. Morbi at odio. Integer a orci a purus venenatis molestie. Nam mattis. Praesent rhoncus, nisi vel mattis auctor, neque nisi faucibus sem, non dapibus elit pede ac nisl. Cras turpis.'
Set the worksheet tab	color

Variable Documentation

$objCommentRichText

$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment('E11')->getText()->createTextRun('PHPExcel:')

Definition at line 94 of file 05featuredemo.inc.php.

$objDrawing

$objDrawing = new PHPExcel_Worksheet_Drawing()

Definition at line 284 of file 05featuredemo.inc.php.

$objPayable

$objPayable = $objRichText->createTextRun('payable within thirty days after the end of the month')

Definition at line 121 of file 05featuredemo.inc.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 37 of file 05featuredemo.inc.php.

$objRichText

$objRichText = new PHPExcel_RichText()

Definition at line 118 of file 05featuredemo.inc.php.

$sLloremIpsum

$sLloremIpsum = 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus eget ante. Sed cursus nunc semper tortor. Aliquam luctus purus non elit. Fusce vel elit commodo sapien dignissim dignissim. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Curabitur accumsan magna sed massa. Nullam bibendum quam ac ipsum. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin augue. Praesent malesuada justo sed orci. Pellentesque lacus ligula, sodales quis, ultricies a, ultricies vitae, elit. Sed luctus consectetuer dolor. Vivamus vel sem ut nisi sodales accumsan. Nunc et felis. Suspendisse semper viverra odio. Morbi at odio. Integer a orci a purus venenatis molestie. Nam mattis. Praesent rhoncus, nisi vel mattis auctor, neque nisi faucibus sem, non dapibus elit pede ac nisl. Cras turpis.'

Definition at line 342 of file 05featuredemo.inc.php.

$styleThickBrownBorderOutline

$styleThickBrownBorderOutline

Initial value:

= array(
        'borders' => array(
                'outline' => array(
                        'style' => PHPExcel_Style_Border::BORDER_THICK,
                        'color' => array('argb' => 'FF993300'),
                ),
        ),
)

Definition at line 191 of file 05featuredemo.inc.php.

$styleThinBlackBorderOutline

$styleThinBlackBorderOutline

Initial value:

= array(
        'borders' => array(
                'outline' => array(
                        'style' => PHPExcel_Style_Border::BORDER_THIN,
                        'color' => array('argb' => 'FF000000'),
                ),
        ),
)

Definition at line 178 of file 05featuredemo.inc.php.

alignments

Set alignments

Definition at line 166 of file 05featuredemo.inc.php.

cell

Unprotect a cell

Definition at line 266 of file 05featuredemo.inc.php.

cells

Protect cells

Definition at line 131 of file 05featuredemo.inc.php.

color

Set the worksheet tab color

Definition at line 354 of file 05featuredemo.inc.php.

Referenced by PHPExcel_Reader_Excel2007\_readStyle(), PHPExcel_Helper_HTML\buildTextRun(), PHPExcel_Helper_HTML\endFontTag(), PHPExcel_Helper_HTML\initialise(), ilCalendarCategory\read(), ilSystemStyleIconColor\setColor(), and ilCalendarCategory\setColor().

column

Set thin black border outline around column

Definition at line 177 of file 05featuredemo.inc.php.

Referenced by ilAssLacConditionParserException\__construct(), ilTable2GUI\addColumn(), ilTestQuestionsTableGUI\fillHeader(), ilQuestionBrowserTableGUI\fillHeader(), ilTable2GUI\fillHeader(), ilTable2GUI\fillHeaderCSV(), ilTable2GUI\fillHeaderExcel(), and ilTable2GUI\setData().

columns

Play around with inserting and removing rows and columns

Definition at line 316 of file 05featuredemo.inc.php.

Referenced by SurveyMatrixQuestion\__construct(), SurveyMatrixQuestion\addPhrase(), SurveyMatrixQuestion\addStandardNumbers(), TCPDF\addTOC(), TCPDF\checkPageRegions(), TCPDF\closeHTMLTagHandler(), SurveyMatrixQuestion\flushColumns(), SurveyMatrixQuestion\getColumn(), SurveyMatrixQuestion\getColumnCount(), SurveyMatrixQuestion\getColumnForScale(), SurveyMatrixQuestion\getColumnIndex(), ilXMLResultSetRow\getValue(), SurveyMatrixQuestion\importResponses(), ilOrgUnitTypeTableGUI\initColumns(), ilOrgUnitPositionTableGUI\initColumns(), ilStudyProgrammeTypeTableGUI\initColumns(), TCPDF\Ln(), SurveyMatrixQuestion\loadFromDb(), SurveyMatrixQuestion\removeColumn(), SurveyMatrixQuestion\removeColumns(), SurveyMatrixQuestion\removeColumnWithName(), TCPDF\selectColumn(), ilChartLegend\setColumns(), ilQTIRenderFib\setColumns(), TCPDF\setColumnsArray(), TCPDF\setEqualColumns(), TCPDF\setTableHeader(), and ilXMLResultSetRow\setValue().

comments

Add comments

Examples:

/usr/local/src/ilias/release_5-3/libs/composer/vendor/filp/whoops/src/Whoops/Exception/Frame.php.

Definition at line 91 of file 05featuredemo.inc.php.

Referenced by Gettext\Utils\ParsedFunction\__construct(), Gettext\Utils\ParsedFunction\addComment(), Whoops\Exception\Frame\addComment(), Gettext\Translation\addComment(), ilLanguageFile\build(), Gettext\Utils\ParsedFunction\close(), Gettext\Translation\deleteComments(), ilLanguageFile\getComment(), ilDclBaseRecordModel\getComments(), Gettext\Translation\hasComments(), Gettext\Translation\mergeWith(), ilLanguageFile\read(), Whoops\Exception\Frame\serialize(), ilLanguageFile\setAllComments(), ilLanguageFile\setComment(), ilObjSAHSLearningModule\setComments(), ilObjPortfolioBase\setPublicComments(), and Whoops\Exception\Frame\unserialize().

data

Add some data

Definition at line 51 of file 05featuredemo.inc.php.

EOL

Rename second EOL

Definition at line 32 of file 05featuredemo.inc.php.

fills

Set fills

Definition at line 202 of file 05featuredemo.inc.php.

fonts

Set fonts

Definition at line 152 of file 05featuredemo.inc.php.

Referenced by TCPDF\__construct(), TCPDF\getFontBuffer(), TCPDF\setFontBuffer(), TCPDF\setFontSubBuffer(), and showHelp().

footer

Set header footer

Definition at line 323 of file 05featuredemo.inc.php.

formats

Set cell number formats

Definition at line 142 of file 05featuredemo.inc.php.

Referenced by IMSGlobal\LTI\Profile\ServiceDefinition\__construct(), ilExportGUI\addFormat(), ilDclExportTableGUI\fillRow(), ilExportTableGUI\fillRow(), ilDclExportTableGUI\getExportFiles(), and ilExportTableGUI\getExportFiles().

object

Create a second Worksheet object

Definition at line 32 of file 05featuredemo.inc.php.

properties

Set document properties

Definition at line 40 of file 05featuredemo.inc.php.

size

Set page orientation and size

Definition at line 328 of file 05featuredemo.inc.php.

string

Add rich text string

Examples:

/usr/local/src/ilias/release_5-3/libs/composer/vendor/filp/whoops/src/Whoops/Handler/PrettyPageHandler.php.

Definition at line 117 of file 05featuredemo.inc.php.

Referenced by Twig_Markup\__construct(), ilClassificationProvider\__construct(), sspmod_core_Auth_Process_PHP\__construct(), sspmod_saml_Auth_Process_AuthnContextClassRef\__construct(), sspmod_saml_Auth_Process_AttributeNameID\__construct(), sspmod_cdc_Auth_Process_CDC\__construct(), sspmod_saml_Auth_Process_NameIDAttribute\__construct(), sspmod_saml_Auth_Process_PersistentNameID2TargetedID\__construct(), Gettext\Translation\__construct(), HTMLPurifier_Length\__construct(), ilUserFormSettings\__construct(), ilCommonActionDispatcherGUI\__construct(), ilSkinXML\__construct(), ilRpcClient\__construct(), ilObjBlogGUI\__construct(), GuzzleHttp\Psr7\Response\__construct(), Twig_Extensions_Grammar_Tag\__toString(), Twig_Extensions_Grammar_Optional\__toString(), Monolog\Formatter\TestStreamFoo\__toString(), Slim\Http\Response\__toString(), PHPExcel_Calculation_DateTime\_adjustDateByMonths(), PHPExcel_Reader_Excel2007\_castToBool(), PHPExcel_Reader_Excel2007\_castToError(), PHPExcel_Reader_Excel2007\_castToFormula(), PHPExcel_Reader_Excel2007\_castToString(), PHPExcel_Reader_Excel2007_Chart\_chartDataSeriesValues(), PHPExcel_Reader_Excel2007_Chart\_chartDataSeriesValueSet(), PHPExcel_Reader_Excel2007_Chart\_chartDataSeriesValuesMultiLevel(), PHPExcel_Writer_HTML\_createCSSStyleAlignment(), PHPExcel_Reader_HTML\_flushCell(), PHPExcel_Calculation_Engineering\_parseComplex(), MDB2_Driver_Datatype_Common\_quoteDecimal(), PHPExcel_Reader_Excel2007\_readRibbon(), PHPExcel_Reader_Excel2007\_readStyle(), PHPExcel_Chart_GridLines\_setGlowColor(), PHPExcel_Chart_GridLines\_setShadowAngle(), PHPExcel_Chart_Axis\_setShadowAngle(), PHPExcel_Chart_GridLines\_setShadowBlur(), PHPExcel_Chart_Axis\_setShadowBlur(), PHPExcel_Chart_GridLines\_setShadowColor(), PHPExcel_Chart_GridLines\_setShadowDistance(), PHPExcel_Chart_Axis\_setShadowDistance(), ilDateList\add(), ilObjGroupGUI\addCustomData(), Whoops\Handler\XmlResponseHandler\addDataToNode(), ilADTGroup\addElementValidationError(), ilECSObjectSettings\addMetadataToJson(), ilADT\addValidationError(), getid3_real\Analyze(), sspmod_saml_Auth_Source_SP\authenticate(), PHPExcel_Cell_DefaultValueBinder\bindValue(), PHPExcel_Calculation_Engineering\BINTODEC(), PHPExcel_Calculation_Engineering\BINTOHEX(), PHPExcel_Calculation_Engineering\BINTOOCT(), PHPExcel_Reader_Excel2007\boolean(), GuzzleHttp\Psr7\build_query(), ilIndividualAssessmentMembersTableGUI\buildActionDropDown(), Monolog\Handler\HipChatHandler\buildContent(), PHPExcel_Reader_OOCalc\canRead(), PHPExcel_Cell_DataType\checkErrorCode(), ilECSMappingSettingsGUI\cInitOverview(), PHPExcel_Calculation_Engineering\COMPLEX(), assFormulaQuestionResult\convertDecimalToCoprimeFraction(), GuzzleHttp\Psr7\MultipartStream\createElement(), ilECSMappingSettingsGUI\cSaveOverview(), ilSessionStatisticsGUI\current(), PHPExcel_Calculation_Engineering\DECTOBIN(), PHPExcel_Calculation_Engineering\DECTOHEX(), PHPExcel_Calculation_Engineering\DECTOOCT(), Slim\App\dispatchRouterAndPrepareRoute(), Twig_Template\displayBlock(), Twig_Template\displayParentBlock(), IMSGlobal\LTI\ToolProvider\ResourceLink\domnodeToArray(), ilAccountRegistrationGUI\doProfileAutoComplete(), ilPublicUserProfileGUI\doProfileAutoComplete(), ilRepositorySearchGUI\doUserAutoComplete(), Symfony\Component\Yaml\Inline\dump(), Gettext\Utils\PhpFunctionsScanner\enableCommentsExtraction(), sspmod_saml_IdP_SAML2\encodeAttributes(), Symfony\Component\Yaml\Inline\evaluateScalar(), Twig_Loader_Chain\exists(), ilMathBaseAdapter\exp2dec(), sspmod_authtwitter_Auth_Source_Twitter\finalStep(), getid3_lib\Float2BinaryDecimal(), ilAssSelfAssessmentQuestionFormatter\format(), HTMLPurifier_Generator\generateFromTokens(), sspmod_cdc_Server\get(), ilForumCronNotificationDataProvider\getAuthorInformation(), Twig_Loader_Array\getCacheKey(), sspmod_discopower_PowerIdPDisco\getCDC(), sspmod_cdc_Server\getCDC(), Gettext\Translation\getClone(), ilSCORM13Player\getConfigForPlayer(), ilECSMappingUtils\getCourseValueByMappingAttribute(), ilConsultationHourGroups\getGroupSelectOptions(), ilAttendanceList\getHTML(), ilOrgUnitTypeTranslation\getMember(), ilAttendanceList\getNonMemberUserData(), Slim\Http\Request\getParsedBody(), Gettext\Translation\getPluralTranslation(), ilForumCronNotificationDataProvider\getPostUpdateUserName(), assOrderingHorizontalGUI\getPreview(), ilCourseMembershipGUI\getPrintMemberData(), ilMailSearchLuceneResultParser\getResult(), Twig_Loader_Array\getSource(), Twig_Loader_Array\getSourceContext(), ilAssOrderingFormValuesObjectsConverter\getStructValueFromObject(), ilAuthProviderApache\getUserAuthModeName(), sspmod_cdc_Server\handleAppend(), Monolog\Handler\RavenHandler\handleBatch(), enshrined\svgSanitize\data\XPath\handleDefaultNamespace(), sspmod_cdc_Server\handleRequest(), PHPExcel_Calculation_Engineering\HEXTOBIN(), PHPExcel_Calculation_Engineering\HEXTODEC(), PHPExcel_Calculation_Engineering\HEXTOOCT(), ilAdvancedMDFieldDefinitionText\importFromECS(), ilVerificationObject\importProperty(), ilRoleXmlImporter\importSimpleXml(), ilLoggingSetupSettings\init(), ilAuthContainerCAS\initCAS(), ilContainerXmlParser\initItem(), arFieldList\initRawFields(), ilAssQuestionProcessLockFileStorage\initSubPath(), SimpleSAML\Store\SQL\insertOrUpdate(), GuzzleHttp\Psr7\UriNormalizer\isEquivalent(), Twig_Loader_Array\isFresh(), ilObjectOwnershipManagementGUI\listObjects(), PHPExcel_Reader_Gnumeric\listWorksheetInfo(), PHPExcel_Reader_Excel2003XML\listWorksheetInfo(), PHPExcel_Reader_Excel2007\listWorksheetInfo(), PHPExcel_Reader_Gnumeric\listWorksheetNames(), PHPExcel_Reader_Excel2007\listWorksheetNames(), PHPExcel_Reader_Excel2007\load(), ilChatroomAdmin\loadClientSettings(), PHPExcel_Reader_Gnumeric\loadIntoExisting(), PHPExcel_Reader_Excel2003XML\loadIntoExisting(), PHPExcel_Reader_OOCalc\loadIntoExisting(), SimpleSAML\Auth\Simple\login(), ilIndividualAssessmentMember\LPStatusValid(), ilIndividualAssessmentMember\mayBeFinalized(), ilIndividualAssessmentMember\maybeSendNotification(), getid3_lib\MultiByteCharString2HTML(), PHPExcel_Calculation_Engineering\OCTTOBIN(), PHPExcel_Calculation_Engineering\OCTTODEC(), PHPExcel_Calculation_Engineering\OCTTOHEX(), ilSamlIdpXmlMetadataParser\parse(), Symfony\Component\Yaml\Parser\parse(), ilLuceneHighlighterResultParser\parse(), GeSHi\parse_code(), HTMLPurifier_Lexer_DirectLex\parseAttributeString(), ilSkinStyleXML\parseFromXMLElement(), getid3_id3v2\ParseID3v2Frame(), ilLOXmlParser\parseMaterials(), ilLOXmlParser\parseSettings(), ilLOXmlParser\parseTests(), ilContainerXmlParser\parseTiming(), ilLuceneSearcher\performSearch(), ilLuceneSearchGUI\performSearch(), ilDBPdoFieldDefinition\quoteDecimal(), ilOrgUnitTypeTranslation\read(), ilAdvancedMDRecordExportFiles\readFilesInfo(), sspmod_saml_IdP_SAML1\receiveAuthnRequest(), sspmod_saml_IdP_SAML2\receiveAuthnRequest(), Slim\Http\Request\registerMediaTypeParser(), ilTinyMCE\removeRedundantSeparators(), Slim\Handlers\NotFound\renderHtmlNotFoundOutput(), Slim\App\respond(), ilObjSurveyGUI\savePropertiesObject(), HTMLPurifier_UnitConverter\scale(), ilMailSearchGUI\search(), ilSoapObjectAdministration\searchObjects(), ilMailFormGUI\sendMessage(), Slim\Http\Cookies\set(), GeSHi\set_line_ending(), PHPExcel_Chart_Axis\setAxisNumberProperties(), PHPExcel_Chart_Axis\setAxisOptionsProperties(), PHPExcel_Chart_Axis\setAxisOrientation(), ilObjPortfolioBase\setBackgroundColor(), ilObjBlog\setBackgroundColor(), ilChartDataBars\setBarOptions(), ilSCORM2004StoreData\setCMIData(), ilRatingCategory\setDescription(), ilADTSearchBridge\setElementId(), ilADTDBBridge\setElementId(), ilADTActiveRecordBridge\setElementId(), ilADTFormBridge\setElementId(), ilADTActiveRecordByType\setElementIdColumn(), ilEventDetector\setEvent(), ilEventDetector\setEventContext(), ilEventDetector\setEventSubject(), assQuestion\setExportImagePath(), ilExAssignment\setFeedbackCron(), ilExAssignment\setFeedbackFile(), ilObjPortfolioBase\setFontColor(), ilObjBlog\setFontColor(), ilSystemNotification\setGotoLangId(), ilAttendanceList\setId(), ilObjPoll\setImage(), ilObjPortfolioBase\setImage(), ilObjBlog\setImage(), ilSystemNotification\setIntroductionLangId(), ilChartData\setLabel(), ilOrgUnitTypeTranslation\setMember(), Whoops\Handler\PrettyPageHandler\setPageTitle(), ilADTFormBridge\setParentElement(), League\Flysystem\Adapter\AbstractAdapter\setPathPrefix(), Gettext\Translation\setPlural(), ilChartLegend\setPosition(), ilObjPoll\setQuestion(), ilSystemNotification\setReasonLangId(), ilUserAutoComplete\setResultField(), PHPExcel_Chart_Axis\setSoftEdges(), PHPExcel_Chart_GridLines\setSoftEdgesSize(), ilSystemNotification\setSubjectLangId(), ilCommonActionDispatcherGUI\setSubObject(), ilDB\setSubType(), ilADTDBBridge\setTable(), ilADTActiveRecordBridge\setTable(), ilSystemNotification\setTaskLangId(), Twig_Loader_Array\setTemplate(), ilRatingCategory\setTitle(), Gettext\Translation\setTranslation(), PHPExcel_Cell\setValueExplicit(), ilSessionStatisticsGUI\short(), ilOrgUnitSimpleImport\simpleImportElement(), ilOrgUnitSimpleUserImport\simpleUserImportElement(), ilForumXMLWriter\start(), ilSimpleXMLTableDataParser\startParsing(), ilStr\strToUpper(), ilSCORM13Player\summaryFileName(), ilPCDataTableGUI\tableAction(), assOrderingHorizontal\toJSON(), assTextSubset\toJSON(), assTextQuestion\toJSON(), assLongMenu\toJSON(), assImagemapQuestion\toJSON(), assKprimChoice\toJSON(), assSingleChoice\toJSON(), assMultipleChoice\toJSON(), assErrorText\toJSON(), assOrderingQuestion\toJSON(), assMatchingQuestion\toJSON(), assClozeTest\toJSON(), ilECSUser\toREALM(), assMultipleChoiceExport\toXML(), ConfigDoc_HTMLXSLTProcessor\transformToHTML(), ilInitialisation\translateMessage(), twig_date_converter(), twig_urlencode_filter(), HTMLPurifier_AttrDef_CSS_Color\validate(), sspmod_cdc_Server\validate(), ilWikiStatGUI\viewToolbar(), and ILIAS\UI\Implementation\Component\Item\Item\withLeadText().

Total

Set thick brown border outline around Total

Definition at line 190 of file 05featuredemo.inc.php.

website

Add a hyperlink to an external website

Definition at line 270 of file 05featuredemo.inc.php.

widths

Set column widths

Definition at line 146 of file 05featuredemo.inc.php.

workbook

Add a hyperlink to another cell on a different worksheet within the workbook

Definition at line 276 of file 05featuredemo.inc.php.

Referenced by ilExcel\__construct(), ilExcel\addSheet(), ilExcel\getCell(), ilExcel\getColumnCount(), ilExcel\getSheetAsArray(), ilExcel\getSheetCount(), ilExcel\getSheetTitle(), ilExcel\loadFromFile(), ilExcel\prepareStorage(), ilExcel\sendToClient(), ilExcel\setActiveSheet(), ilExcel\setBold(), ilExcel\setBorders(), ilAssExcelFormatHelper\setCell(), ilExcel\setCell(), ilExcel\setCellArray(), ilAssExcelFormatHelper\setCellByCoordinates(), ilExcel\setCellByCoordinates(), ilExcel\setColors(), ilExcel\setGlobalAutoSize(), ilExcel\writeToFile(), and ilExcel\writeToTmpFile().

worksheet

Rename second worksheet

Definition at line 283 of file 05featuredemo.inc.php.