通过PHPExcel读取.xls文件会引发致命错误：允许内存大小…即使使用块读取器也是如此

作为附录3的问题

edit1：也有了这个解决方案,我用我最喜欢的errr消息来阻塞,但我发现了一些关于缓存的东西,所以我实现了这个

$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_PHPTemp;
$cacheSetTings = array(' memoryCacheSize ' => '8MB');
PHPExcel_SetTings::setCacheStorageMethod($cacheMethod,$cacheSetTings);

最近我测试它仅适用于小于10MB的xls文件,但它似乎工作(我也设置$objReader-> setReadDataOnly(true);)它似乎足够平衡以实现速度和内存消耗. (如果可能的话,我将更多地遵循我的棘手路径)

EDIT2：
所以我做了一些进一步的研究,发现我的方式不需要大块阅读器. (对我而言,内存问题与大块阅读器相同,没有它.)所以我对我的问题的最终答案是这样的,它读取.xls文件(只有来自单元格的数据,没有格式化,甚至过滤公式).当我使用cache_tp_PHP_temp我能够在几秒钟内读取xls文件(测试到10MB)和大约10k行和多列并且没有内存问题

function parseXLS($fileName){

/** PHPExcel_IOFactory */
    require_once dirname(__FILE__) . './sphider_design/include/Excel/PHPExcel/IOFactory.PHP';
    require_once dirname(__FILE__) . './sphider_design/include/Excel/PHPExcel/ChunkReadFilter.PHP';
    require_once dirname(__FILE__) . './sphider_design/include/Excel/PHPExcel.PHP';

    $inputFilename = $filename;
    $fileContent = "";

    //get inputFileType (most of time Excel5)
    $inputFileType = PHPExcel_IOFactory::identify($inputFileName);

    //initialize cache,so the PHPExcel will not throw memory overflow
    $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_PHPTemp;
    $cacheSetTings = array(' memoryCacheSize ' => '8MB');
    PHPExcel_SetTings::setCacheStorageMethod($cacheMethod,$cacheSetTings);

    //initialize object reader by file type
    $objReader = PHPExcel_IOFactory::createReader($inputFileTypE);

    //read only data (without formaTing) for memory and time perfoRMANce
    $objReader->setReadDataOnly(true);

    //load filE into PHPExcel object
    $objPHPExcel = $objReader->load($inputFileName);

    //get worksheetIterator,so we can loop sheets in workbook
    $worksheetIterator = $objPHPExcel->getWorksheetIterator();

    //loop all sheets
    foreach ($worksheetIterator as $worksheet) {    

            //use worksheet rowIterator,to get content of each row
            foreach ($worksheet->getRowIterator() as $row) {
                //use cell iterator,to get content of each cell in row
                $cellIterator = $row->getCellIterator();
                //dunno
                $cellIterator->setIterateOnlyExisTingCells(false);      

                //iterate each cell
                foreach ($cellIterator as $cell) {
                    //check if cell exists
                    if (!is_null($cell)) {
                        //get raw value (without formaTing,and all unnecessary trash)
                        $rawValue = $cell->getValue();
                        //if cell isnt empty,print its value
                        if ((trim($rawvalue) <> "") and (substr(trim($rawvalue),1) <> "=")){
                            $fileContent .= $rawValue . " ";                                            
                        }
                    }
                }       
            }       
    }

    return $fileContent;
}