|
@@ 120-137 (lines=18) @@
|
| 117 |
|
$columnKey = preg_replace('/[^a-z]/i','',$columnKey); |
| 118 |
|
return (integer) PHPExcel_Cell::columnIndexFromString($columnKey); |
| 119 |
|
} |
| 120 |
|
} else { |
| 121 |
|
if (strpos($cellAddress,'!') !== false) { |
| 122 |
|
list($sheet,$cellAddress) = explode('!',$cellAddress); |
| 123 |
|
} |
| 124 |
|
if (strpos($cellAddress,':') !== false) { |
| 125 |
|
list($startAddress,$endAddress) = explode(':',$cellAddress); |
| 126 |
|
$startAddress = preg_replace('/[^a-z]/i','',$startAddress); |
| 127 |
|
$endAddress = preg_replace('/[^a-z]/i','',$endAddress); |
| 128 |
|
$returnValue = array(); |
| 129 |
|
do { |
| 130 |
|
$returnValue[] = (integer) PHPExcel_Cell::columnIndexFromString($startAddress); |
| 131 |
|
} while ($startAddress++ != $endAddress); |
| 132 |
|
return $returnValue; |
| 133 |
|
} else { |
| 134 |
|
$cellAddress = preg_replace('/[^a-z]/i','',$cellAddress); |
| 135 |
|
return (integer) PHPExcel_Cell::columnIndexFromString($cellAddress); |
| 136 |
|
} |
| 137 |
|
} |
| 138 |
|
} // function COLUMN() |
| 139 |
|
|
| 140 |
|
|
|
@@ 195-212 (lines=18) @@
|
| 192 |
|
return (integer) preg_replace('/[^0-9]/i','',$rowKey); |
| 193 |
|
} |
| 194 |
|
} |
| 195 |
|
} else { |
| 196 |
|
if (strpos($cellAddress,'!') !== false) { |
| 197 |
|
list($sheet,$cellAddress) = explode('!',$cellAddress); |
| 198 |
|
} |
| 199 |
|
if (strpos($cellAddress,':') !== false) { |
| 200 |
|
list($startAddress,$endAddress) = explode(':',$cellAddress); |
| 201 |
|
$startAddress = preg_replace('/[^0-9]/','',$startAddress); |
| 202 |
|
$endAddress = preg_replace('/[^0-9]/','',$endAddress); |
| 203 |
|
$returnValue = array(); |
| 204 |
|
do { |
| 205 |
|
$returnValue[][] = (integer) $startAddress; |
| 206 |
|
} while ($startAddress++ != $endAddress); |
| 207 |
|
return $returnValue; |
| 208 |
|
} else { |
| 209 |
|
list($cellAddress) = explode(':',$cellAddress); |
| 210 |
|
return (integer) preg_replace('/[^0-9]/','',$cellAddress); |
| 211 |
|
} |
| 212 |
|
} |
| 213 |
|
} // function ROW() |
| 214 |
|
|
| 215 |
|
|