PHPOffice / PhpSpreadsheet

     *

     * @param string $stringValue

     */

    private function writeStringRecord($stringValue)

    {

        $record = 0x0207; // Record identifier

        $data = \PhpOffice\PhpSpreadsheet\Shared\StringHelper::UTF8toBIFF8UnicodeLong($stringValue);

        $length = strlen($data);

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

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

    }

    /**

     * Write a hyperlink.

    /**

     * Store the header caption BIFF record.

     */

    private function writeHeader()

    {

        $record = 0x0014; // Record identifier

        /* removing for now

        // need to fix character count (multibyte!)

        if (strlen($this->phpSheet->getHeaderFooter()->getOddHeader()) <= 255) {

            $str      = $this->phpSheet->getHeaderFooter()->getOddHeader();       // header string

        } else {

            $str = '';

        }

        */

        $recordData = \PhpOffice\PhpSpreadsheet\Shared\StringHelper::UTF8toBIFF8UnicodeLong($this->phpSheet->getHeaderFooter()->getOddHeader());

        $length = strlen($recordData);

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

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

    }

    /**

     * Store the footer caption BIFF record.

    /**

     * Store the footer caption BIFF record.

     */

    private function writeFooter()

    {

        $record = 0x0015; // Record identifier

        /* removing for now

        // need to fix character count (multibyte!)

        if (strlen($this->phpSheet->getHeaderFooter()->getOddFooter()) <= 255) {

            $str = $this->phpSheet->getHeaderFooter()->getOddFooter();

        } else {

            $str = '';

        }

        */

        $recordData = \PhpOffice\PhpSpreadsheet\Shared\StringHelper::UTF8toBIFF8UnicodeLong($this->phpSheet->getHeaderFooter()->getOddFooter());

        $length = strlen($recordData);

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

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

    }

    /**

     * Store the horizontal centering HCENTER BIFF record.