<?php

include_once("PHPExcel/PHPExcel.php");

$excelObj = PHPExcel_IOFactory::createReader('Excel2007');
$excelObj->setReadDataOnly(true);

$file = 'ImportFile.xlsx';
$objPHPExcel = $excelObj->load($file);
$data = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

if(!empty($data)){

    //移除標題列
    unset($data['1']);
    foreach ($data as $date_row){
        echo $date_row["A"]."\n";
    }
}

查看原文 >>
相关文章