ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
Public Member Functions | Private Member Functions
PHPExcel_Writer_Excel2007_Style Class Reference
+ Inheritance diagram for PHPExcel_Writer_Excel2007_Style:
+ Collaboration diagram for PHPExcel_Writer_Excel2007_Style:

Public Member Functions

 writeStyles (PHPExcel $pPHPExcel=null)
 Write styles to XML format. More...
 
 allStyles (PHPExcel $pPHPExcel=null)
 Get an array of all styles. More...
 
 allConditionalStyles (PHPExcel $pPHPExcel=null)
 Get an array of all conditional styles. More...
 
 allFills (PHPExcel $pPHPExcel=null)
 Get an array of all fills. More...
 
 allFonts (PHPExcel $pPHPExcel=null)
 Get an array of all fonts. More...
 
 allBorders (PHPExcel $pPHPExcel=null)
 Get an array of all borders. More...
 
 allNumberFormats (PHPExcel $pPHPExcel=null)
 Get an array of all number formats. More...
 
- Public Member Functions inherited from PHPExcel_Writer_Excel2007_WriterPart
 setParentWriter (PHPExcel_Writer_IWriter $pWriter=null)
 Set parent IWriter object. More...
 
 getParentWriter ()
 Get parent IWriter object. More...
 
 __construct (PHPExcel_Writer_IWriter $pWriter=null)
 Set parent IWriter object. More...
 

Private Member Functions

 _writeFill (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Fill $pFill=null)
 Write Fill. More...
 
 _writeGradientFill (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Fill $pFill=null)
 Write Gradient Fill. More...
 
 _writePatternFill (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Fill $pFill=null)
 Write Pattern Fill. More...
 
 _writeFont (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Font $pFont=null)
 Write Font. More...
 
 _writeBorder (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Borders $pBorders=null)
 Write Border. More...
 
 _writeCellStyleXf (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style $pStyle=null, PHPExcel $pPHPExcel=null)
 Write Cell Style Xf. More...
 
 _writeCellStyleDxf (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style $pStyle=null)
 Write Cell Style Dxf. More...
 
 _writeBorderPr (PHPExcel_Shared_XMLWriter $objWriter=null, $pName='left', PHPExcel_Style_Border $pBorder=null)
 Write BorderPr. More...
 
 _writeNumFmt (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_NumberFormat $pNumberFormat=null, $pId=0)
 Write NumberFormat. More...
 

Detailed Description

Definition at line 36 of file Style.php.

Member Function Documentation

◆ _writeBorder()

PHPExcel_Writer_Excel2007_Style::_writeBorder ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Style_Borders  $pBorders = null 
)
private

Write Border.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Style_Borders$pBordersBorders style
Exceptions
PHPExcel_Writer_Exception

Definition at line 357 of file Style.php.

358 {
359 // Write border
360 $objWriter->startElement('border');
361 // Diagonal?
362 switch ($pBorders->getDiagonalDirection()) {
363 case PHPExcel_Style_Borders::DIAGONAL_UP:
364 $objWriter->writeAttribute('diagonalUp', 'true');
365 $objWriter->writeAttribute('diagonalDown', 'false');
366 break;
367 case PHPExcel_Style_Borders::DIAGONAL_DOWN:
368 $objWriter->writeAttribute('diagonalUp', 'false');
369 $objWriter->writeAttribute('diagonalDown', 'true');
370 break;
371 case PHPExcel_Style_Borders::DIAGONAL_BOTH:
372 $objWriter->writeAttribute('diagonalUp', 'true');
373 $objWriter->writeAttribute('diagonalDown', 'true');
374 break;
375 }
376
377 // BorderPr
378 $this->_writeBorderPr($objWriter, 'left', $pBorders->getLeft());
379 $this->_writeBorderPr($objWriter, 'right', $pBorders->getRight());
380 $this->_writeBorderPr($objWriter, 'top', $pBorders->getTop());
381 $this->_writeBorderPr($objWriter, 'bottom', $pBorders->getBottom());
382 $this->_writeBorderPr($objWriter, 'diagonal', $pBorders->getDiagonal());
383 $objWriter->endElement();
384 }
$objWriter
$objWriter
Definition: 01pharSimple.php:81
PHPExcel_Style_Borders\DIAGONAL_DOWN
const DIAGONAL_DOWN
Definition: Borders.php:41
PHPExcel_Style_Borders\getLeft
getLeft()
Get Left.
Definition: Borders.php:268
PHPExcel_Style_Borders\getBottom
getBottom()
Get Bottom.
Definition: Borders.php:295
PHPExcel_Style_Borders\getTop
getTop()
Get Top.
Definition: Borders.php:286
PHPExcel_Style_Borders\getDiagonalDirection
getDiagonalDirection()
Get DiagonalDirection.
Definition: Borders.php:378
PHPExcel_Style_Borders\getRight
getRight()
Get Right.
Definition: Borders.php:277
PHPExcel_Style_Borders\DIAGONAL_BOTH
const DIAGONAL_BOTH
Definition: Borders.php:42
PHPExcel_Style_Borders\DIAGONAL_UP
const DIAGONAL_UP
Definition: Borders.php:40
PHPExcel_Style_Borders\getDiagonal
getDiagonal()
Get Diagonal.
Definition: Borders.php:304
PHPExcel_Writer_Excel2007_Style\_writeBorderPr
_writeBorderPr(PHPExcel_Shared_XMLWriter $objWriter=null, $pName='left', PHPExcel_Style_Border $pBorder=null)
Write BorderPr.
Definition: Style.php:535

