/** * @param $text * * @return string */ public function getData($text) { $charCount = StringUtils::countCharacters($text); $text = StringUtils::toBiff8UnicodeLongWoLenInfo($text); $grbit = 0x212; $rotation = 0; $data = pack('vv', $grbit, $rotation); $data .= pack('vvv', 0, 0, 0); //reserved $txoRunsLength = 0x10; $data .= pack('vv', $charCount, $txoRunsLength); $data .= pack('V', 0); //reserved $result = $this->getFullRecord($data); $continue = new ContinueRecord(); $result .= $continue->getDataRaw($text); $txoRunsData = pack('H*', '00000500'); $txoRunsData .= pack('H*', '2F00'); $txoRunsData .= pack('H*', '0C00'); $lastRun = pack('v', $charCount); $lastRun .= pack('H*', '000000000200'); $txoRunsData .= $lastRun; $result .= $continue->getDataRaw($txoRunsData); return $result; }
/** * @param $type * @param $sheetIndex * @param $formulaData * * @return string */ public function getData($type, $sheetIndex, $formulaData) { $options = 0x20; // Option flags $name = pack("C", $type); $nameLen = StringUtils::countCharacters($name); $name = StringUtils::toBiff8UnicodeLongWoLenInfo($name); $formulaLen = strlen($formulaData); $data = pack("vC", $options, 0); $data .= pack("Cv", $nameLen, $formulaLen); $data .= pack("vv", 0, $sheetIndex); $data .= pack("CCCC", 0, 0, 0, 0); $data .= $name . $formulaData; return $this->getFullRecord($data); }