39dropdown.php File Reference

Go to the source code of this file.

Namespaces
namespace	PHPExcel

Functions
	transpose ($value)

Variables
const	EOL (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'
	$objPHPExcel = new PHPExcel()
	$continentColumn = 'D'
	$column = 'F'
	$objValidation
	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007')
	memory_get_peak_usage (true)/1024/1024)

Function Documentation

transpose()

transpose

(

$value

)

Definition at line 56 of file 39dropdown.php.

                           {
    return array($value);
}
 
// Add some data
$continentColumn = 'D';
$column = 'F';
 
// Set data for dropdowns
foreach(glob('./data/continents/*') as $key => $filename) {
    $continent = pathinfo($filename, PATHINFO_FILENAME);
    echo "Loading $continent", EOL;
    $continent = str_replace(' ','_',$continent);
    $countries = file($filename, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
    $countryCount = count($countries);
 
    // Transpose $countries from a row to a column array
    $countries = array_map('transpose', $countries);
    $objPHPExcel->getActiveSheet()
        ->fromArray($countries, null, $column . '1');
    $objPHPExcel->addNamedRange(
        new PHPExcel_NamedRange(
            $continent, 
            $objPHPExcel->getActiveSheet(), $column . '1:' . $column . $countryCount
        )
    );
    $objPHPExcel->getActiveSheet()
        ->getColumnDimension($column)
        ->setVisible(false);
 
    $objPHPExcel->getActiveSheet()
        ->setCellValue($continentColumn . ($key+1), $continent);
 
    ++$column;
}

Variable Documentation

$column

$column = 'F'

Definition at line 62 of file 39dropdown.php.

Referenced by ilStudyProgrammeMembersTableGUI\__construct(), ilTermsOfServiceAcceptanceHistoryTableGUI\__construct(), ilStudyProgrammeIndividualPlanTableGUI\__construct(), MDB2_Result_Common\_assignBindColumns(), PHPExcel_Reader_HTML\_flushCell(), MDB2_Result_mysql\_getColumnNames(), MDB2_Result_mysqli\_getColumnNames(), MDB2_Result_oci8\_getColumnNames(), MDB2_Result_pgsql\_getColumnNames(), ilMailBoxQuery\_getMailBoxListData(), PHPExcel_Reader_Excel5\_includeCellRangeFiltered(), PHPExcel_Reader_HTML\_processDomElement(), PHPExcel_Reader_Excel5\_readBIFF8CellAddress(), PHPExcel_Reader_Excel5\_readBIFF8CellAddressB(), PHPExcel_Reader_Excel5\_readBoolErr(), PHPExcel_Reader_Excel5\_readFormula(), PHPExcel_Reader_Excel5\_readLabel(), PHPExcel_Reader_Excel5\_readLabelSst(), PHPExcel_Reader_Excel5\_readNumber(), PHPExcel_Reader_Excel5\_readRk(), PHPExcel_Reader_HTML\_setTableStartColumn(), PHPExcel_Writer_Excel2007_Worksheet\_writeAutoFilter(), PHPExcel_Writer_OpenDocument_Content\_writeCells(), PHPExcel_Writer_Excel5_Worksheet\_writePanes(), PHPExcel_Writer_Excel2007_Comments\_writeVMLComment(), PHPExcel_Cell\absoluteCoordinate(), MDB2_Result_Common\bindColumn(), PHPExcel_Writer_HTML\buildCSS(), ilObjBookingPoolGUI\buildDatesBySchedule(), PHPExcel_Calculation_LookupRef\CELL_ADDRESS(), PHPExcel_Writer_Excel5_Escher\close(), PHPExcel_Writer_Excel5_Worksheet\close(), TCPDF\closeHTMLTagHandler(), TCPDF\drawHTMLTagBorder(), ilSessionStatisticsGUI\exportCSV(), PHPExcel_Cell\extractAllCellReferencesInRange(), MDB2_Result_Common\fetchCol(), ilTestQuestionsTableGUI\fillHeader(), ilQuestionBrowserTableGUI\fillHeader(), ilTable2GUI\fillHeader(), ilTable2GUI\fillHeaderCSV(), ilTable2GUI\fillHeaderExcel(), ilStudyProgrammeIndividualPlanTableGUI\fillRow(), ilStudyProgrammeMembersTableGUI\fillRow(), ilMailTemplateTableGUI\fillRow(), ilTermsOfServiceTableGUI\fillRow(), ilMailTemplateTableGUI\formatCellValue(), ilTermsOfServiceAcceptanceHistoryTableGUI\formatCellValue(), ilTermsOfServiceAgreementByLanguageTableGUI\formatCellValue(), ilTermsOfServiceTableGUI\formatCellValue(), ilMailAttachmentTableGUI\formatValue(), PHPExcel_Writer_HTML\generateSheetData(), PHPExcel_CachedObjectStorage_CacheBase\getCurrentColumn(), PHPExcel_CachedObjectStorage_CacheBase\getCurrentRow(), PHPExcel_Worksheet\getHighestDataRow(), PHPExcel_CachedObjectStorage_CacheBase\getHighestRow(), PHPExcel_Worksheet\getHighestRow(), ilTrMatrixTableGUI\getItems(), ilTrQuery\getObjectAccessStatistics(), ilTrQuery\getObjectLPStatistics(), ilTrSummaryTableGUI\getSelectableColumns(), PHPExcel_CachedObjectStorage_CacheBase\getSortedCellList(), MDB2_Driver_Reverse_mysql\getTableFieldDefinition(), MDB2_Driver_Reverse_mysqli\getTableFieldDefinition(), MDB2_Driver_Reverse_oci8\getTableFieldDefinition(), MDB2_Driver_Reverse_pgsql\getTableFieldDefinition(), ilDBPdoReverse\getTableFieldDefinition(), SurveyMatrixQuestion\hasNeutralColumn(), ilDclContentImporter\import(), SurveyMatrixQuestion\importResponses(), ilOrgUnitPositionTableGUI\initColumns(), ilOrgUnitTypeTableGUI\initColumns(), ilStudyProgrammeTypeTableGUI\initColumns(), ilTrObjectUsersPropsTableGUI\initFilter(), PHPExcel_ReferenceHelper\insertNewBefore(), ilTermsOfServiceTableGUI\isColumnVisible(), ilDBPdo\like(), ilMySQLQueryUtils\like(), ilPostgresQueryUtils\like(), PHPExcel_Reader_Excel2007\load(), PHPExcel_Reader_Excel5\load(), PHPExcel_Reader_HTML\loadIntoExisting(), PHPExcel_Reader_SYLK\loadIntoExisting(), PHPExcel_Calculation_MathTrig\MDETERM(), PHPExcel_Calculation_MathTrig\MINVERSE(), TCPDF\MultiCell(), ilTestExportTableGUI\numericOrdering(), ilQuestionBrowserTableGUI\numericOrdering(), ilQuestionPoolPrintViewTableGUI\numericOrdering(), ilMailSearchCoursesTableGUI\numericOrdering(), ilMailAttachmentTableGUI\numericOrdering(), ilTermsOfServiceAcceptanceHistoryTableGUI\numericOrdering(), ilTermsOfServiceAgreementByLanguageTableGUI\numericOrdering(), PHPExcel_Shared_Excel5\oneAnchor2twoAnchor(), PHPExcel_CachedObjectStorage_CacheBase\removeColumn(), PHPExcel_Worksheet_ColumnIterator\seek(), PHPExcel_Worksheet_RowCellIterator\seek(), PHPExcel_Worksheet_AutoFilter\setColumn(), MDB2_Driver_Reverse_oci8\tableInfo(), PHPExcel_Worksheet_AutoFilter\testColumnInRange(), WorksheetColumnTest\testGetCellIterator(), WorksheetColumnTest\testInstantiateColumnDefault(), WorksheetColumnTest\testInstantiateColumnSpecified(), ColumnIteratorTest\testIteratorFullRange(), ColumnIteratorTest\testIteratorStartEndRange(), PHPExcel_Calculation_LookupRef\TRANSPOSE(), PHPExcel_ReferenceHelper\updateFormulaReferences(), and ilWikiStat\writeData().

$continentColumn

$continentColumn = 'D'

Definition at line 61 of file 39dropdown.php.

$objPHPExcel

$objPHPExcel = new PHPExcel()

Definition at line 42 of file 39dropdown.php.

$objValidation

$objValidation

Initial value:

= $objPHPExcel->getActiveSheet()
    ->getCell('B1')
    ->getDataValidation()

Definition at line 119 of file 39dropdown.php.

$objWriter

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

Definition at line 166 of file 39dropdown.php.

EOL

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

Definition at line 34 of file 39dropdown.php.

memory_get_peak_usage

memory_get_peak_usage(true)/1024/1024)

(

true

)

Definition at line 171 of file 39dropdown.php.