How to convert numerical values ​​to letters in php

php method to convert numerical values ​​to letters: 1. Create a php sample file; 2. Define a numToExcelLetter method; 3. Pass "while ($num > 0) {$mod = (int )($num % $base);$num = (int)($num / $base);if($mod == 0){...}}" can be used to convert numbers into letters in excel.

The operating environment of this tutorial: Windows 10 system, PHP version 8.1, DELL G3 computer

How does php convert numerical values ​​to letters?

PHP converts numbers into Excel letters

1. Preface

This is based on the writing method of a certain elder brother (eldest sister), mainly to eliminate recursion.

2. Specific code

//根据数字转换成excel的字母
function numToExcelLetter($num)
{
    //由于大写字母只有26个，所以基数为26
    $base = 26;
    $result = '';
    while ($num > 0 ) {
        $mod = (int)($num % $base);
        $num = (int)($num / $base);
        if($mod == 0){
            $num -= 1;
            $temp = numToLetter($base) . $result;
        } elseif ($num == 0) {
            $temp = numToLetter($mod) . $result;
        } else {
            $temp = numToLetter($mod) . $result;
        }
        $result = $temp;
    }
    return $result;
}
function numToLetter($num)
{
    if ($num == 0) {
        return '';
    }
    $num = (int)$num - 1;
    //获取A的ascii码
    $ordA = ord('A');
    return chr($ordA + $num);
}

Related introduction:

int is the set ℤ = {..., -2, -1, 0, 1, 2, .. .} A number in .

Floating point number arbitrary precision/BCMath arbitrary length integer/GMP

Syntax:

Integer value Int can be expressed in decimal, hexadecimal, octal or binary, as shown in front Optional symbols (- or ) can be added. You can use the negative operator to represent a negative int.

To use octal expression, 0 (zero) must be added before the number. Starting from PHP 8.1.0, octal expressions can also be preceded by 0o or 0O . To use hexadecimal representation, the number must be preceded by 0x. To use binary representation, the number must be preceded by 0b.

Starting from PHP 7.4.0, integer values ​​may contain underscores (_). For a better reading experience, these underscores will be filtered out by PHP when displayed.

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to convert numerical values ​​to letters in php. For more information, please follow other related articles on the PHP Chinese website!