使用phpexcel导入excel出现问题,怎么解决???
exception 'PHPExcel_Reader_Exception' with message 'Could not open 20131025085845.xls for reading! File does not exist, or it is not readable.' in E:\wamp\www\student_message\ThinkPHP\Extend\Vendor\Excel\PHPExcel\Shared\OLERead.php:80 Stack trace: #0 E:\wamp\www\student_message\ThinkPHP\Extend\Vendor\Excel\PHPExcel\Reader\Excel5.php(1067): PHPExcel_Shared_OLERead->read('20131025085845....') #1 E:\wamp\www\student_message\ThinkPHP\Extend\Vendor\Excel\PHPExcel\Reader\Excel5.php(571):
执行代码如下:
public function read($filename,$encode,$file_type){
if(strtolower ( $file_type )=='xls')//判断excel表类型为2003还是2007
{
Vendor("Excel.PHPExcel.Reader.Excel5");
$objReader = PHPExcel_IOFactory::createReader('Excel5');
}elseif(strtolower ( $file_type )=='xlsx')
{
Vendor("Excel.PHPExcel.Reader.Excel2007");
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
}
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load($filename);
$objWorksheet = $objPHPExcel->getActiveSheet();
$highestRow = $objWorksheet->getHighestRow();
$highestColumn = $objWorksheet->getHighestColumn();
$highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
$excelData = array();
for ($row = 1; $row <= $highestRow; $row++) {
for ($col = 0; $col < $highestColumnIndex; $col++) {
$excelData[$row][] =(string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
}
}
return $excelData;
}