kylewei606 的部落格

<?php    

    //引用 PHPExcel PHPExcel_1.8.0 
    require_once('../PHPExcel_1.8.0/Classes/PHPExcel.php');  

    //檔案路徑
    $inputFileName = ' example.xls';
 
    //檔案類型 (不是副檔名，是 Excel5, Excel2007, CSV, Excel2003XML)
    $inputFileType = PHPExcel_IOFactory::identify($inputFileName);
    
    /**  Create a new Reader of the type that has been identified  **/
    $objreader = PHPExcel_IOFactory::createReader($inputFileType);       

    /**  Load $inputFileName to a PHPExcel Object  **/
    $PHPExcel          = $objreader->load($inputFileName);
    $objWorksheet  = $PHPExcel->getActiveSheet();

    //存入陣列
    $sheetData = $objWorksheet->toArray(null, true, true, true);

    echo "<pre>", print_r($sheetData , 1), "</pre>";

?>