/** * Return cell value * @param string $coordinate * @return string|null */ protected function getCellValueByCoordinate($coordinate) { if ($this->sheet) { if (str_contains($coordinate, ':')) { // We want to get a range of cells $values = $this->sheet->rangeToArray($coordinate); return $values; } else { // We want 1 specific cell return $this->sheet->getCell($coordinate)->getValue(); } } return null; }