Context Navigation

← Previous Revision
Latest Revision
Next Revision →
Normal
Revision Log

Style.php @ 1

Last change on this file since 1 was 1, checked in by dungnv, 11 years ago

File size: 23.9 KB

Rev	Line
[1]	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	}

Note: See TracBrowser for help on using the repository browser.

Context Navigation

source: sourcecode/application/libraries/PHPExcel/Writer/Excel2007/Style.php @ 1

Download in other formats: