phpexcel读取excel2007

注：phpexcel无法读取包含图片的excel，如果读取会报编码错误 

  

   

    

     

    
    

     

      header("content-Type: text/html; charset=UTF-8");
     
    
   

    

     

    
    

     

      error_reporting(E_ALL);
     
    
   

    

     

    
    

     

      require 'include/PHPExcel/Classes/PHPExcel.php';
     
    
   

    

     

    
    

     

      require 'include/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php';
     
    
   

    

     

    
    

     

      $excel_file = '2007.xlsx';
     
    
   

    

     

    
    

     
 
     
    
   

    

     

    
    

     

      $PHPExcel = new PHPExcel();
     
    
   

    

     

    
    

     

      $PHPReader = new PHPExcel_Reader_Excel2007(); //还有这句
     
    
   

    

     

    
    

     

      $PHPExcel = $PHPReader->load($excel_file);
     
    
   

    

     

    
    

     

      $sheet = $PHPExcel->getActiveSheet();
     
    
   

    

     

    
    

     

      $allCol=PHPExcel_Cell::columnIndexFromString($sheet->getHighestColumn());
     
    
   

    

     

    
    

     

      $allRow=$sheet->getHighestRow();
     
    
   

    

     

    
    

     

      for($col=1; $col<=$allCol;$col++)
     
    
   

    

     

    
    

     

      {
     
    
   

    

     

    
    

     

      for ($row=0;$row<$allRow;$row++)
     
    
   

    

     

    
    

     

      {
     
    
   

    

     

    
    

     

      echo $sheet->getCellByColumnAndRow($row,$col)->getValue()." ";
     
    
   

    

     

    
    

     

      }
     
    
   

    

     

    
    

     

      echo "<br/>";
     
    
  
 

文章来源: markwcm.blog.csdn.net，作者：黄啊码，版权归原作者所有，如需转载，请联系作者。

原文链接：markwcm.blog.csdn.net/article/details/105538187