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
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.