php generates column numbers in excel
Release： 2016-07-25 08:55:22
Original
1732 people have browsed it
-
-
/** - * Use php code to generate serial numbers in excel or csv files
- */
- public function loop(){
- $loop = 0;
- $charnum = 65;
for(; $loop < 150; $loop++){ - $quotient = intval($loop / 26);
- $remainder = $loop % 26;
$f = $quotient>0? chr($charnum+$quotient-1) : ''; - $s = $remainder>=0? chr($charnum+$remainder) : '';
- echo $loop .' | '. $quotient .' | '. $remainder .' | '. $f . $s ."
";
- } // bbs.it-home.org
- }
-
|
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
