1: <?php
  2: /**
  3:  * PHPExcel
  4:  *
  5:  * Copyright (c) 2006 - 2014 PHPExcel
  6:  *
  7:  * This library is free software; you can redistribute it and/or
  8:  * modify it under the terms of the GNU Lesser General Public
  9:  * License as published by the Free Software Foundation; either
 10:  * version 2.1 of the License, or (at your option) any later version.
 11:  *
 12:  * This library is distributed in the hope that it will be useful,
 13:  * but WITHOUT ANY WARRANTY; without even the implied warranty of
 14:  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 15:  * Lesser General Public License for more details.
 16:  *
 17:  * You should have received a copy of the GNU Lesser General Public
 18:  * License along with this library; if not, write to the Free Software
 19:  * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 20:  *
 21:  * @category   PHPExcel
 22:  * @package    PHPExcel_Writer_Excel2007
 23:  * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 24:  * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL
 25:  * @version    1.8.0, 2014-03-02
 26:  */
 27: 
 28: 
 29: /**
 30:  * PHPExcel_Writer_Excel2007_Style
 31:  *
 32:  * @category   PHPExcel
 33:  * @package    PHPExcel_Writer_Excel2007
 34:  * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 35:  */
 36: class PHPExcel_Writer_Excel2007_Style extends PHPExcel_Writer_Excel2007_WriterPart
 37: {
 38:     /**
 39:      * Write styles to XML format
 40:      *
 41:      * @param   PHPExcel    $pPHPExcel
 42:      * @return  string      XML Output
 43:      * @throws  PHPExcel_Writer_Exception
 44:      */
 45:     public function writeStyles(PHPExcel $pPHPExcel = null)
 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:     }
