phpExcel类库读取csv文件 和xlsx文件

//操作csv
$objReader = new PHPExcel_Reader_CSV();
$objReader->setInputEncoding('gb2312');
$objReader->setDelimiter(";");
$objPHPExcel = $objReader->load("Upload/month.csv");
$objSheet = $objPHPExcel->getActiveSheet();
           
$statementList = array();

for($i=2;$i<=$objSheet->getHighestRow();$i++){
      $row = $objSheet->getCell('A'.$i)->getValue();
      $row = split(",",$row);
      array_push($statementList,$row);
}
print_r($statementList);

操作xlsx，返回二维数组

//从文件返回sheet,不做任何处理，只返回二维数组
    private static function getArray($filePath,$width){
        Vendor("PHPExcel");
        $PHPExcel = new PHPExcel();
        
        $PHPReader = new PHPExcel_Reader_Excel2007();
        $PHPExcel = $PHPReader->load($filePath);
        
        $objPHPSheet = $PHPExcel->getActiveSheet();
        
       //$width = PHPExcel_Cell::columnIndexFromString($objPHPSheet->getHighestColumn());
        $height = $objPHPSheet->getHighestRow();
        $arr = array();
        for($i=1;$i<=$height;$i++){
            $row = array();
            for($j = 0;$j<$width;$j++){
                $cell = $objPHPSheet->getCellByColumnAndRow($j,$i)->getValue();
                array_push($row,$cell);
            }
            array_push($arr,$row);
        }
        
        spl_autoload_register(array('Think','autoload'));
        return $arr;
    }