ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
Public Member Functions
PHPExcel_Writer_Excel2007_DocProps Class Reference
+ Inheritance diagram for PHPExcel_Writer_Excel2007_DocProps:
+ Collaboration diagram for PHPExcel_Writer_Excel2007_DocProps:

Public Member Functions

 writeDocPropsApp (PHPExcel $pPHPExcel=null)
 Write docProps/app.xml to XML format. More...
 
 writeDocPropsCore (PHPExcel $pPHPExcel=null)
 Write docProps/core.xml to XML format. More...
 
 writeDocPropsCustom (PHPExcel $pPHPExcel=null)
 Write docProps/custom.xml to XML format. 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...
 

Detailed Description

Definition at line 36 of file DocProps.php.

Member Function Documentation

◆ writeDocPropsApp()

PHPExcel_Writer_Excel2007_DocProps::writeDocPropsApp ( PHPExcel  $pPHPExcel = null)

Write docProps/app.xml to XML format.

Parameters
PHPExcel$pPHPExcel
Returns
string XML Output
Exceptions
PHPExcel_Writer_Exception

Definition at line 45 of file DocProps.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 // Properties
59 $objWriter->startElement('Properties');
60 $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/officeDocument/2006/extended-properties');
61 $objWriter->writeAttribute('xmlns:vt', 'http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes');
62
63 // Application
64 $objWriter->writeElement('Application', 'Microsoft Excel');
65
66 // DocSecurity
67 $objWriter->writeElement('DocSecurity', '0');
68
69 // ScaleCrop
70 $objWriter->writeElement('ScaleCrop', 'false');
71
72 // HeadingPairs
73 $objWriter->startElement('HeadingPairs');
74
75 // Vector
76 $objWriter->startElement('vt:vector');
77 $objWriter->writeAttribute('size', '2');
78 $objWriter->writeAttribute('baseType', 'variant');
79
80 // Variant
81 $objWriter->startElement('vt:variant');
82 $objWriter->writeElement('vt:lpstr', 'Worksheets');
83 $objWriter->endElement();
84
85 // Variant
86 $objWriter->startElement('vt:variant');
87 $objWriter->writeElement('vt:i4', $pPHPExcel->getSheetCount());
88 $objWriter->endElement();
89
90 $objWriter->endElement();
91
92 $objWriter->endElement();
93
94 // TitlesOfParts
95 $objWriter->startElement('TitlesOfParts');
96
97 // Vector
98 $objWriter->startElement('vt:vector');
99 $objWriter->writeAttribute('size', $pPHPExcel->getSheetCount());
100 $objWriter->writeAttribute('baseType', 'lpstr');
101
102 $sheetCount = $pPHPExcel->getSheetCount();
103 for ($i = 0; $i < $sheetCount; ++$i) {
104 $objWriter->writeElement('vt:lpstr', $pPHPExcel->getSheet($i)->getTitle());
105 }
106
107 $objWriter->endElement();
108
109 $objWriter->endElement();
110
111 // Company
112 $objWriter->writeElement('Company', $pPHPExcel->getProperties()->getCompany());
113
114 // Company
115 $objWriter->writeElement('Manager', $pPHPExcel->getProperties()->getManager());
116
117 // LinksUpToDate
118 $objWriter->writeElement('LinksUpToDate', 'false');
119
120 // SharedDoc
121 $objWriter->writeElement('SharedDoc', 'false');
122
123 // HyperlinksChanged
124 $objWriter->writeElement('HyperlinksChanged', 'false');
125
126 // AppVersion
127 $objWriter->writeElement('AppVersion', '12.0000');
128
129 $objWriter->endElement();
130
131 // Return
132 return $objWriter->getData();
133 }
$objWriter
$objWriter
Definition: 01pharSimple.php:81
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_WriterPart\getParentWriter
getParentWriter()
Get parent IWriter object.
Definition: WriterPart.php:61
PHPExcel\getSheetCount
getSheetCount()
Get sheet count.
Definition: PHPExcel.php:661
PHPExcel\getProperties
getProperties()
Get properties.
Definition: PHPExcel.php:425
PHPExcel\getSheet
getSheet($pIndex=0)
Get sheet by index.
Definition: PHPExcel.php:573
$i
$i
Definition: disco.tpl.php:19

References $i, $objWriter, PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), PHPExcel_Shared_XMLWriter\STORAGE_DISK, and PHPExcel_Shared_XMLWriter\STORAGE_MEMORY.

+ Here is the call graph for this function:

◆ writeDocPropsCore()

PHPExcel_Writer_Excel2007_DocProps::writeDocPropsCore ( PHPExcel  $pPHPExcel = null)

Write docProps/core.xml to XML format.

Parameters
PHPExcel$pPHPExcel
Returns
string XML Output
Exceptions
PHPExcel_Writer_Exception

Definition at line 142 of file DocProps.php.