167: 
168:     /**
169:      * Write Fill
170:      *
171:      * @param   PHPExcel_Shared_XMLWriter   $objWriter      XML Writer
172:      * @param   PHPExcel_Style_Fill         $pFill          Fill style
173:      * @throws  PHPExcel_Writer_Exception
174:      */
175:     private function _writeFill(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Fill $pFill = null)
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:     }
187: 
188:     /**
189:      * Write Gradient Fill
190:      *
191:      * @param   PHPExcel_Shared_XMLWriter   $objWriter      XML Writer
192:      * @param   PHPExcel_Style_Fill         $pFill          Fill style
193:      * @throws  PHPExcel_Writer_Exception
194:      */
195:     private function _writeGradientFill(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Fill $pFill = null)
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:     }
231: 
232:     /**
233:      * Write Pattern Fill
234:      *
235:      * @param   PHPExcel_Shared_XMLWriter           $objWriter      XML Writer
236:      * @param   PHPExcel_Style_Fill                 $pFill          Fill style
237:      * @throws  PHPExcel_Writer_Exception
238:      */
239:     private function _writePatternFill(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Fill $pFill = null)
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:     }
269: 
270:     /**
271:      * Write Font
272:      *
273:      * @param   PHPExcel_Shared_XMLWriter       $objWriter      XML Writer
274:      * @param   PHPExcel_Style_Font             $pFont          Font style
275:      * @throws  PHPExcel_Writer_Exception
276:      */
277:     private function _writeFont(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Font $pFont = null)
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:     }
349: 
350:     /**
351:      * Write Border
352:      *
353:      * @param   PHPExcel_Shared_XMLWriter           $objWriter      XML Writer
354:      * @param   PHPExcel_Style_Borders              $pBorders       Borders style
355:      * @throws  PHPExcel_Writer_Exception
356:      */
357:     private function _writeBorder(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_Borders $pBorders = null)
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:     }
385: 
386:     /**
387:      * Write Cell Style Xf
388:      *
389:      * @param   PHPExcel_Shared_XMLWriter           $objWriter      XML Writer
390:      * @param   PHPExcel_Style                      $pStyle         Style
391:      * @param   PHPExcel                            $pPHPExcel      Workbook
392:      * @throws  PHPExcel_Writer_Exception
393:      */
394:     private function _writeCellStyleXf(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style $pStyle = null, PHPExcel $pPHPExcel = null)
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:             $objWriter->endElement();
443: 
444:             // protection
445:             if ($pStyle->getProtection()->getLocked() != PHPExcel_Style_Protection::PROTECTION_INHERIT || $pStyle->getProtection()->getHidden() != PHPExcel_Style_Protection::PROTECTION_INHERIT) {
446:                 $objWriter->startElement('protection');
447:                     if ($pStyle->getProtection()->getLocked() != PHPExcel_Style_Protection::PROTECTION_INHERIT) {
448:                         $objWriter->writeAttribute('locked',        ($pStyle->getProtection()->getLocked() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
449:                     }
450:                     if ($pStyle->getProtection()->getHidden() != PHPExcel_Style_Protection::PROTECTION_INHERIT) {
451:                         $objWriter->writeAttribute('hidden',        ($pStyle->getProtection()->getHidden() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
452:                     }
453:                 $objWriter->endElement();
454:             }
455: 
456:         $objWriter->endElement();
457:     }
458: 
459:     /**
460:      * Write Cell Style Dxf
461:      *
462:      * @param   PHPExcel_Shared_XMLWriter       $objWriter      XML Writer
463:      * @param   PHPExcel_Style                  $pStyle         Style
464:      * @throws  PHPExcel_Writer_Exception
465:      */
466:     private function _writeCellStyleDxf(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style $pStyle = null)
467:     {
468:         // dxf
469:         $objWriter->startElement('dxf');
470: 
471:             // font
472:             $this->_writeFont($objWriter, $pStyle->getFont());
473: 
474:             // numFmt
475:             $this->_writeNumFmt($objWriter, $pStyle->getNumberFormat());
476: 
477:             // fill
478:             $this->_writeFill($objWriter, $pStyle->getFill());
479: 
480:             // alignment
481:             $objWriter->startElement('alignment');
482:                 if ($pStyle->getAlignment()->getHorizontal() !== NULL) {
483:                     $objWriter->writeAttribute('horizontal', $pStyle->getAlignment()->getHorizontal());
484:                 }
485:                 if ($pStyle->getAlignment()->getVertical() !== NULL) {
486:                     $objWriter->writeAttribute('vertical', $pStyle->getAlignment()->getVertical());
487:                 }
488: 
489:                 if ($pStyle->getAlignment()->getTextRotation() !== NULL) {
490:                     $textRotation = 0;
491:                     if ($pStyle->getAlignment()->getTextRotation() >= 0) {
492:                         $textRotation = $pStyle->getAlignment()->getTextRotation();
493:                     } else if ($pStyle->getAlignment()->getTextRotation() < 0) {
494:                         $textRotation = 90 - $pStyle->getAlignment()->getTextRotation();
495:                     }
496:                     $objWriter->writeAttribute('textRotation',  $textRotation);
497:                 }
498:             $objWriter->endElement();
499: 
500:             // border
501:             $this->_writeBorder($objWriter, $pStyle->getBorders());
502: 
503:             // protection
504:             if (($pStyle->getProtection()->getLocked() !== NULL) ||
505:                 ($pStyle->getProtection()->getHidden() !== NULL)) {
506:                 if ($pStyle->getProtection()->getLocked() !== PHPExcel_Style_Protection::PROTECTION_INHERIT ||
507:                     $pStyle->getProtection()->getHidden() !== PHPExcel_Style_Protection::PROTECTION_INHERIT) {
508:                     $objWriter->startElement('protection');
509:                         if (($pStyle->getProtection()->getLocked() !== NULL) &&
510:                             ($pStyle->getProtection()->getLocked() !== PHPExcel_Style_Protection::PROTECTION_INHERIT)) {
511:                             $objWriter->writeAttribute('locked', ($pStyle->getProtection()->getLocked() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
512:                         }
513:                         if (($pStyle->getProtection()->getHidden() !== NULL) &&
514:                             ($pStyle->getProtection()->getHidden() !== PHPExcel_Style_Protection::PROTECTION_INHERIT)) {
515:                             $objWriter->writeAttribute('hidden', ($pStyle->getProtection()->getHidden() == PHPExcel_Style_Protection::PROTECTION_PROTECTED ? 'true' : 'false'));
516:                         }
517:                     $objWriter->endElement();
518:                 }
519:             }
520: 
521:         $objWriter->endElement();
522:     }
523: 
524:     /**
525:      * Write BorderPr
526:      *
527:      * @param   PHPExcel_Shared_XMLWriter       $objWriter      XML Writer
528:      * @param   string                          $pName          Element name
529:      * @param   PHPExcel_Style_Border           $pBorder        Border style
530:      * @throws  PHPExcel_Writer_Exception
531:      */
532:     private function _writeBorderPr(PHPExcel_Shared_XMLWriter $objWriter = null, $pName = 'left', PHPExcel_Style_Border $pBorder = null)
533:     {
534:         // Write BorderPr
535:         if ($pBorder->getBorderStyle() != PHPExcel_Style_Border::BORDER_NONE) {
536:             $objWriter->startElement($pName);
537:             $objWriter->writeAttribute('style',     $pBorder->getBorderStyle());
538: 
539:                 // color
540:                 $objWriter->startElement('color');
541:                 $objWriter->writeAttribute('rgb',   $pBorder->getColor()->getARGB());
542:                 $objWriter->endElement();
543: 
544:             $objWriter->endElement();
545:         }
546:     }
547: 
548:     /**
549:      * Write NumberFormat
550:      *
551:      * @param   PHPExcel_Shared_XMLWriter           $objWriter      XML Writer
552:      * @param   PHPExcel_Style_NumberFormat         $pNumberFormat  Number Format
553:      * @param   int                                 $pId            Number Format identifier
554:      * @throws  PHPExcel_Writer_Exception
555:      */
556:     private function _writeNumFmt(PHPExcel_Shared_XMLWriter $objWriter = null, PHPExcel_Style_NumberFormat $pNumberFormat = null, $pId = 0)
557:     {
558:         // Translate formatcode
559:         $formatCode = $pNumberFormat->getFormatCode();
560: 
561:         // numFmt
562:         if ($formatCode !== NULL) {
563:             $objWriter->startElement('numFmt');
564:                 $objWriter->writeAttribute('numFmtId', ($pId + 164));
565:                 $objWriter->writeAttribute('formatCode', $formatCode);
566:             $objWriter->endElement();
567:         }
568:     }
569: 
570:     /**
571:      * Get an array of all styles
572:      *
573:      * @param   PHPExcel                $pPHPExcel
574:      * @return  PHPExcel_Style[]        All styles in PHPExcel
575:      * @throws  PHPExcel_Writer_Exception
576:      */
577:     public function allStyles(PHPExcel $pPHPExcel = null)
578:     {
579:         $aStyles = $pPHPExcel->getCellXfCollection();
580: 
581:         return $aStyles;
582:     }
583: 
584:     /**
585:      * Get an array of all conditional styles
586:      *
587:      * @param   PHPExcel                            $pPHPExcel
588:      * @return  PHPExcel_Style_Conditional[]        All conditional styles in PHPExcel
589:      * @throws  PHPExcel_Writer_Exception
590:      */
591:     public function allConditionalStyles(PHPExcel $pPHPExcel = null)
592:     {
593:         // Get an array of all styles
594:         $aStyles        = array();
595: 
596:         $sheetCount = $pPHPExcel->getSheetCount();
597:         for ($i = 0; $i < $sheetCount; ++$i) {
598:             foreach ($pPHPExcel->getSheet($i)->getConditionalStylesCollection() as $conditionalStyles) {
599:                 foreach ($conditionalStyles as $conditionalStyle) {
600:                     $aStyles[] = $conditionalStyle;
601:                 }
602:             }
603:         }
604: 
605:         return $aStyles;
606:     }
607: 
608:     /**
609:      * Get an array of all fills
610:      *
611:      * @param   PHPExcel                        $pPHPExcel
612:      * @return  PHPExcel_Style_Fill[]       All fills in PHPExcel
613:      * @throws  PHPExcel_Writer_Exception
614:      */
615:     public function allFills(PHPExcel $pPHPExcel = null)
616:     {
617:         // Get an array of unique fills
618:         $aFills     = array();
619: 
620:         // Two first fills are predefined
621:         $fill0 = new PHPExcel_Style_Fill();
622:         $fill0->setFillType(PHPExcel_Style_Fill::FILL_NONE);
623:         $aFills[] = $fill0;
624: 
625:         $fill1 = new PHPExcel_Style_Fill();
626:         $fill1->setFillType(PHPExcel_Style_Fill::FILL_PATTERN_GRAY125);
627:         $aFills[] = $fill1;
628:         // The remaining fills
629:         $aStyles    = $this->allStyles($pPHPExcel);
630:         foreach ($aStyles as $style) {
631:             if (!array_key_exists($style->getFill()->getHashCode(), $aFills)) {
632:                 $aFills[ $style->getFill()->getHashCode() ] = $style->getFill();
633:             }
634:         }
635: 
636:         return $aFills;
637:     }
638: 
639:     /**
640:      * Get an array of all fonts
641:      *
642:      * @param   PHPExcel                        $pPHPExcel
643:      * @return  PHPExcel_Style_Font[]       All fonts in PHPExcel
644:      * @throws  PHPExcel_Writer_Exception
645:      */
646:     public function allFonts(PHPExcel $pPHPExcel = null)
647:     {
648:         // Get an array of unique fonts
649:         $aFonts     = array();
650:         $aStyles    = $this->allStyles($pPHPExcel);
651: 
652:         foreach ($aStyles as $style) {
653:             if (!array_key_exists($style->getFont()->getHashCode(), $aFonts)) {
654:                 $aFonts[ $style->getFont()->getHashCode() ] = $style->getFont();
655:             }
656:         }
657: 
658:         return $aFonts;
659:     }
660: 
661:     /**
662:      * Get an array of all borders
663:      *
664:      * @param   PHPExcel                        $pPHPExcel
665:      * @return  PHPExcel_Style_Borders[]        All borders in PHPExcel
666:      * @throws  PHPExcel_Writer_Exception
667:      */
668:     public function allBorders(PHPExcel $pPHPExcel = null)
669:     {
670:         // Get an array of unique borders
671:         $aBorders   = array();
672:         $aStyles    = $this->allStyles($pPHPExcel);
673: 
674:         foreach ($aStyles as $style) {
675:             if (!array_key_exists($style->getBorders()->getHashCode(), $aBorders)) {
676:                 $aBorders[ $style->getBorders()->getHashCode() ] = $style->getBorders();
677:             }
678:         }
679: 
680:         return $aBorders;
681:     }
682: 
683:     /**
684:      * Get an array of all number formats
685:      *
686:      * @param   PHPExcel                                $pPHPExcel
687:      * @return  PHPExcel_Style_NumberFormat[]       All number formats in PHPExcel
688:      * @throws  PHPExcel_Writer_Exception
689:      */
690:     public function allNumberFormats(PHPExcel $pPHPExcel = null)
691:     {
692:         // Get an array of unique number formats
693:         $aNumFmts   = array();
694:         $aStyles    = $this->allStyles($pPHPExcel);
695: 
696:         foreach ($aStyles as $style) {
697:             if ($style->getNumberFormat()->getBuiltInFormatCode() === false && !array_key_exists($style->getNumberFormat()->getHashCode(), $aNumFmts)) {
698:                 $aNumFmts[ $style->getNumberFormat()->getHashCode() ] = $style->getNumberFormat();
699:             }
700:         }
701: 
702:         return $aNumFmts;
703:     }
704: }
705: