PHPOffice / PhpSpreadsheet

    /**

     * Store the horizontal centering HCENTER BIFF record.

     */

    private function writeHcenter()

    {

        $record = 0x0083; // Record identifier

        $length = 0x0002; // Bytes to follow

        $fHCenter = $this->phpSheet->getPageSetup()->getHorizontalCentered() ? 1 : 0; // Horizontal centering

        $header = pack('vv', $record, $length);

        $data = pack('v', $fHCenter);

        $this->append($header . $data);

    }

    /**

     * Store the vertical centering VCENTER BIFF record.

    /**

     * Store the vertical centering VCENTER BIFF record.

     */

    private function writeVcenter()

    {

        $record = 0x0084; // Record identifier

        $length = 0x0002; // Bytes to follow

        $fVCenter = $this->phpSheet->getPageSetup()->getVerticalCentered() ? 1 : 0; // Horizontal centering

        $header = pack('vv', $record, $length);

        $data = pack('v', $fVCenter);

        $this->append($header . $data);

    }

    /**

     * Store the LEFTMARGIN BIFF record.

     * Write the PRINTGRIDLINES BIFF record. Must be used in conjunction with the

     * GRIDSET record.

     */

    private function writePrintGridlines()

    {

        $record = 0x002b; // Record identifier

        $length = 0x0002; // Bytes to follow

        $fPrintGrid = $this->phpSheet->getPrintGridlines() ? 1 : 0; // Boolean flag

        $header = pack('vv', $record, $length);

        $data = pack('v', $fPrintGrid);

        $this->append($header . $data);

    }

    /**

     * Write the GRIDSET BIFF record. Must be used in conjunction with the

    /**

     * Set the Biff PROTECT record to indicate that the worksheet is protected.

     */

    private function writeProtect()

    {

        // Exit unless sheet protection has been specified

        if (!$this->phpSheet->getProtection()->getSheet()) {

            return;

        }

        $record = 0x0012; // Record identifier

        $length = 0x0002; // Bytes to follow

        $fLock = 1; // Worksheet is protected

        $header = pack('vv', $record, $length);

        $data = pack('v', $fLock);

        $this->append($header . $data);

    }

    /**

     * Write SCENPROTECT