Is there a built-in way to convert a column number to an Excel column with Laravel Excel

Question

I want to add some style on a column using Laravel Excel. I know this column is the (let's say) 42nd, but I don't know the Excel code (like AA, BC, etc.).

I know I can build a function (based on this answer) to convert the column number to a letter, but I not sure it's the right way.

Is there a built-in way to convert a column number to an Excel column with Laravel Excel?

You want to export full table or some columns ? I have used laravel excel but i did't find any such inbuilt function. but I have develop my own function for that. — Raunak Gupta, Oct 06 '16 at 13:24

score 4 · Answer 1 · answered Oct 18 '18 at 19:30

Since version 3.1 of Laravel Excel is based off of the newest PHP Excel which uses the latest PhpSpreadsheet classes, the helper functions to manipulate coordinates have been moved to a new dedicated class. Search for "Dedicated class to manipulate coordinates" on this page.

Therefore, you can do this moving forward:

use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
...
Coordinate::stringFromColumnIndex(1);

Can Vural · Accepted Answer · 2016-10-07T14:20:16.090

1

There is a method in PHPExcel and i guess Laravel Excel uses that library.

You can do like this:

\PHPExcel_Cell::stringFromColumnIndex(1);

This will return, B

edited Oct 07 '16 at 14:20

answered Oct 07 '16 at 14:16

Can Vural

1,956
1
24
39

Thanks! BTW, It will return 'B' (doc says: "Column index (base 0 !!!)") – rap-2-h Oct 07 '16 at 14:19

Is there a built-in way to convert a column number to an Excel column with Laravel Excel

2 Answers2