PHPOffice /
PhpSpreadsheet
| @@ 1217-1231 (lines=15) @@ | ||
| 1214 | * @param mixed $arg,... Data values |
|
| 1215 | * @return int |
|
| 1216 | */ |
|
| 1217 | public static function COUNTA() |
|
| 1218 | { |
|
| 1219 | $returnValue = 0; |
|
| 1220 | ||
| 1221 | // Loop through arguments |
|
| 1222 | $aArgs = Functions::flattenArray(func_get_args()); |
|
| 1223 | foreach ($aArgs as $arg) { |
|
| 1224 | // Is it a numeric, boolean or string value? |
|
| 1225 | if ((is_numeric($arg)) || (is_bool($arg)) || ((is_string($arg) && ($arg != '')))) { |
|
| 1226 | ++$returnValue; |
|
| 1227 | } |
|
| 1228 | } |
|
| 1229 | ||
| 1230 | return $returnValue; |
|
| 1231 | } |
|
| 1232 | ||
| 1233 | ||
| 1234 | /** |
|
| @@ 1247-1261 (lines=15) @@ | ||
| 1244 | * @param mixed $arg,... Data values |
|
| 1245 | * @return int |
|
| 1246 | */ |
|
| 1247 | public static function COUNTBLANK() |
|
| 1248 | { |
|
| 1249 | $returnValue = 0; |
|
| 1250 | ||
| 1251 | // Loop through arguments |
|
| 1252 | $aArgs = Functions::flattenArray(func_get_args()); |
|
| 1253 | foreach ($aArgs as $arg) { |
|
| 1254 | // Is it a blank cell? |
|
| 1255 | if ((is_null($arg)) || ((is_string($arg)) && ($arg == ''))) { |
|
| 1256 | ++$returnValue; |
|
| 1257 | } |
|
| 1258 | } |
|
| 1259 | ||
| 1260 | return $returnValue; |
|
| 1261 | } |
|
| 1262 | ||
| 1263 | ||
| 1264 | /** |
|
