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