143 {
144 // Create XML writer
145 $objWriter = null;
146 if ($this->getParentWriter()->getUseDiskCaching()) {
147 $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
148 } else {
149 $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
150 }
151
152 // XML header
153 $objWriter->startDocument('1.0','UTF-8','yes');
154
155 // cp:coreProperties
156 $objWriter->startElement('cp:coreProperties');
157 $objWriter->writeAttribute('xmlns:cp', 'http://schemas.openxmlformats.org/package/2006/metadata/core-properties');
158 $objWriter->writeAttribute('xmlns:dc', 'http://purl.org/dc/elements/1.1/');
159 $objWriter->writeAttribute('xmlns:dcterms', 'http://purl.org/dc/terms/');
160 $objWriter->writeAttribute('xmlns:dcmitype', 'http://purl.org/dc/dcmitype/');
161 $objWriter->writeAttribute('xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance');
162
163 // dc:creator
164 $objWriter->writeElement('dc:creator', $pPHPExcel->getProperties()->getCreator());
165
166 // cp:lastModifiedBy
167 $objWriter->writeElement('cp:lastModifiedBy', $pPHPExcel->getProperties()->getLastModifiedBy());
168
169 // dcterms:created
170 $objWriter->startElement('dcterms:created');
171 $objWriter->writeAttribute('xsi:type', 'dcterms:W3CDTF');
172 $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getCreated()));
173 $objWriter->endElement();
174
175 // dcterms:modified
176 $objWriter->startElement('dcterms:modified');
177 $objWriter->writeAttribute('xsi:type', 'dcterms:W3CDTF');
178 $objWriter->writeRawData(date(DATE_W3C, $pPHPExcel->getProperties()->getModified()));
179 $objWriter->endElement();
180
181 // dc:title
182 $objWriter->writeElement('dc:title', $pPHPExcel->getProperties()->getTitle());
183
184 // dc:description
185 $objWriter->writeElement('dc:description', $pPHPExcel->getProperties()->getDescription());
186
187 // dc:subject
188 $objWriter->writeElement('dc:subject', $pPHPExcel->getProperties()->getSubject());
189
190 // cp:keywords
191 $objWriter->writeElement('cp:keywords', $pPHPExcel->getProperties()->getKeywords());
192
193 // cp:category
194 $objWriter->writeElement('cp:category', $pPHPExcel->getProperties()->getCategory());
195
196 $objWriter->endElement();
197
198 // Return
199 return $objWriter->getData();
200 }
date
date( 'd-M-Y', $objPHPExcel->getProperties() ->getCreated())
Definition: 31docproperties_write-xls.php:86

References $objWriter, date, PHPExcel_Writer_Excel2007_WriterPart\getParentWriter(), PHPExcel_Shared_XMLWriter\STORAGE_DISK, and PHPExcel_Shared_XMLWriter\STORAGE_MEMORY.

+ Here is the call graph for this function:

◆ writeDocPropsCustom()

PHPExcel_Writer_Excel2007_DocProps::writeDocPropsCustom ( PHPExcel  $pPHPExcel = null)

Write docProps/custom.xml to XML format.

Parameters
PHPExcel$pPHPExcel
Returns
string XML Output
Exceptions
PHPExcel_Writer_Exception

Definition at line 209 of file DocProps.php.

210 {
211 $customPropertyList = $pPHPExcel->getProperties()->getCustomProperties();
212 if (empty($customPropertyList)) {
213 return;
214 }
215
216 // Create XML writer
217 $objWriter = null;
218 if ($this->getParentWriter()->getUseDiskCaching()) {
219 $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
220 } else {
221 $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
222 }
223
224 // XML header
225 $objWriter->startDocument('1.0','UTF-8','yes');
226
227 // cp:coreProperties
228 $objWriter->startElement('Properties');
229 $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/officeDocument/2006/custom-properties');
230 $objWriter->writeAttribute('xmlns:vt', 'http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes');
231
232
233 foreach($customPropertyList as $key => $customProperty) {
234 $propertyValue = $pPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
235 $propertyType = $pPHPExcel->getProperties()->getCustomPropertyType($customProperty);
236
237 $objWriter->startElement('property');
238 $objWriter->writeAttribute('fmtid', '{D5CDD505-2E9C-101B-9397-08002B2CF9AE}');
239 $objWriter->writeAttribute('pid', $key+2);
240 $objWriter->writeAttribute('name', $customProperty);
241
242 switch($propertyType) {
243 case 'i' :
244 $objWriter->writeElement('vt:i4', $propertyValue);
245 break;
246 case 'f' :
247 $objWriter->writeElement('vt:r8', $propertyValue);
248 break;
249 case 'b' :
250 $objWriter->writeElement('vt:bool', ($propertyValue) ? 'true' : 'false');
251 break;
252 case 'd' :
253 $objWriter->startElement('vt:filetime');
254 $objWriter->writeRawData(date(DATE_W3C, $propertyValue));
255 $objWriter->endElement();
256 break;
257 default :
258 $objWriter->writeElement('vt:lpwstr', $propertyValue);
259 break;
260 }
261
262 $objWriter->endElement();
263 }
264
265
266 $objWriter->endElement();
267
268 // Return
269 return $objWriter->getData();
270 }
$key
$key
Definition: croninfo.php:18

References $key, $objWriter, date, 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: