Answers for "laravel excel freeze row"

PHP
0

laravel excel freeze row

I assume you're trying to Freeze columns and rows both.

freezePane will obviously overwrite any previous parameters you might have given to it.

As per your current scenario, I see that you're trying to freeze the top row and the left-most 3 columns

Try this:

$objPHPExcel->getActiveSheet()->freezePane('D2');
This will freeze Row 1 and Columns A,B & C

This should get your work done!

Note: freezePane works exactly how you use it in MS Excel. You select a cell and select Freeze. And it freezes whatever rows are above it, and the columns which are left to it.
Posted by: Guest on March-04-2021

Browse Popular Code Answers by Language