References $objWriter, _writeBorderPr(), PHPExcel_Style_Borders\DIAGONAL_BOTH, PHPExcel_Style_Borders\DIAGONAL_DOWN, and PHPExcel_Style_Borders\DIAGONAL_UP.

Referenced by _writeCellStyleDxf(), and writeStyles().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeBorderPr()

PHPExcel_Writer_Excel2007_Style::_writeBorderPr ( PHPExcel_Shared_XMLWriter  $objWriter = null,
  $pName = 'left',
PHPExcel_Style_Border  $pBorder = null 
)
private

Write BorderPr.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
string$pNameElement name
PHPExcel_Style_Border$pBorderBorder style
Exceptions
PHPExcel_Writer_Exception

Definition at line 535 of file Style.php.

536 {
537 // Write BorderPr
538 if ($pBorder->getBorderStyle() != PHPExcel_Style_Border::BORDER_NONE) {
539 $objWriter->startElement($pName);
540 $objWriter->writeAttribute('style', $pBorder->getBorderStyle());
541
542 // color
543 $objWriter->startElement('color');
544 $objWriter->writeAttribute('rgb', $pBorder->getColor()->getARGB());
545 $objWriter->endElement();
546
547 $objWriter->endElement();
548 }
549 }
PHPExcel_Style_Border\getBorderStyle
getBorderStyle()
Get Border style.
Definition: Border.php:218
PHPExcel_Style_Border\getColor
getColor()
Get Border Color.
Definition: Border.php:254
PHPExcel_Style_Border\BORDER_NONE
const BORDER_NONE
Definition: Border.php:39

References $objWriter, and PHPExcel_Style_Border\BORDER_NONE.

Referenced by _writeBorder().

+ Here is the caller graph for this function:

◆ _writeCellStyleDxf()

PHPExcel_Writer_Excel2007_Style::_writeCellStyleDxf ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Style  $pStyle = null 
)
private

Write Cell Style Dxf.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Style$pStyleStyle
Exceptions
PHPExcel_Writer_Exception

Definition at line 469 of file Style.php.

470 {
471 // dxf
472 $objWriter->startElement('dxf');
473
474 // font
475 $this->_writeFont($objWriter, $pStyle->getFont());
476
477 // numFmt
478 $this->_writeNumFmt($objWriter, $pStyle->getNumberFormat());
479
480 // fill
481 $this->_writeFill($objWriter, $pStyle->getFill());
482
483 // alignment
484 $objWriter->startElement('alignment');
485 if ($pStyle->getAlignment()->getHorizontal() !== NULL) {
486 $objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal());
487 }
488 if ($pStyle->getAlignment()->getVertical() !== NULL) {
489 $objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical());
490 }
491
492 if ($pStyle->getAlignment()->getTextRotation() !== NULL) {
493 $textRotation = 0;
494 if ($pStyle->getAlignment()->getTextRotation() >= 0) {
495 $textRotation = $pStyle->getAlignment()->getTextRotation();
496 } else if ($pStyle->getAlignment()->getTextRotation() < 0) {
497 $textRotation = 90 - $pStyle->getAlignment()->getTextRotation();
498 }
499 $objWriter->writeAttribute('textRotation', $textRotation);
500 }
501 $objWriter->endElement();
502
503 // border
504 $this->_writeBorder($objWriter, $pStyle->getBorders());
505
506 // protection
507 if (($pStyle->getProtection()->getLocked() !== NULL) ||
508 ($pStyle->getProtection()->getHidden() !== NULL)) {
509 if ($pStyle->getProtection()->getLocked() !== PHPExcel_Style_Protection::PROTECTION_INHERIT ||
510 $pStyle->getProtection()->getHidden() !== PHPExcel_Style_Protection::PROTECTION_INHERIT) {
511 $objWriter->startElement('protection');
512 if (($pStyle->getProtection()->getLocked() !== NULL) &&
513 ($pStyle->getProtection()->getLocked() !== PHPExcel_Style_Protection::PROTECTION_INHERIT)) {
514 $objWriter->writeAttribute('locked', ($pStyle->getProtection()->getLocked() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
515 }
516 if (($pStyle->getProtection()->getHidden() !== NULL) &&
517 ($pStyle->getProtection()->getHidden() !== PHPExcel_Style_Protection::PROTECTION_INHERIT)) {
518 $objWriter->writeAttribute('hidden', ($pStyle->getProtection()->getHidden() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
519 }
520 $objWriter->endElement();
521 }
522 }
523
524 $objWriter->endElement();
525 }
PHPExcel_Style_Protection\PROTECTION_INHERIT
const PROTECTION_INHERIT
Protection styles.
Definition: Protection.php:39
PHPExcel_Style_Protection\PROTECTION_PROTECTED
const PROTECTION_PROTECTED
Definition: Protection.php:40
PHPExcel_Style\getBorders
getBorders()
Get Borders.
Definition: Style.php:532
PHPExcel_Style\getNumberFormat
getNumberFormat()
Get Number Format.
Definition: Style.php:552
PHPExcel_Style\getFill
getFill()
Get Fill.
Definition: Style.php:500
PHPExcel_Style\getProtection
getProtection()
Get Protection.
Definition: Style.php:586
PHPExcel_Style\getFont
getFont()
Get Font.
Definition: Style.php:510
PHPExcel_Style\getAlignment
getAlignment()
Get Alignment.
Definition: Style.php:542
PHPExcel_Writer_Excel2007_Style\_writeNumFmt
_writeNumFmt(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_NumberFormat $pNumberFormat=null, $pId=0)
Write NumberFormat.
Definition: Style.php:559
PHPExcel_Writer_Excel2007_Style\_writeFill
_writeFill(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Fill $pFill=null)
Write Fill.
Definition: Style.php:175
PHPExcel_Writer_Excel2007_Style\_writeFont
_writeFont(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Font $pFont=null)
Write Font.
Definition: Style.php:277
PHPExcel_Writer_Excel2007_Style\_writeBorder
_writeBorder(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Borders $pBorders=null)
Write Border.
Definition: Style.php:357

References $objWriter, _writeBorder(), _writeFill(), _writeFont(), _writeNumFmt(), PHPExcel_Style_Protection\PROTECTION_INHERIT, and PHPExcel_Style_Protection\PROTECTION_PROTECTED.

Referenced by writeStyles().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeCellStyleXf()

PHPExcel_Writer_Excel2007_Style::_writeCellStyleXf ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Style  $pStyle = null,
PHPExcel  $pPHPExcel = null 
)
private

Write Cell Style Xf.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Style$pStyleStyle
PHPExcel$pPHPExcelWorkbook
Exceptions
PHPExcel_Writer_Exception

Definition at line 394 of file Style.php.

395 {
396 // xf
397 $objWriter->startElement('xf');
398 $objWriter->writeAttribute('xfId', 0);
399 $objWriter->writeAttribute('fontId', (int)$this->getParentWriter()->getFontHashTable()->getIndexForHashCode($pStyle->getFont()->getHashCode()));
400 if ($pStyle->getQuotePrefix()) {
401 $objWriter->writeAttribute('quotePrefix', 1);
402 }
403
404 if ($pStyle->getNumberFormat()->getBuiltInFormatCode() === false) {
405 $objWriter->writeAttribute('numFmtId', (int)($this->getParentWriter()->getNumFmtHashTable()->getIndexForHashCode($pStyle->getNumberFormat()->getHashCode()) + 164) );
406 } else {
407 $objWriter->writeAttribute('numFmtId', (int)$pStyle->getNumberFormat()->getBuiltInFormatCode());
408 }
409
410 $objWriter->writeAttribute('fillId', (int)$this->getParentWriter()->getFillHashTable()->getIndexForHashCode($pStyle->getFill()->getHashCode()));
411 $objWriter->writeAttribute('borderId', (int)$this->getParentWriter()->getBordersHashTable()->getIndexForHashCode($pStyle->getBorders()->getHashCode()));
412
413 // Apply styles?
414 $objWriter->writeAttribute('applyFont', ($pPHPExcel->getDefaultStyle()->getFont()->getHashCode() != $pStyle->getFont()->getHashCode()) ? '1' : '0');
415 $objWriter->writeAttribute('applyNumberFormat', ($pPHPExcel->getDefaultStyle()->getNumberFormat()->getHashCode() != $pStyle->getNumberFormat()->getHashCode()) ? '1' : '0');
416 $objWriter->writeAttribute('applyFill', ($pPHPExcel->getDefaultStyle()->getFill()->getHashCode() != $pStyle->getFill()->getHashCode()) ? '1' : '0');
417 $objWriter->writeAttribute('applyBorder', ($pPHPExcel->getDefaultStyle()->getBorders()->getHashCode() != $pStyle->getBorders()->getHashCode()) ? '1' : '0');
418 $objWriter->writeAttribute('applyAlignment', ($pPHPExcel->getDefaultStyle()->getAlignment()->getHashCode() != $pStyle->getAlignment()->getHashCode()) ? '1' : '0');
419 if ($pStyle->getProtection()->getLocked() != PHPExcel_Style_Protection::PROTECTION_INHERIT || $pStyle->getProtection()->getHidden() != PHPExcel_Style_Protection::PROTECTION_INHERIT) {
420 $objWriter->writeAttribute('applyProtection', 'true');
421 }
422
423 // alignment
424 $objWriter->startElement('alignment');
425 $objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal());
426 $objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical());
427
428 $textRotation = 0;
429 if ($pStyle->getAlignment()->getTextRotation() >= 0) {
430 $textRotation = $pStyle->getAlignment()->getTextRotation();
431 } else if ($pStyle->getAlignment()->getTextRotation() < 0) {
432 $textRotation = 90 - $pStyle->getAlignment()->getTextRotation();
433 }
434 $objWriter->writeAttribute('textRotation', $textRotation);
435
436 $objWriter->writeAttribute('wrapText', ($pStyle->getAlignment()->getWrapText() ? 'true' : 'false'));
437 $objWriter->writeAttribute('shrinkToFit', ($pStyle->getAlignment()->getShrinkToFit() ? 'true' : 'false'));
438
439 if ($pStyle->getAlignment()->getIndent() > 0) {
440 $objWriter->writeAttribute('indent', $pStyle->getAlignment()->getIndent());
441 }
442 if ($pStyle->getAlignment()->getReadorder() > 0) {
443 $objWriter->writeAttribute('readingOrder', $pStyle->getAlignment()->getReadorder());
444 }
445 $objWriter->endElement();
446
447 // protection
448 if ($pStyle->getProtection()->getLocked() != PHPExcel_Style_Protection::PROTECTION_INHERIT || $pStyle->getProtection()->getHidden() != PHPExcel_Style_Protection::PROTECTION_INHERIT) {
449 $objWriter->startElement('protection');
450 if ($pStyle->getProtection()->getLocked() != PHPExcel_Style_Protection::PROTECTION_INHERIT) {
451 $objWriter->writeAttribute('locked', ($pStyle->getProtection()->getLocked() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
452 }
453 if ($pStyle->getProtection()->getHidden() != PHPExcel_Style_Protection::PROTECTION_INHERIT) {
454 $objWriter->writeAttribute('hidden', ($pStyle->getProtection()->getHidden() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
455 }
456 $objWriter->endElement();
457 }
458
459 $objWriter->endElement();
460 }
PHPExcel_Style\getQuotePrefix
getQuotePrefix()
Get quote prefix.
Definition: Style.php:596
PHPExcel_Writer_Excel2007_WriterPart\getParentWriter
getParentWriter()
Get parent IWriter object.
Definition: WriterPart.php:61
PHPExcel\getDefaultStyle
getDefaultStyle()
Get default style.
Definition: PHPExcel.php:925

References $objWriter, PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), PHPExcel_Style_Protection\PROTECTION_INHERIT, and PHPExcel_Style_Protection\PROTECTION_PROTECTED.

Referenced by writeStyles().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeFill()

PHPExcel_Writer_Excel2007_Style::_writeFill ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Style_Fill  $pFill = null 
)
private

Write Fill.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Style_Fill$pFillFill style
Exceptions
PHPExcel_Writer_Exception

Definition at line 175 of file Style.php.

176 {
177 // Check if this is a pattern type or gradient type
178 if ($pFill->getFillType() === PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR ||
179 $pFill->getFillType() === PHPExcel_Style_Fill::FILL_GRADIENT_PATH) {
180 // Gradient fill
181 $this->_writeGradientFill($objWriter, $pFill);
182 } elseif($pFill->getFillType() !== NULL) {
183 // Pattern fill
184 $this->_writePatternFill($objWriter, $pFill);
185 }
186 }
PHPExcel_Style_Fill\getFillType
getFillType()
Get Fill Type.
Definition: Fill.php:194
PHPExcel_Style_Fill\FILL_GRADIENT_PATH
const FILL_GRADIENT_PATH
Definition: Fill.php:42
PHPExcel_Style_Fill\FILL_GRADIENT_LINEAR
const FILL_GRADIENT_LINEAR
Definition: Fill.php:41
PHPExcel_Writer_Excel2007_Style\_writeGradientFill
_writeGradientFill(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Fill $pFill=null)
Write Gradient Fill.
Definition: Style.php:195
PHPExcel_Writer_Excel2007_Style\_writePatternFill
_writePatternFill(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style_Fill $pFill=null)
Write Pattern Fill.
Definition: Style.php:239

References $objWriter, _writeGradientFill(), _writePatternFill(), PHPExcel_Style_Fill\FILL_GRADIENT_LINEAR, and PHPExcel_Style_Fill\FILL_GRADIENT_PATH.

Referenced by _writeCellStyleDxf(), and writeStyles().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeFont()

PHPExcel_Writer_Excel2007_Style::_writeFont ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Style_Font  $pFont = null 
)
private

Write Font.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Style_Font$pFontFont style
Exceptions
PHPExcel_Writer_Exception

Definition at line 277 of file Style.php.

278 {
279 // font
280 $objWriter->startElement('font');
281 // Weird! The order of these elements actually makes a difference when opening Excel2007
282 // files in Excel2003 with the compatibility pack. It's not documented behaviour,
283 // and makes for a real WTF!
284
285 // Bold. We explicitly write this element also when false (like MS Office Excel 2007 does
286 // for conditional formatting). Otherwise it will apparently not be picked up in conditional
287 // formatting style dialog
288 if ($pFont->getBold() !== NULL) {
289 $objWriter->startElement('b');
290 $objWriter->writeAttribute('val', $pFont->getBold() ? '1' : '0');
291 $objWriter->endElement();
292 }
293
294 // Italic
295 if ($pFont->getItalic() !== NULL) {
296 $objWriter->startElement('i');
297 $objWriter->writeAttribute('val', $pFont->getItalic() ? '1' : '0');
298 $objWriter->endElement();
299 }
300
301 // Strikethrough
302 if ($pFont->getStrikethrough() !== NULL) {
303 $objWriter->startElement('strike');
304 $objWriter->writeAttribute('val', $pFont->getStrikethrough() ? '1' : '0');
305 $objWriter->endElement();
306 }
307
308 // Underline
309 if ($pFont->getUnderline() !== NULL) {
310 $objWriter->startElement('u');
311 $objWriter->writeAttribute('val', $pFont->getUnderline());
312 $objWriter->endElement();
313 }
314
315 // Superscript / subscript
316 if ($pFont->getSuperScript() === TRUE || $pFont->getSubScript() === TRUE) {
317 $objWriter->startElement('vertAlign');
318 if ($pFont->getSuperScript() === TRUE) {
319 $objWriter->writeAttribute('val', 'superscript');
320 } else if ($pFont->getSubScript() === TRUE) {
321 $objWriter->writeAttribute('val', 'subscript');
322 }
323 $objWriter->endElement();
324 }
325
326 // Size
327 if ($pFont->getSize() !== NULL) {
328 $objWriter->startElement('sz');
329 $objWriter->writeAttribute('val', $pFont->getSize());
330 $objWriter->endElement();
331 }
332
333 // Foreground color
334 if ($pFont->getColor()->getARGB() !== NULL) {
335 $objWriter->startElement('color');
336 $objWriter->writeAttribute('rgb', $pFont->getColor()->getARGB());
337 $objWriter->endElement();
338 }
339
340 // Name
341 if ($pFont->getName() !== NULL) {
342 $objWriter->startElement('name');
343 $objWriter->writeAttribute('val', $pFont->getName());
344 $objWriter->endElement();
345 }
346
347 $objWriter->endElement();
348 }
PHPExcel_Style_Font\getBold
getBold()
Get Bold.
Definition: Font.php:293
PHPExcel_Style_Font\getSize
getSize()
Get Size.
Definition: Font.php:262
PHPExcel_Style_Font\getUnderline
getUnderline()
Get Underline.
Definition: Font.php:419
PHPExcel_Style_Font\getColor
getColor()
Get Color.
Definition: Font.php:485
PHPExcel_Style_Font\getItalic
getItalic()
Get Italic.
Definition: Font.php:324
PHPExcel_Style_Font\getStrikethrough
getStrikethrough()
Get Strikethrough.
Definition: Font.php:454
PHPExcel_Style_Font\getSuperScript
getSuperScript()
Get SuperScript.
Definition: Font.php:355
PHPExcel_Style_Font\getName
getName()
Get Name.
Definition: Font.php:231
PHPExcel_Style_Font\getSubScript
getSubScript()
Get SubScript.
Definition: Font.php:387

References $objWriter.

Referenced by _writeCellStyleDxf(), and writeStyles().

+ Here is the caller graph for this function:

◆ _writeGradientFill()

PHPExcel_Writer_Excel2007_Style::_writeGradientFill ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Style_Fill  $pFill = null 
)
private

Write Gradient Fill.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Style_Fill$pFillFill style
Exceptions
PHPExcel_Writer_Exception

Definition at line 195 of file Style.php.

196 {
197 // fill
198 $objWriter->startElement('fill');
199
200 // gradientFill
201 $objWriter->startElement('gradientFill');
202 $objWriter->writeAttribute('type', $pFill->getFillType());
203 $objWriter->writeAttribute('degree', $pFill->getRotation());
204
205 // stop
206 $objWriter->startElement('stop');
207 $objWriter->writeAttribute('position', '0');
208
209 // color
210 $objWriter->startElement('color');
211 $objWriter->writeAttribute('rgb', $pFill->getStartColor()->getARGB());
212 $objWriter->endElement();
213
214 $objWriter->endElement();
215
216 // stop
217 $objWriter->startElement('stop');
218 $objWriter->writeAttribute('position', '1');
219
220 // color
221 $objWriter->startElement('color');
222 $objWriter->writeAttribute('rgb', $pFill->getEndColor()->getARGB());
223 $objWriter->endElement();
224
225 $objWriter->endElement();
226
227 $objWriter->endElement();
228
229 $objWriter->endElement();
230 }
PHPExcel_Style_Fill\getStartColor
getStartColor()
Get Start Color.
Definition: Fill.php:250
PHPExcel_Style_Fill\getRotation
getRotation()
Get Rotation.
Definition: Fill.php:222
PHPExcel_Style_Fill\getEndColor
getEndColor()
Get End Color.
Definition: Fill.php:279

