0) {$mod = (int)($num % $base );$num = (int)($num / $base);if($mod == 0){...}}" method can be used to convert numbers into letters in excel."/> 0) {$mod = (int)($num % $base );$num = (int)($num / $base);if($mod == 0){...}}" method can be used to convert numbers into letters in excel.">
Home >Backend Development >PHP Problem >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!