PHP generates Excel column names in more than 26 columns when the resolution is greater than Z, excel26 column
This article describes a workaround for PHP to generate Excel column names greater than 26 columns. Share to everyone for your reference. The specific analysis is as follows:
We generate Excel will use the Phpexcel class, here to introduce you to generate Excel column name more than 26 columns greater than Z solution, this is the method in the Phpexcel class, found today, record the memo, the code is as follows:
Copy CodeThe 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 (+ $pColumnIndex);
} elseif ($pColumnIndex < 702) {
$_indexcache[$pColumnIndex] = Chr (+ ($pColumnIndex/26)). Chr (+ $pColumnIndex% 26);
} else {
$_indexcache[$pColumnIndex] = Chr (+ ($pColumnIndex-26)/676). Chr ((($pColumnIndex-26)% 676)/26). Chr (+ $pColumnIndex% 26);
}
}
return $_indexcache[$pColumnIndex];
}
To convert a column's numeric number to a letter, use the following code:
Copy CodeThe code is as follows: Phpexcel_cell::stringfromcolumnindex ($i); Start from O
To convert the letters of a column to a numeric sequence number, use the following code:
Copy the Code code as follows: Phpexcel_cell::columnindexfromstring (' AA ');
I hope this article is helpful to everyone's PHP programming.
http://www.bkjia.com/PHPjc/934932.html www.bkjia.com true http://www.bkjia.com/PHPjc/934932.html techarticle The workaround for PHP to generate Excel column names more than 26 columns is greater than Z, excel26 column This article describes a workaround for PHP to generate Excel column names larger than 26 columns. Share to everyone for your reference. ...