mssiao

¶Ç­È ¨ú­È »P §P§O

¥H¤U¬O¤Þ¥Î¼~ÂŹڹҪºBLOG ¨úexcelªº­È

<?php
set_include_path(get_include_path() . PATH_SEPARATOR . './Classes/');
include 'PHPExcel/IOFactory.php';

$reader = PHPExcel_IOFactory::createReader('Excel5'); // Ū¨úª© excel ÀÉ®×
$PHPExcel = $reader->load("course_table.xls"); // ÀɮצWºÙ
$sheet = $PHPExcel->getSheet(0); // Ū¨ú²Ä¤@­Ó¤u§@ªí(½s¸¹±q 0 ¶}©l)
$highestRow = $sheet->getHighestRow(); // ¨ú±oÁ`¦C¼Æ

// ¤@¦¸Åª¨ú¤@¦C
for ($row = 2; $row <= $highestRow; $row++) {

    for ($column = 1; $column <= 9; $column++) {
        $val = $sheet->getCellByColumnAndRow($column, $row)->getValue();
        echo $val . ' ';
    }
    echo "<br />";

}