|
@@ 3634-3638 (lines=5) @@
|
| 3631 |
|
if (!isset($aReferences[1])) { |
| 3632 |
|
// Single cell in range |
| 3633 |
|
list($currentCol,$currentRow) = sscanf($aReferences[0],'%[A-Z]%d'); |
| 3634 |
|
if ($pSheet->cellExists($aReferences[0])) { |
| 3635 |
|
$returnValue[$currentRow][$currentCol] = $pSheet->getCell($aReferences[0])->getCalculatedValue($resetLog); |
| 3636 |
|
} else { |
| 3637 |
|
$returnValue[$currentRow][$currentCol] = null; |
| 3638 |
|
} |
| 3639 |
|
} else { |
| 3640 |
|
// Extract cell data for all cells in the range |
| 3641 |
|
foreach ($aReferences as $reference) { |
|
@@ 3645-3649 (lines=5) @@
|
| 3642 |
|
// Extract range |
| 3643 |
|
list($currentCol,$currentRow) = sscanf($reference,'%[A-Z]%d'); |
| 3644 |
|
|
| 3645 |
|
if ($pSheet->cellExists($reference)) { |
| 3646 |
|
$returnValue[$currentRow][$currentCol] = $pSheet->getCell($reference)->getCalculatedValue($resetLog); |
| 3647 |
|
} else { |
| 3648 |
|
$returnValue[$currentRow][$currentCol] = null; |
| 3649 |
|
} |
| 3650 |
|
} |
| 3651 |
|
} |
| 3652 |
|
} |
|
@@ 3716-3720 (lines=5) @@
|
| 3713 |
|
if (!isset($aReferences[1])) { |
| 3714 |
|
// Single cell (or single column or row) in range |
| 3715 |
|
list($currentCol,$currentRow) = PHPExcel_Cell::coordinateFromString($aReferences[0]); |
| 3716 |
|
if ($pSheet->cellExists($aReferences[0])) { |
| 3717 |
|
$returnValue[$currentRow][$currentCol] = $pSheet->getCell($aReferences[0])->getCalculatedValue($resetLog); |
| 3718 |
|
} else { |
| 3719 |
|
$returnValue[$currentRow][$currentCol] = null; |
| 3720 |
|
} |
| 3721 |
|
} else { |
| 3722 |
|
// Extract cell data for all cells in the range |
| 3723 |
|
foreach ($aReferences as $reference) { |
|
@@ 3727-3731 (lines=5) @@
|
| 3724 |
|
// Extract range |
| 3725 |
|
list($currentCol,$currentRow) = PHPExcel_Cell::coordinateFromString($reference); |
| 3726 |
|
// echo 'NAMED RANGE: $currentCol='.$currentCol.' $currentRow='.$currentRow.'<br />'; |
| 3727 |
|
if ($pSheet->cellExists($reference)) { |
| 3728 |
|
$returnValue[$currentRow][$currentCol] = $pSheet->getCell($reference)->getCalculatedValue($resetLog); |
| 3729 |
|
} else { |
| 3730 |
|
$returnValue[$currentRow][$currentCol] = null; |
| 3731 |
|
} |
| 3732 |
|
} |
| 3733 |
|
} |
| 3734 |
|
// print_r($returnValue); |