References $objWriter.

Referenced by _writeFill().

+ Here is the caller graph for this function:

◆ _writeNumFmt()

PHPExcel_Writer_Excel2007_Style::_writeNumFmt ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Style_NumberFormat  $pNumberFormat = null,
  $pId = 0 
)
private

Write NumberFormat.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Style_NumberFormat$pNumberFormatNumber Format
int$pIdNumber Format identifier
Exceptions
PHPExcel_Writer_Exception

Definition at line 559 of file Style.php.

560 {
561 // Translate formatcode
562 $formatCode = $pNumberFormat->getFormatCode();
563
564 // numFmt
565 if ($formatCode !== NULL) {
566 $objWriter->startElement('numFmt');
567 $objWriter->writeAttribute('numFmtId', ($pId + 164));
568 $objWriter->writeAttribute('formatCode', $formatCode);
569 $objWriter->endElement();
570 }
571 }
PHPExcel_Style_NumberFormat\getFormatCode
getFormatCode()
Get Format Code.
Definition: NumberFormat.php:185

References $objWriter.

Referenced by _writeCellStyleDxf(), and writeStyles().

+ Here is the caller graph for this function:

◆ _writePatternFill()

PHPExcel_Writer_Excel2007_Style::_writePatternFill ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Style_Fill  $pFill = null 
)
private

