ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] exel¸ê®Æ®w§@±b¸¹±K½Xµn¿ý

[µo°Ý] exel¸ê®Æ®w§@±b¸¹±K½Xµn¿ý

§Ú·Q­n°µ¤@­Óexel¸ê®Æ®w§@±b¸¹±K½Xµn¿ýªº¨t²Î¥u­n±b¸¹,±K½X,¦W¦r©M¿ú¹ôªº¥\¯à´N¦n,
½Ð¨D¦U¦ì¤j¤j¤À¨É¤@¤U²³æªº¨BÆJ,±q³sµ²¨ì¨ú¥X¨ìŪ¨ú,¿é¤J³£¦b½u¤W¶i¦æ
¤j®a¦n,§Ú¬OÄг½!

¶Ç­È ¨ú­È »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 />";

}

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD