PHPExcel freeze (LOCK) the simple implementation method of the header, phpexcel freeze

PHPExcel freeze (LOCK) the simple implementation method of the header, phpexcel freeze

This document describes how to freeze (LOCK) headers in PHPExcel. We will share this with you for your reference. The details are as follows:

PHPExcel is a powerful PHP plug-in for Microsoft excel operations. When exporting data, you sometimes need to lock the header, that is, when you scroll to view data, the header always appears in the field of view, but does not disappear.

The call method is as follows:

$ ObjPHPExcel = new PHPExcel (); $ objPHPExcel-> setActiveSheetIndex (0); $ objPHPExcel-> getActiveSheet ()-> freezePane ('a2 ');

The code above is the first line of the frozen table. You may be confused about this method. Why is this the first line frozen? The following figure explains the principle.

The picture is ugly. You can understand it.