Php generates an excel column name with over 26 columns greater than Z. Solution

All the generated excel files use the phpExcel class. next I will introduce the solution to the problem that the generated excel column name contains more than 26 columns and is greater than Z. This is the method in the phpExcel class. I found it today, record the memo. the code is as follows: publ... all the generated excel files use the phpExcel class. next I will introduce the solution to the problem that the generated excel column name contains more than 26 columns and is greater than Z. This is the method in the phpExcel class. I found it today, record the memo. the code is as follows:

Public static function stringFromColumnIndex ($ pColumnIndex = 0) {// Using a lookup cache adds a slight memory overhead, but boosts speed // caching using a static within the method is faster than a class static, // though it's additional memory overhead static $ _ indexCache = array (); if (! Isset ($ _ indexCache [$ pColumnIndex]) {// Determine column string if ($ pColumnIndex <26) {$ _ indexCache [$ pColumnIndex] = chr (65 + $ pColumnIndex);} elseif ($ pColumnIndex <702) {$ _ indexCache [$ pColumnIndex] = chr (64 + ($ pColumnIndex/26 )). chr (65 + $ pColumnIndex % 26);} else {// open source code phprm.com $ _ indexCache [$ pColumnIndex] = chr (64 + ($ pColumnIndex-26) /676 )). chr (65 + ($ pColumnIndex-26) % 676)/26 )). chr (65 + $ pColumnIndex % 26) ;}return $ _ indexCache [$ pColumnIndex];}

Use the following code to convert the number of a column to a letter:

PHPExcel_Cell: stringFromColumnIndex ($ I); // starts from 0

Use the following code to convert a column's letters into numbers:

PHPExcel_Cell: columnIndexFromString ('A ');

Article address:

Reprint at will ^ please include the address of this article!