currentCellIsDirty && !empty($this->currentObjectID)) { $this->currentObject->detach(); fseek($this->fileHandle, 0, SEEK_END); $this->cellCache[$this->currentObjectID] = [ 'ptr' => ftell($this->fileHandle), 'sz' => fwrite($this->fileHandle, serialize($this->currentObject)), ]; $this->currentCellIsDirty = false; } $this->currentObjectID = $this->currentObject = null; } /** * Add or Update a cell in cache identified by coordinate address. * * @param string $pCoord Coordinate address of the cell to update * @param \PhpOffice\PhpSpreadsheet\Cell $cell Cell to update * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return \PhpOffice\PhpSpreadsheet\Cell */ public function addCacheData($pCoord, \PhpOffice\PhpSpreadsheet\Cell $cell) { if (($pCoord !== $this->currentObjectID) && ($this->currentObjectID !== null)) { $this->storeData(); } $this->currentObjectID = $pCoord; $this->currentObject = $cell; $this->currentCellIsDirty = true; return $cell; } /** * Get cell at a specific coordinate. * * @param string $pCoord Coordinate of the cell * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return \PhpOffice\PhpSpreadsheet\Cell Cell that was found, or null if not found */ public function getCacheData($pCoord) { if ($pCoord === $this->currentObjectID) { return $this->currentObject; } $this->storeData(); // Check if the entry that has been requested actually exists if (!isset($this->cellCache[$pCoord])) { // Return null if requested entry doesn't exist in cache return null; } // Set current entry to the requested entry $this->currentObjectID = $pCoord; fseek($this->fileHandle, $this->cellCache[$pCoord]['ptr']); $this->currentObject = unserialize(fread($this->fileHandle, $this->cellCache[$pCoord]['sz'])); // Re-attach this as the cell's parent $this->currentObject->attach($this); // Return requested entry return $this->currentObject; } /** * Get a list of all cell addresses currently held in cache. * * @return string[] */ public function getCellList() { if ($this->currentObjectID !== null) { $this->storeData(); } return parent::getCellList(); } /** * Clone the cell collection. * * @param \PhpOffice\PhpSpreadsheet\Worksheet $parent The new worksheet that we're copying to */ public function copyCellCollection(\PhpOffice\PhpSpreadsheet\Worksheet $parent) { parent::copyCellCollection($parent); // Open a new stream for the cell cache data $newFileHandle = fopen('php://temp/maxmemory:' . $this->memoryCacheSize, 'a+'); // Copy the existing cell cache data to the new stream fseek($this->fileHandle, 0); while (!feof($this->fileHandle)) { fwrite($newFileHandle, fread($this->fileHandle, 1024)); } $this->fileHandle = $newFileHandle; } /** * Clear the cell collection and disconnect from our parent. */ public function unsetWorksheetCells() { if (!is_null($this->currentObject)) { $this->currentObject->detach(); $this->currentObject = $this->currentObjectID = null; } $this->cellCache = []; // detach ourself from the worksheet, so that it can then delete this object successfully $this->parent = null; // Close down the php://temp file $this->__destruct(); } /** * Initialise this new cell collection. * * @param \PhpOffice\PhpSpreadsheet\Worksheet $parent The worksheet for this cell collection * @param mixed[] $arguments Additional initialisation arguments */ public function __construct(\PhpOffice\PhpSpreadsheet\Worksheet $parent, $arguments) { $this->memoryCacheSize = (isset($arguments['memoryCacheSize'])) ? $arguments['memoryCacheSize'] : 1 * 1024 * 1024; parent::__construct($parent); if (is_null($this->fileHandle)) { $this->fileHandle = fopen('php://temp/maxmemory:' . $this->memoryCacheSize, 'a+'); } } /** * Destroy this cell collection. */ public function __destruct() { if (!is_null($this->fileHandle)) { fclose($this->fileHandle); } $this->fileHandle = null; } }