Shulou(Shulou.com)06/02 Report--

Editor to share with you how to export PHPSpreadsheet Excel more than 26 columns, I hope you have something to gain after reading this article, let's discuss it together!

Excel row and column representation

The rules for the representation of xexcel's columns range from Ameme BJ C to Z, which is represented by two letters when there are more than 26 letters: AA,AB,AC. AZ,BA,BB,BC... BZ... When it exceeds 702, it is another representation

The expression of "OK" is 1, 2, 3, 4, 5, 6, 7. . It goes on like this. In phpexcel, it is OK to set the value of a cell through the setCellValue method, in which the first parameter represents the value of the splicing of columns and rows, such as: A1 Magi B1 Magi A1.

Once you know this, all you have to do is calculate the column representation letters based on the integer part and the module part of $iMaple 26.

Here is the solution

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.