Write Pattern Fill.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Style_Fill$pFillFill style
Exceptions
PHPExcel_Writer_Exception

Definition at line 239 of file Style.php.

240 {
241 // fill
242 $objWriter->startElement('fill');
243
244 // patternFill
245 $objWriter->startElement('patternFill');
246 $objWriter->writeAttribute('patternType', $pFill->getFillType());
247
248 if ($pFill->getFillType() !== PHPExcel_Style_Fill::FILL_NONE) {
249 // fgColor
250 if ($pFill->getStartColor()->getARGB()) {
251 $objWriter->startElement('fgColor');
252 $objWriter->writeAttribute('rgb', $pFill->getStartColor()->getARGB());
253 $objWriter->endElement();
254 }
255 }
256 if ($pFill->getFillType() !== PHPExcel_Style_Fill::FILL_NONE) {
257 // bgColor
258 if ($pFill->getEndColor()->getARGB()) {
259 $objWriter->startElement('bgColor');
260 $objWriter->writeAttribute('rgb', $pFill->getEndColor()->getARGB());
261 $objWriter->endElement();
262 }
263 }
264
265 $objWriter->endElement();
266
267 $objWriter->endElement();
268 }
PHPExcel_Style_Fill\FILL_NONE
const FILL_NONE
Definition: Fill.php:39

References $objWriter, and PHPExcel_Style_Fill\FILL_NONE.

Referenced by _writeFill().

+ Here is the caller graph for this function:

◆ allBorders()

PHPExcel_Writer_Excel2007_Style::allBorders ( PHPExcel  $pPHPExcel = null)

Get an array of all borders.

Parameters
PHPExcel$pPHPExcel
Returns
PHPExcel_Style_Borders[] All borders in PHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 671 of file Style.php.

672 {
673 // Get an array of unique borders
674 $aBorders = array();
675 $aStyles = $this->allStyles($pPHPExcel);
676
677 foreach ($aStyles as $style) {
678 if (!array_key_exists($style->getBorders()->getHashCode(), $aBorders)) {
679 $aBorders[ $style->getBorders()->getHashCode() ] = $style->getBorders();
680 }
681 }
682
683 return $aBorders;
684 }
PHPExcel_Writer_Excel2007_Style\allStyles
allStyles(PHPExcel $pPHPExcel=null)
Get an array of all styles.
Definition: Style.php:580
$style
$style
Definition: example_012.php:70

References $style, and allStyles().

+ Here is the call graph for this function:

◆ allConditionalStyles()

PHPExcel_Writer_Excel2007_Style::allConditionalStyles ( PHPExcel  $pPHPExcel = null)

Get an array of all conditional styles.

Parameters
PHPExcel$pPHPExcel
Returns
PHPExcel_Style_Conditional[] All conditional styles in PHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 594 of file Style.php.

595 {
596 // Get an array of all styles
597 $aStyles = array();
598
599 $sheetCount = $pPHPExcel->getSheetCount();
600 for ($i = 0; $i < $sheetCount; ++$i) {
601 foreach ($pPHPExcel->getSheet($i)->getConditionalStylesCollection() as $conditionalStyles) {
602 foreach ($conditionalStyles as $conditionalStyle) {
603 $aStyles[] = $conditionalStyle;
604 }
605 }
606 }
607
608 return $aStyles;
609 }
PHPExcel\getSheetCount
getSheetCount()
Get sheet count.
Definition: PHPExcel.php:661
PHPExcel\getSheet
getSheet($pIndex=0)
Get sheet by index.
Definition: PHPExcel.php:573

References $conditionalStyles.

◆ allFills()

