/**
* 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;
}
