当前位置: 首页>>代码示例>>PHP>>正文

PHP PHPExcel_Shared_String::ControlCharacterPHP2OOXML方法代码示例

本文整理汇总了PHP中PHPExcel_Shared_String::ControlCharacterPHP2OOXML方法的典型用法代码示例。如果您正苦于以下问题：PHP PHPExcel_Shared_String::ControlCharacterPHP2OOXML方法的具体用法？PHP PHPExcel_Shared_String::ControlCharacterPHP2OOXML怎么用？PHP PHPExcel_Shared_String::ControlCharacterPHP2OOXML使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类PHPExcel_Shared_String的用法示例。


在下文中一共展示了PHPExcel_Shared_String::ControlCharacterPHP2OOXML方法的6个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: _writeCell

 /**
  * Write Cell
  *
  * @param	PHPExcel_Shared_XMLWriter	$objWriter				XML Writer
  * @param	PHPExcel_Worksheet			$pSheet					Worksheet
  * @param	PHPExcel_Cell				$pCell					Cell
  * @param	string[]					$pStringTable			String table
  * @param	string[]					$pFlippedStringTable	String table (flipped), for faster index searching
  * @throws	Exception
  */
 private function _writeCell(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, PHPExcel_Cell $pCell = null, $pStringTable = null, $pFlippedStringTable = null)
 {
     if (is_array($pStringTable) && is_array($pFlippedStringTable)) {
         // Cell
         $objWriter->startElement('c');
         $objWriter->writeAttribute('r', $pCell->getCoordinate());
         // Sheet styles
         $aStyles = $pSheet->getStyles();
         if (isset($aStyles[$pCell->getCoordinate()])) {
             $styleIndex = $this->getParentWriter()->getStylesHashTable()->getIndexForHashCode($aStyles[$pCell->getCoordinate()]->getHashCode());
             if ($styleIndex != '') {
                 $objWriter->writeAttribute('s', $styleIndex);
             }
         }
         // If cell value is supplied, write cell value
         if (is_object($pCell->getValue()) || $pCell->getValue() !== '') {
             // Map type
             $mappedType = $pCell->getDataType();
             // Write data type depending on its type
             switch (strtolower($mappedType)) {
                 case 'inlinestr':
                     // Inline string
                     $objWriter->writeAttribute('t', $mappedType);
                     break;
                 case 's':
                     // String
                     $objWriter->writeAttribute('t', $mappedType);
                     break;
                 case 'b':
                     // Boolean
                     $objWriter->writeAttribute('t', $mappedType);
                     break;
                 case 'f':
                     // Formula
                     $calculatedValue = null;
                     if ($this->getParentWriter()->getPreCalculateFormulas()) {
                         $calculatedValue = $pCell->getCalculatedValue();
                     } else {
                         $calculatedValue = $pCell->getValue();
                     }
                     if (is_string($calculatedValue)) {
                         $objWriter->writeAttribute('t', 'str');
                     }
                     break;
             }
             // Write data depending on its type
             switch (strtolower($mappedType)) {
                 case 'inlinestr':
                     // Inline string
                     if (!$pCell->getValue() instanceof PHPExcel_RichText) {
                         $objWriter->writeElement('t', PHPExcel_Shared_String::ControlCharacterPHP2OOXML($pCell->getValue()));
                     } else {
                         if ($pCell->getValue() instanceof PHPExcel_RichText) {
                             $objWriter->startElement('is');
                             $this->getParentWriter()->getWriterPart('stringtable')->writeRichText($objWriter, $pCell->getValue());
                             $objWriter->endElement();
                         }
                     }
                     break;
                 case 's':
                     // String
                     if (!$pCell->getValue() instanceof PHPExcel_RichText) {
                         if (isset($pFlippedStringTable[$pCell->getValue()])) {
                             $objWriter->writeElement('v', $pFlippedStringTable[$pCell->getValue()]);
                         }
                     } else {
                         if ($pCell->getValue() instanceof PHPExcel_RichText) {
                             $objWriter->writeElement('v', $pFlippedStringTable[$pCell->getValue()->getHashCode()]);
                         }
                     }
                     break;
                 case 'f':
                     // Formula
                     $objWriter->writeElement('f', substr($pCell->getValue(), 1));
                     if ($this->getParentWriter()->getOffice2003Compatibility() === false) {
                         if ($this->getParentWriter()->getPreCalculateFormulas()) {
                             $calculatedValue = $pCell->getCalculatedValue();
                             if (substr($calculatedValue, 0, 1) != '#') {
                                 $objWriter->writeElement('v', $calculatedValue);
                             } else {
                                 $objWriter->writeElement('v', '0');
                             }
                         } else {
                             $objWriter->writeElement('v', '0');
                         }
                     }
                     break;
                 case 'n':
                     // Numeric
                     if (PHPExcel_Shared_Date::isDateTime($pCell)) {
//.........这里部分代码省略.........
开发者ID:abhinay100，项目名称:fengoffice_app，代码行数:101，代码来源:Worksheet.php

示例2: _writeCell

 /**
  * Write Cell
  *
  * @param	PHPExcel_Shared_XMLWriter	$objWriter				XML Writer
  * @param	PHPExcel_Worksheet			$pSheet					Worksheet
  * @param	PHPExcel_Cell				$pCell					Cell
  * @param	string[]					$pStringTable			String table
  * @param	string[]					$pFlippedStringTable	String table (flipped), for faster index searching
  * @throws	Exception
  */
 private function _writeCell(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Worksheet $pSheet = null, PHPExcel_Cell $pCell = null, $pStringTable = null, $pFlippedStringTable = null)
 {
     if (is_array($pStringTable) && is_array($pFlippedStringTable)) {
         // Cell
         $objWriter->startElement('c');
         $objWriter->writeAttribute('r', $pCell->getCoordinate());
         // Sheet styles
         if ($pCell->getXfIndex() != '') {
             $objWriter->writeAttribute('s', $pCell->getXfIndex());
         }
         // If cell value is supplied, write cell value
         if (is_object($pCell->getValue()) || $pCell->getValue() !== '') {
             // Map type
             $mappedType = $pCell->getDataType();
             // Write data type depending on its type
             switch (strtolower($mappedType)) {
                 case 'inlinestr':
                     // Inline string
                     $objWriter->writeAttribute('t', $mappedType);
                     break;
                 case 's':
                     // String
                     $objWriter->writeAttribute('t', $mappedType);
                     break;
                 case 'b':
                     // Boolean
                     $objWriter->writeAttribute('t', $mappedType);
                     break;
                 case 'f':
                     // Formula
                     $calculatedValue = null;
                     if ($this->getParentWriter()->getPreCalculateFormulas()) {
                         $calculatedValue = $pCell->getCalculatedValue();
                     } else {
                         $calculatedValue = $pCell->getValue();
                     }
                     if (is_string($calculatedValue)) {
                         $objWriter->writeAttribute('t', 'str');
                     }
                     break;
                 case 'e':
                     // Error
                     $objWriter->writeAttribute('t', $mappedType);
             }
             // Write data depending on its type
             switch (strtolower($mappedType)) {
                 case 'inlinestr':
                     // Inline string
                     if (!$pCell->getValue() instanceof PHPExcel_RichText) {
                         $objWriter->writeElement('t', PHPExcel_Shared_String::ControlCharacterPHP2OOXML(htmlspecialchars($pCell->getValue())));
                     } else {
                         if ($pCell->getValue() instanceof PHPExcel_RichText) {
                             $objWriter->startElement('is');
                             $this->getParentWriter()->getWriterPart('stringtable')->writeRichText($objWriter, $pCell->getValue());
                             $objWriter->endElement();
                         }
                     }
                     break;
                 case 's':
                     // String
                     if (!$pCell->getValue() instanceof PHPExcel_RichText) {
                         if (isset($pFlippedStringTable[$pCell->getValue()])) {
                             $objWriter->writeElement('v', $pFlippedStringTable[$pCell->getValue()]);
                         }
                     } else {
                         if ($pCell->getValue() instanceof PHPExcel_RichText) {
                             $objWriter->writeElement('v', $pFlippedStringTable[$pCell->getValue()->getHashCode()]);
                         }
                     }
                     break;
                 case 'f':
                     // Formula
                     $objWriter->writeElement('f', substr($pCell->getValue(), 1));
                     if ($this->getParentWriter()->getOffice2003Compatibility() === false) {
                         if ($this->getParentWriter()->getPreCalculateFormulas()) {
                             $calculatedValue = $pCell->getCalculatedValue();
                             if (!is_array($calculatedValue) && substr($calculatedValue, 0, 1) != '#') {
                                 $v = PHPExcel_Shared_String::FormatNumber($calculatedValue);
                                 $objWriter->writeElement('v', $v);
                             } else {
                                 $objWriter->writeElement('v', '0');
                             }
                         } else {
                             $objWriter->writeElement('v', '0');
                         }
                     }
                     break;
                 case 'n':
                     // Numeric
                     // force point as decimal separator in case current locale uses comma
//.........这里部分代码省略.........
开发者ID:honj51，项目名称:taobaocrm，代码行数:101，代码来源:Worksheet.php

示例3: _writeValAx

 /**
  * Write Value Axis
  *
  * @param 	PHPExcel_Shared_XMLWriter 	$objWriter 		XML Writer
  * @param 	PHPExcel_Chart_PlotArea		$plotArea
  * @param 	PHPExcel_Chart_Title		$yAxisLabel
  * @param 	string						$groupType		Chart type
  * @param 	string						$id1
  * @param 	string						$id2
  * @param 	boolean						$isMultiLevelSeries
  * @throws 	PHPExcel_Writer_Exception
  */
 private function _writeValAx($objWriter, PHPExcel_Chart_PlotArea $plotArea, $yAxisLabel, $groupType, $id1, $id2, $isMultiLevelSeries)
 {
     $objWriter->startElement('c:valAx');
     if ($id2 > 0) {
         $objWriter->startElement('c:axId');
         $objWriter->writeAttribute('val', $id2);
         $objWriter->endElement();
     }
     $objWriter->startElement('c:scaling');
     $objWriter->startElement('c:orientation');
     $objWriter->writeAttribute('val', "minMax");
     $objWriter->endElement();
     $objWriter->endElement();
     $objWriter->startElement('c:delete');
     $objWriter->writeAttribute('val', 0);
     $objWriter->endElement();
     $objWriter->startElement('c:axPos');
     $objWriter->writeAttribute('val', "l");
     $objWriter->endElement();
     $objWriter->startElement('c:majorGridlines');
     $objWriter->endElement();
     if (!is_null($yAxisLabel)) {
         $objWriter->startElement('c:title');
         $objWriter->startElement('c:tx');
         $objWriter->startElement('c:rich');
         $objWriter->startElement('a:bodyPr');
         $objWriter->endElement();
         $objWriter->startElement('a:lstStyle');
         $objWriter->endElement();
         $objWriter->startElement('a:p');
         $objWriter->startElement('a:r');
         $caption = $yAxisLabel->getCaption();
         if (is_array($caption)) {
             $caption = $caption[0];
         }
         $objWriter->startElement('a:t');
         //										$objWriter->writeAttribute('xml:space', 'preserve');
         $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($caption));
         $objWriter->endElement();
         $objWriter->endElement();
         $objWriter->endElement();
         $objWriter->endElement();
         $objWriter->endElement();
         if ($groupType !== PHPExcel_Chart_DataSeries::TYPE_BUBBLECHART) {
             $layout = $yAxisLabel->getLayout();
             $this->_writeLayout($layout, $objWriter);
         }
         $objWriter->startElement('c:overlay');
         $objWriter->writeAttribute('val', 0);
         $objWriter->endElement();
         $objWriter->endElement();
     }
     $objWriter->startElement('c:numFmt');
     $objWriter->writeAttribute('formatCode', "General");
     $objWriter->writeAttribute('sourceLinked', 1);
     $objWriter->endElement();
     $objWriter->startElement('c:majorTickMark');
     $objWriter->writeAttribute('val', "out");
     $objWriter->endElement();
     $objWriter->startElement('c:minorTickMark');
     $objWriter->writeAttribute('val', "none");
     $objWriter->endElement();
     $objWriter->startElement('c:tickLblPos');
     $objWriter->writeAttribute('val', "nextTo");
     $objWriter->endElement();
     if ($id1 > 0) {
         $objWriter->startElement('c:crossAx');
         $objWriter->writeAttribute('val', $id2);
         $objWriter->endElement();
         $objWriter->startElement('c:crosses');
         $objWriter->writeAttribute('val', "autoZero");
         $objWriter->endElement();
         $objWriter->startElement('c:crossBetween');
         $objWriter->writeAttribute('val', "midCat");
         $objWriter->endElement();
     }
     if ($isMultiLevelSeries) {
         if ($groupType !== PHPExcel_Chart_DataSeries::TYPE_BUBBLECHART) {
             $objWriter->startElement('c:noMultiLvlLbl');
             $objWriter->writeAttribute('val', 0);
             $objWriter->endElement();
         }
     }
     $objWriter->endElement();
 }
开发者ID:BGCX262，项目名称:zy-sms-svn-to-git，代码行数:97，代码来源:Chart.php

示例4: writeRichText

 /**
  * Write Rich Text
  *
  * @param 	PHPExcel_Shared_XMLWriter		$objWriter 		XML Writer
  * @param 	PHPExcel_RichText				$pRichText		Rich text
  * @throws 	Exception
  */
 public function writeRichText(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_RichText $pRichText = null)
 {
     // Loop trough rich text elements
     $elements = $pRichText->getRichTextElements();
     foreach ($elements as $element) {
         // r
         $objWriter->startElement('r');
         // rPr
         if ($element instanceof PHPExcel_RichText_Run) {
             // rPr
             $objWriter->startElement('rPr');
             // rFont
             $objWriter->startElement('rFont');
             $objWriter->writeAttribute('val', $element->getFont()->getName());
             $objWriter->endElement();
             // Bold
             $objWriter->startElement('b');
             $objWriter->writeAttribute('val', $element->getFont()->getBold() ? 'true' : 'false');
             $objWriter->endElement();
             // Italic
             $objWriter->startElement('i');
             $objWriter->writeAttribute('val', $element->getFont()->getItalic() ? 'true' : 'false');
             $objWriter->endElement();
             // Striketrough
             $objWriter->startElement('strike');
             $objWriter->writeAttribute('val', $element->getFont()->getStriketrough() ? 'true' : 'false');
             $objWriter->endElement();
             // Color
             $objWriter->startElement('color');
             $objWriter->writeAttribute('rgb', $element->getFont()->getColor()->getARGB());
             $objWriter->endElement();
             // Size
             $objWriter->startElement('sz');
             $objWriter->writeAttribute('val', $element->getFont()->getSize());
             $objWriter->endElement();
             // Underline
             $objWriter->startElement('u');
             $objWriter->writeAttribute('val', $element->getFont()->getUnderline());
             $objWriter->endElement();
             $objWriter->endElement();
         }
         // t
         $objWriter->startElement('t');
         $objWriter->writeAttribute('xml:space', 'preserve');
         $objWriter->writeRaw(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($element->getText()));
         $objWriter->endElement();
         $objWriter->endElement();
     }
 }
开发者ID:teungri，项目名称:RequirementsApp，代码行数:56，代码来源:StringTable.php

示例5: writeRichTextForCharts

 /**
  * Write Rich Text
  *
  * @param     PHPExcel_Shared_XMLWriter    $objWriter         XML Writer
  * @param     string|PHPExcel_RichText    $pRichText        text string or Rich text
  * @param     string                        $prefix            Optional Namespace prefix
  * @throws     PHPExcel_Writer_Exception
  */
 public function writeRichTextForCharts(PHPExcel_Shared_XMLWriter $objWriter = null, $pRichText = null, $prefix = null)
 {
     if (!$pRichText instanceof PHPExcel_RichText) {
         $textRun = $pRichText;
         $pRichText = new PHPExcel_RichText();
         $pRichText->createTextRun($textRun);
     }
     if ($prefix !== null) {
         $prefix .= ':';
     }
     // Loop through rich text elements
     $elements = $pRichText->getRichTextElements();
     foreach ($elements as $element) {
         // r
         $objWriter->startElement($prefix . 'r');
         // rPr
         $objWriter->startElement($prefix . 'rPr');
         // Bold
         $objWriter->writeAttribute('b', $element->getFont()->getBold() ? 1 : 0);
         // Italic
         $objWriter->writeAttribute('i', $element->getFont()->getItalic() ? 1 : 0);
         // Underline
         $underlineType = $element->getFont()->getUnderline();
         switch ($underlineType) {
             case 'single':
                 $underlineType = 'sng';
                 break;
             case 'double':
                 $underlineType = 'dbl';
                 break;
         }
         $objWriter->writeAttribute('u', $underlineType);
         // Strikethrough
         $objWriter->writeAttribute('strike', $element->getFont()->getStrikethrough() ? 'sngStrike' : 'noStrike');
         // rFont
         $objWriter->startElement($prefix . 'latin');
         $objWriter->writeAttribute('typeface', $element->getFont()->getName());
         $objWriter->endElement();
         // Superscript / subscript
         //                    if ($element->getFont()->getSuperScript() || $element->getFont()->getSubScript()) {
         //                        $objWriter->startElement($prefix.'vertAlign');
         //                        if ($element->getFont()->getSuperScript()) {
         //                            $objWriter->writeAttribute('val', 'superscript');
         //                        } elseif ($element->getFont()->getSubScript()) {
         //                            $objWriter->writeAttribute('val', 'subscript');
         //                        }
         //                        $objWriter->endElement();
         //                    }
         //
         $objWriter->endElement();
         // t
         $objWriter->startElement($prefix . 't');
         //                    $objWriter->writeAttribute('xml:space', 'preserve');    //    Excel2010 accepts, Excel2007 complains
         $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($element->getText()));
         $objWriter->endElement();
         $objWriter->endElement();
     }
 }
开发者ID:alyayazilim，项目名称:E-Ticaret-2015，代码行数:66，代码来源:StringTable.php

示例6: writeValueAxis


//.........这里部分代码省略.........
             //end color:type
             $objWriter->endElement();
             //end shadow
         }
         if (!is_null($minorGridlines->getSoftEdgesSize())) {
             $objWriter->startElement('a:softEdge');
             $objWriter->writeAttribute('rad', $minorGridlines->getSoftEdgesSize());
             $objWriter->endElement();
             //end softEdge
         }
         $objWriter->endElement();
         //end effectLst
         $objWriter->endElement();
         //end spPr
         $objWriter->endElement();
         //end minorGridLines
     }
     if (!is_null($yAxisLabel)) {
         $objWriter->startElement('c:title');
         $objWriter->startElement('c:tx');
         $objWriter->startElement('c:rich');
         $objWriter->startElement('a:bodyPr');
         $objWriter->endElement();
         $objWriter->startElement('a:lstStyle');
         $objWriter->endElement();
         $objWriter->startElement('a:p');
         $objWriter->startElement('a:r');
         $caption = $yAxisLabel->getCaption();
         if (is_array($caption)) {
             $caption = $caption[0];
         }
         $objWriter->startElement('a:t');
         //                                        $objWriter->writeAttribute('xml:space', 'preserve');
         $objWriter->writeRawData(PHPExcel_Shared_String::ControlCharacterPHP2OOXML($caption));
         $objWriter->endElement();
         $objWriter->endElement();
         $objWriter->endElement();
         $objWriter->endElement();
         $objWriter->endElement();
         if ($groupType !== PHPExcel_Chart_DataSeries::TYPE_BUBBLECHART) {
             $layout = $yAxisLabel->getLayout();
             $this->writeLayout($layout, $objWriter);
         }
         $objWriter->startElement('c:overlay');
         $objWriter->writeAttribute('val', 0);
         $objWriter->endElement();
         $objWriter->endElement();
     }
     $objWriter->startElement('c:numFmt');
     $objWriter->writeAttribute('formatCode', $xAxis->getAxisNumberFormat());
     $objWriter->writeAttribute('sourceLinked', $xAxis->getAxisNumberSourceLinked());
     $objWriter->endElement();
     $objWriter->startElement('c:majorTickMark');
     $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('major_tick_mark'));
     $objWriter->endElement();
     $objWriter->startElement('c:minorTickMark');
     $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('minor_tick_mark'));
     $objWriter->endElement();
     $objWriter->startElement('c:tickLblPos');
     $objWriter->writeAttribute('val', $xAxis->getAxisOptionsProperty('axis_labels'));
     $objWriter->endElement();
     $objWriter->startElement('c:spPr');
     if (!is_null($xAxis->getFillProperty('value'))) {
         $objWriter->startElement('a:solidFill');
         $objWriter->startElement("a:" . $xAxis->getFillProperty('type'));
         $objWriter->writeAttribute('val', $xAxis->getFillProperty('value'));
开发者ID:satheesanpv，项目名称:IP-Valuation，代码行数:67，代码来源:Chart.php


注：本文中的PHPExcel_Shared_String::ControlCharacterPHP2OOXML方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。