duanheye7423 2019-03-18 15:26
浏览 85

缓存中不再存在单元格条目A1

I use PhpOffice\PhpSpreadsheet with Apcu caching, and i have this error
Error: Cell entry A1 no longer exists in cache. This probably means that the cache was cleared by someone else.

$pool = new \Cache\Adapter\Apcu\ApcuCachePool();
$simpleCache = new \Cache\Bridge\SimpleCache\SimpleCacheBridge($pool);

\PhpOffice\PhpSpreadsheet\Settings::setCache($simpleCache);

$objReader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader("Xlsx");
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load(dirname(__FILE__).'/Tmpfile'.$i.'.xlsx');

$objPHPExcel->setActiveSheetIndex(0);

foreach ( $objPHPExcel->getActiveSheet()->getRowIterator() as $row ) {
    if ( $row->getRowIndex() == 1 ){
        $row->getCellIterator();
        $cellIterator = $row->getCellIterator();
        $cellIterator->setIterateOnlyExistingCells(false); // Loop all cells, even if it is not set
        $shop_row = array();
        try {
            foreach ($cellIterator as $key => $cell) { // <<<====== WHERE I got the ERROR
                $key = \PhpOffice\PhpSpreadsheet\Cell\Coordinate::columnIndexFromString($key); ....

I haven't any idea to solve this problem.
php version 7.1
phpOffice 1.5.2
5.1.17

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度