phpExcel导入不同excel版本遇到的问题

来源：互联网发布：软件界面的英文编辑：程序博客网时间：2024/06/16 10:00

function getExcelData($filename) {
    $objReader = PHPExcel_IOFactory::createReader('Excel5');
    $objReader->setReadDataOnly(true);
    $objPHPExcel   = $objReader->load($filename);
    $objWorksheet  = $objPHPExcel->getActiveSheet();
    $highestRow    = $objWorksheet->getHighestRow();
    $highestColumn = $objWorksheet->getHighestColumn();
    $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);
    if($highestRow==0) return;
    
    for($row = 1; $row <= $highestRow; $row++) {
        for($col = 0; $col < $highestColumnIndex; $col++) {
            $excelData[$row][] = (string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
        }
    }
 
    return $excelData;
}

结果发现有些excel文件上传读取失败，直接服务器500。检查看了下，原来php excel在不同的版本，实例化类是不一样的。
2003以前的excel读取实例化excel5类，2003以后需要实例化excel2007类，so，改改$objReader实例化的地方：

$objReader = PHPExcel_IOFactory::createReader('Excel2007');
if(!$objReader->canRead($filename)) {
    $objReader = PHPExcel_IOFactory::createReader('Excel5');
    if(!$objReader->canRead($filename)) return;
}

0 0