PHPExcel_Writer_Excel2007_Style::allFills ( PHPExcel  $pPHPExcel = null)

Get an array of all fills.

Parameters
PHPExcel$pPHPExcel
Returns
PHPExcel_Style_Fill[] All fills in PHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 618 of file Style.php.

619 {
620 // Get an array of unique fills
621 $aFills = array();
622
623 // Two first fills are predefined
624 $fill0 = new PHPExcel_Style_Fill();
625 $fill0->setFillType(PHPExcel_Style_Fill::FILL_NONE);
626 $aFills[] = $fill0;
627
628 $fill1 = new PHPExcel_Style_Fill();
629 $fill1->setFillType(PHPExcel_Style_Fill::FILL_PATTERN_GRAY125);
630 $aFills[] = $fill1;
631 // The remaining fills
632 $aStyles = $this->allStyles($pPHPExcel);
633 foreach ($aStyles as $style) {
634 if (!array_key_exists($style->getFill()->getHashCode(), $aFills)) {
635 $aFills[ $style->getFill()->getHashCode() ] = $style->getFill();
636 }
637 }
638
639 return $aFills;
640 }
PHPExcel_Style_Fill
Definition: Fill.php:37
PHPExcel_Style_Fill\FILL_PATTERN_GRAY125
const FILL_PATTERN_GRAY125
Definition: Fill.php:51

References $style, allStyles(), PHPExcel_Style_Fill\FILL_NONE, and PHPExcel_Style_Fill\FILL_PATTERN_GRAY125.

+ Here is the call graph for this function:

◆ allFonts()

PHPExcel_Writer_Excel2007_Style::allFonts ( PHPExcel  $pPHPExcel = null)

Get an array of all fonts.

Parameters
PHPExcel$pPHPExcel
Returns
PHPExcel_Style_Font[] All fonts in PHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 649 of file Style.php.

650 {
651 // Get an array of unique fonts
652 $aFonts = array();
653 $aStyles = $this->allStyles($pPHPExcel);
654
655 foreach ($aStyles as $style) {
656 if (!array_key_exists($style->getFont()->getHashCode(), $aFonts)) {
657 $aFonts[ $style->getFont()->getHashCode() ] = $style->getFont();
658 }
659 }
660
661 return $aFonts;
662 }

References $style, and allStyles().

+ Here is the call graph for this function:

◆ allNumberFormats()

PHPExcel_Writer_Excel2007_Style::allNumberFormats ( PHPExcel  $pPHPExcel = null)

Get an array of all number formats.

Parameters
PHPExcel$pPHPExcel
Returns
PHPExcel_Style_NumberFormat[] All number formats in PHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 693 of file Style.php.

694 {
695 // Get an array of unique number formats
696 $aNumFmts = array();
697 $aStyles = $this->allStyles($pPHPExcel);
698
699 foreach ($aStyles as $style) {
700 if ($style->getNumberFormat()->getBuiltInFormatCode() === false && !array_key_exists($style->getNumberFormat()->getHashCode(), $aNumFmts)) {
701 $aNumFmts[ $style->getNumberFormat()->getHashCode() ] = $style->getNumberFormat();
702 }
703 }
704
705 return $aNumFmts;
706 }

References $style, and allStyles().

+ Here is the call graph for this function:

◆ allStyles()

PHPExcel_Writer_Excel2007_Style::allStyles ( PHPExcel  $pPHPExcel = null)

Get an array of all styles.

Parameters
PHPExcel$pPHPExcel
Returns
PHPExcel_Style[] All styles in PHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 580 of file Style.php.

581 {
582 $aStyles = $pPHPExcel->getCellXfCollection();
583
584 return $aStyles;
585 }
PHPExcel\getCellXfCollection
getCellXfCollection()
Get the workbook collection of cellXfs.
Definition: PHPExcel.php:876

Referenced by allBorders(), allFills(), allFonts(), and allNumberFormats().

+ Here is the caller graph for this function:

◆ writeStyles()

PHPExcel_Writer_Excel2007_Style::writeStyles ( PHPExcel  $pPHPExcel = null)

Write styles to XML format.

Parameters
PHPExcel$pPHPExcel
Returns
string XML Output
Exceptions
PHPExcel_Writer_Exception

Definition at line 45 of file Style.php.

