|
@@ 4060-4064 (lines=5) @@
|
| 4057 |
|
// Single cell in range |
| 4058 |
|
sscanf($aReferences[0], '%[A-Z]%d', $currentCol, $currentRow); |
| 4059 |
|
$cellValue = null; |
| 4060 |
|
if ($pSheet->cellExists($aReferences[0])) { |
| 4061 |
|
$returnValue[$currentRow][$currentCol] = $pSheet->getCell($aReferences[0])->getCalculatedValue($resetLog); |
| 4062 |
|
} else { |
| 4063 |
|
$returnValue[$currentRow][$currentCol] = null; |
| 4064 |
|
} |
| 4065 |
|
} else { |
| 4066 |
|
// Extract cell data for all cells in the range |
| 4067 |
|
foreach ($aReferences as $reference) { |
|
@@ 4071-4075 (lines=5) @@
|
| 4068 |
|
// Extract range |
| 4069 |
|
sscanf($reference, '%[A-Z]%d', $currentCol, $currentRow); |
| 4070 |
|
$cellValue = null; |
| 4071 |
|
if ($pSheet->cellExists($reference)) { |
| 4072 |
|
$returnValue[$currentRow][$currentCol] = $pSheet->getCell($reference)->getCalculatedValue($resetLog); |
| 4073 |
|
} else { |
| 4074 |
|
$returnValue[$currentRow][$currentCol] = null; |
| 4075 |
|
} |
| 4076 |
|
} |
| 4077 |
|
} |
| 4078 |
|
} |
|
@@ 4126-4130 (lines=5) @@
|
| 4123 |
|
// Single cell (or single column or row) in range |
| 4124 |
|
list($currentCol, $currentRow) = Cell::coordinateFromString($aReferences[0]); |
| 4125 |
|
$cellValue = null; |
| 4126 |
|
if ($pSheet->cellExists($aReferences[0])) { |
| 4127 |
|
$returnValue[$currentRow][$currentCol] = $pSheet->getCell($aReferences[0])->getCalculatedValue($resetLog); |
| 4128 |
|
} else { |
| 4129 |
|
$returnValue[$currentRow][$currentCol] = null; |
| 4130 |
|
} |
| 4131 |
|
} else { |
| 4132 |
|
// Extract cell data for all cells in the range |
| 4133 |
|
foreach ($aReferences as $reference) { |
|
@@ 4137-4141 (lines=5) @@
|
| 4134 |
|
// Extract range |
| 4135 |
|
list($currentCol, $currentRow) = Cell::coordinateFromString($reference); |
| 4136 |
|
$cellValue = null; |
| 4137 |
|
if ($pSheet->cellExists($reference)) { |
| 4138 |
|
$returnValue[$currentRow][$currentCol] = $pSheet->getCell($reference)->getCalculatedValue($resetLog); |
| 4139 |
|
} else { |
| 4140 |
|
$returnValue[$currentRow][$currentCol] = null; |
| 4141 |
|
} |
| 4142 |
|
} |
| 4143 |
|
} |
| 4144 |
|
} |
PHPOffice /
PhpSpreadsheet
