phpexcel导入xlsx文件报错xlsx is not recognised as an OLE file 怎么办

最新推荐文章于 2022-10-08 09:14:09 发布

weixin_30617561

最新推荐文章于 2022-10-08 09:14:09 发布

阅读量971

点赞数

CC 4.0 BY-SA版权

文章标签： php

原文链接：http://www.cnblogs.com/xiaoleiel/p/8333896.html

本文介绍了一种解决使用PHPExcel库读取Excel文件时遇到的问题的方法。当尝试读取一个.xlsx文件时，PHPExcel将其误认为.xls文件导致读取失败。通过判断文件扩展名并选择正确的读取器类型解决了这一问题。

最初的做法

代码如下

1	include 'classes/PHPExcel/IOFactory.php';
2	$inputFileName = $target;
3	$objReader = new PHPExcel_Reader_Excel5();
4	$objPHPExcel = $objReader->load($inputFileName); $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true); $count = count($sheetData); for($i=1;$i<=$count;$i++) { echo (iconv('utf-8','gbk',$sheetData[$i]['A'])).'<hr />'; }

报错

PHPExcel_Reader_Exception: The filename .1443578799.xlsx is not recognised as an OLE file in Classes\PHPExcel\Shared\OLERead.php on line 89

( ! ) Fatal error: Uncaught exception 'PHPExcel_Reader_Exception' with message 'The filename 1443578799.xlsx is not recognised as an OLE file' in Classes\PHPExcel\Shared\OLERead.php on line 89
( ! ) PHPExcel_Reader_Exception: The filename 1443578799.xlsx is not recognised as an OLE file in Classes\PHPExcel\Shared\OLERead.php on line 89
Call Stack

碰到这个问题我们是因为xlsx出错了，可能通过类型判断解决办法如下

代码如下