46 {
47 // Create XML writer
48 $objWriter = null;
49 if ($this->getParentWriter()->getUseDiskCaching()) {
50 $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
51 } else {
52 $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
53 }
54
55 // XML header
56 $objWriter->startDocument('1.0','UTF-8','yes');
57
58 // styleSheet
59 $objWriter->startElement('styleSheet');
60 $objWriter->writeAttribute('xml:space', 'preserve');
61 $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');
62
63 // numFmts
64 $objWriter->startElement('numFmts');
65 $objWriter->writeAttribute('count', $this->getParentWriter()->getNumFmtHashTable()->count());
66
67 // numFmt
68 for ($i = 0; $i < $this->getParentWriter()->getNumFmtHashTable()->count(); ++$i) {
69 $this->_writeNumFmt($objWriter, $this->getParentWriter()->getNumFmtHashTable()->getByIndex($i), $i);
70 }
71
72 $objWriter->endElement();
73
74 // fonts
75 $objWriter->startElement('fonts');
76 $objWriter->writeAttribute('count', $this->getParentWriter()->getFontHashTable()->count());
77
78 // font
79 for ($i = 0; $i < $this->getParentWriter()->getFontHashTable()->count(); ++$i) {
80 $this->_writeFont($objWriter, $this->getParentWriter()->getFontHashTable()->getByIndex($i));
81 }
82
83 $objWriter->endElement();
84
85 // fills
86 $objWriter->startElement('fills');
87 $objWriter->writeAttribute('count', $this->getParentWriter()->getFillHashTable()->count());
88
89 // fill
90 for ($i = 0; $i < $this->getParentWriter()->getFillHashTable()->count(); ++$i) {
91 $this->_writeFill($objWriter, $this->getParentWriter()->getFillHashTable()->getByIndex($i));
92 }
93
94 $objWriter->endElement();
95
96 // borders
97 $objWriter->startElement('borders');
98 $objWriter->writeAttribute('count', $this->getParentWriter()->getBordersHashTable()->count());
99
100 // border
101 for ($i = 0; $i < $this->getParentWriter()->getBordersHashTable()->count(); ++$i) {
102 $this->_writeBorder($objWriter, $this->getParentWriter()->getBordersHashTable()->getByIndex($i));
103 }
104
105 $objWriter->endElement();
106
107 // cellStyleXfs
108 $objWriter->startElement('cellStyleXfs');
109 $objWriter->writeAttribute('count', 1);
110
111 // xf
112 $objWriter->startElement('xf');
113 $objWriter->writeAttribute('numFmtId', 0);
114 $objWriter->writeAttribute('fontId', 0);
115 $objWriter->writeAttribute('fillId', 0);
116 $objWriter->writeAttribute('borderId', 0);
117 $objWriter->endElement();
118
119 $objWriter->endElement();
120
121 // cellXfs
122 $objWriter->startElement('cellXfs');
123 $objWriter->writeAttribute('count', count($pPHPExcel->getCellXfCollection()));
124
125 // xf
126 foreach ($pPHPExcel->getCellXfCollection() as $cellXf) {
127 $this->_writeCellStyleXf($objWriter, $cellXf, $pPHPExcel);
128 }
129
130 $objWriter->endElement();
131
132 // cellStyles
133 $objWriter->startElement('cellStyles');
134 $objWriter->writeAttribute('count', 1);
135
136 // cellStyle
137 $objWriter->startElement('cellStyle');
138 $objWriter->writeAttribute('name', 'Normal');
139 $objWriter->writeAttribute('xfId', 0);
140 $objWriter->writeAttribute('builtinId', 0);
141 $objWriter->endElement();
142
143 $objWriter->endElement();
144
145 // dxfs
146 $objWriter->startElement('dxfs');
147 $objWriter->writeAttribute('count', $this->getParentWriter()->getStylesConditionalHashTable()->count());
148
149 // dxf
150 for ($i = 0; $i < $this->getParentWriter()->getStylesConditionalHashTable()->count(); ++$i) {
151 $this->_writeCellStyleDxf($objWriter, $this->getParentWriter()->getStylesConditionalHashTable()->getByIndex($i)->getStyle());
152 }
153
154 $objWriter->endElement();
155
156 // tableStyles
157 $objWriter->startElement('tableStyles');
158 $objWriter->writeAttribute('defaultTableStyle', 'TableStyleMedium9');
159 $objWriter->writeAttribute('defaultPivotStyle', 'PivotTableStyle1');
160 $objWriter->endElement();
161
162 $objWriter->endElement();
163
164 // Return
165 return $objWriter->getData();
166 }
PHPExcel_Shared_XMLWriter
Definition: XMLWriter.php:44
PHPExcel_Shared_XMLWriter\STORAGE_DISK
const STORAGE_DISK
Definition: XMLWriter.php:47
PHPExcel_Shared_XMLWriter\STORAGE_MEMORY
const STORAGE_MEMORY
Temporary storage method.
Definition: XMLWriter.php:46
PHPExcel_Writer_Excel2007_Style\_writeCellStyleXf
_writeCellStyleXf(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style $pStyle=null, PHPExcel $pPHPExcel=null)
Write Cell Style Xf.
Definition: Style.php:394
PHPExcel_Writer_Excel2007_Style\_writeCellStyleDxf
_writeCellStyleDxf(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Style $pStyle=null)
Write Cell Style Dxf.
Definition: Style.php:469

References $objWriter, _writeBorder(), _writeCellStyleDxf(), _writeCellStyleXf(), _writeFill(), _writeFont(), _writeNumFmt(), PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), PHPExcel_Shared_XMLWriter\STORAGE_DISK, and PHPExcel_Shared_XMLWriter\STORAGE_MEMORY.

+ Here is the call graph for this function:
The documentation for this class was generated from the following file: