@@ 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); |