/**
* Convert Excel style column names into numbers.
* @param string $column Excel style column name like AA or CF
* @return integer Number with A being 1 and AA being 27
*/
function alpha2num($column) {
$number = 0;
foreach(str_split($column) as $letter){
$number = ($number * 26) + (ord(strtolower($letter)) - 96);
}
return $number;
}
/**
* Access array value with Excel style column name.
* @param array $array The array to access
* @param string $column Excel style column name like AA or CF
* @return mixed Value found at the column
*/
function alpha_col($array, $column){
$i = alpha2num($column) - 1;
return isset($array[$i]) ? $array[$i] : false;
}
2 years ago
试试这些功能 .