PHPOffice / PhpSpreadsheet

    /**

     * Stores the CODEPAGE biff record.

     */

    private function writeCodepage()

    {

        $record = 0x0042; // Record identifier

        $length = 0x0002; // Number of bytes to follow

        $cv = $this->codepage; // The code page

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

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

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

    }

    /**

     * Write Excel BIFF WINDOW1 record.

     * @param int $col Zero indexed column

     * @param mixed $xfIndex The XF format index

     */

    public function writeBlank($row, $col, $xfIndex)

    {

        $record = 0x0201; // Record identifier

        $length = 0x0006; // Number of bytes to follow

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

        $data = pack('vvv', $row, $col, $xfIndex);

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

        return 0;

    }

    /**

     * Write a boolean or an error type to the specified row and column (zero indexed).

     * @param bool $isError Error or Boolean?

     * @param int $xfIndex

     */

    private function writeBoolErr($row, $col, $value, $isError, $xfIndex)

    {

        $record = 0x0205;

        $length = 8;

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

        $data = pack('vvvCC', $row, $col, $xfIndex, $value, $isError);

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

        return 0;

    }

    /**

     * Write a formula to the specified row and column (zero indexed).

    /**

     * Write BIFF record DEFCOLWIDTH if COLINFO records are in use.

     */

    private function writeDefcol()

    {

        $defaultColWidth = 8;

        $record = 0x0055; // Record identifier

        $length = 0x0002; // Number of bytes to follow

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

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

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

    }

    /**

     * Write BIFF record COLINFO to define column widths.

    /**

     * Write the PRINTHEADERS BIFF record.

     */

    private function writePrintHeaders()

    {

        $record = 0x002a; // Record identifier

        $length = 0x0002; // Bytes to follow

        $fPrintRwCol = $this->printHeaders; // Boolean flag

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

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

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

    }

    /**

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