A
A
Andrey2015-12-22 11:28:52
PHP
Andrey, 2015-12-22 11:28:52

Freeze row and columns in phpexcel - how?

The file is formed, figured out the styles, tell me where to dig in the direction of fixing columns and rows.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Ukolov, 2015-12-22
@andreyk0

Dig towards the official documentation, it's there.
No, I'm lying, this is not in the docks, only in the examples .
$objPHPExcel->getActiveSheet()->freezePane('A2');
Please note that the function argument is the address of the cell, above and to the left of which the regions will be fixed. That is, A2 will pin the first row and B1 the first column.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question