The example in this article describes the solution for PHP to generate Excel column names that exceed 26 columns greater than Z. Share to everyone for your reference. The specific analysis is as follows:
We generate Excel using the Phpexcel class, here to give you a solution to generate Excel column name more than 26 columns greater than Z, this is the method in the Phpexcel class, today, to record the memo, the code is as follows:
Copy Code code 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];
}
Converts a column's numeric ordinal to a letter using the following code:
Copy Code code as follows:
Phpexcel_cell::stringfromcolumnindex ($i); Starting from O
Convert the letter of the column to a numeric ordinal, as follows:
Copy Code code as follows:
Phpexcel_cell::columnindexfromstring (' AA ');
I hope this article will help you with your PHP program design.