PHP generates Excel column names, more than 26 columns greater than Z Problem resolution

This is the method in the Phpexcel class. I got it today, keep a record of the memo.

The code is as follows

Copy Code

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]; }

Converts a column's numeric ordinal to an alphabetic use:

The code is as follows	Copy Code
Phpexcel_cell::stringfromcolumnindex ($i); Starting from O

Converts the letter of a column to a numeric ordinal using:

The code is as follows	Copy Code
Phpexcel_cell::columnindexfromstring (' AA ');