Lock Excel Cell

Topics: Developer Forum
Jun 13, 2012 at 7:15 PM

I want a excel which will be generated dynamically. Suppose I am inserting first name , last name , occupation, age, sex etc in a table. Now I am creating an excel report by these data. 

My question is : 

Can I make the first row and first column fixed for every scrolling down or scrolling side ?

Below are the format in excel :

Serial Number First name     Last name   Age   Sex

1. ABC  KKK 20 M

2. BCD mmm 40 F

3. DEF RRR 36 M

Now i want to fix the cell Serial Number,First Name, Last Name,Age,Sex

as well as fix the left hand side numbers for every scrolling in that sheet. May be from upper to lower , or right to left or vice versa.

Please help me how to do this in PHP. 

Thanks

Coordinator
Jun 13, 2012 at 8:13 PM

It's called Freezing panes:

$objPHPExcel->getActiveSheet()->freezePane('A2');