laravel excel freeze row

Solutions on MaxInterview for laravel excel freeze row by the best coders in the world

showing results for - "laravel excel freeze row"
Candice
14 Oct 2016
1I assume you're trying to Freeze columns and rows both.
2
3freezePane will obviously overwrite any previous parameters you might have given to it.
4
5As per your current scenario, I see that you're trying to freeze the top row and the left-most 3 columns
6
7Try this:
8
9$objPHPExcel->getActiveSheet()->freezePane('D2');
10This will freeze Row 1 and Columns A,B & C
11
12This should get your work done!
13
14Note: 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.