Header Image
setReadDataOnly(true); $objPHPExcel = $objReader->load("Publications_list_SPP_web.xlsx"); $objWorksheet = $objPHPExcel->getActiveSheet(); $highestRow = $objWorksheet->getHighestRow(); $highestColumn = $objWorksheet->getHighestColumn(); $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); $text_content =""; for ($row =3; $row <= $highestRow; ++$row) { $Auto1 = $objWorksheet->getCellByColumnAndRow(1, $row)->getValue() ; $Tit = $objWorksheet->getCellByColumnAndRow(22, $row)->getValue() ; if (strlen($Auto1) > 1) $text_content = $text_content . " " . $Tit; } ?> setBackgroundColor("white"); $cloud->setUTF8(true); $cloud->addTagsFromText($text_content); $cloud->setSearchURL("http://www.megacities-megachallenge.org/publications_search.php?cltop="); $cloud->setWidth("140px"); $arCustomColors[0] = "#222222"; $arCustomColors[1] = "#333333"; $arCustomColors[2] = "#444444"; $arCustomColors[3] = "#555555"; $arCustomColors[4] = "#777777"; $arCustomColors[5] = "#888888"; $arCustomColors[6] = "#999999"; $arCustomColors[7] = "#aaaaaa"; $arCustomColors[8] = "#bbbbbb"; $arCustomColors[9] = "#cccccc"; $cloud->setTextColors($arCustomColors); echo $cloud->emitCloud(); ?>

Publication list

Filter by author (truncation is ok, e.g. kra for Kraas):
Filter by title:

setReadDataOnly(true); $objPHPExcel = $objReader->load("Publications_list_SPP_web.xlsx"); $objWorksheet = $objPHPExcel->getActiveSheet(); $highestRow = $objWorksheet->getHighestRow(); // e.g. 10 $highestColumn = $objWorksheet->getHighestColumn(); // e.g 'F' $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn); // e.g. 5 echo ''; ?>