[insert_php]
require_once ‘excel/PHPExcel/IOFactory.php’;
$objPHPExcel = PHPExcel_IOFactory::load(“excel/etlap-heti.xls”);
$kaja = array();
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
$highestColumn = $worksheet->getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$nrColumns = ord($highestColumn) – 64;
for ($row = 1; $row <= $highestRow; ++ $row) {
for ($col = 0; $col < $highestColumnIndex; ++ $col) {
$cell = $worksheet->getCellByColumnAndRow($col, $row);
$val = $cell->getValue();
$dataType = PHPExcel_Cell_DataType::dataTypeForValue($val);
$kaja[$row-1][$col] = $val;
}
}
}
$napok=array(‘HÉTFŐ’, ‘KEDD’, ‘SZERDA’, ‘CSÜTÖRTÖK’, ‘PÉNTEK’, ‘SZOMBAT’);
for($i=1;$i<7;$i++){
echo '
| Leves: | ‘.$kaja[$i][1].’ |
|---|---|
| A második: | ‘.$kaja[$i][2].’ |
| B második: | ‘.$kaja[$i][3].’ |
| Fitness: | ‘.$kaja[$i][4].’ |
| Húsnélküli: | ‘.$kaja[$i][5].’ |
| Őszi: | ‘.$kaja[$i][6].’ |
‘;
}
[/insert_php]
A teljes menü választékot letöltheti a bal oldali menüben.
