File Source for DocProps.php

PHPExcel_Writer_Excel2007

# Source for file DocProps.php

Documentation is available at DocProps.php

1. <?php
2. /**
3. * PHPExcel
4. *
5. * Copyright (c) 2006 - 2011 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 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
24. * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
25. * @version 1.7.6, 2011-02-27
26. */
29. /**
30. * PHPExcel_Writer_Excel2007_DocProps
31. *
32. * @category PHPExcel
33. * @package PHPExcel_Writer_Excel2007
34. * @copyright Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
35. */
36. class PHPExcel_Writer_Excel2007_DocProps extends PHPExcel_Writer_Excel2007_WriterPart
37. {
38. /**
39. * Write docProps/app.xml to XML format
40. *
41. * @param PHPExcel $pPHPExcel
42. * @return string XML Output
43. * @throws Exception
44. */
45. public function writeDocPropsApp(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. }
55. // XML header
56. $objWriter->startDocument('1.0','UTF-8','yes');
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');
63. // Application
64. $objWriter->writeElement('Application', 'Microsoft Excel');
66. // DocSecurity
67. $objWriter->writeElement('DocSecurity', '0');
69. // ScaleCrop
70. $objWriter->writeElement('ScaleCrop', 'false');
72. // HeadingPairs
73. $objWriter->startElement('HeadingPairs');
75. // Vector
76. $objWriter->startElement('vt:vector');
77. $objWriter->writeAttribute('size', '2');
78. $objWriter->writeAttribute('baseType', 'variant');
80. // Variant
81. $objWriter->startElement('vt:variant');
82. $objWriter->writeElement('vt:lpstr', 'Worksheets');
83. $objWriter->endElement();
85. // Variant
86. $objWriter->startElement('vt:variant');
87. $objWriter->writeElement('vt:i4', $pPHPExcel->getSheetCount());
88. $objWriter->endElement();
90. $objWriter->endElement();
92. $objWriter->endElement();
94. // TitlesOfParts
95. $objWriter->startElement('TitlesOfParts');
97. // Vector
98. $objWriter->startElement('vt:vector');
99. $objWriter->writeAttribute('size', $pPHPExcel->getSheetCount());
100. $objWriter->writeAttribute('baseType', 'lpstr');
102. $sheetCount = $pPHPExcel->getSheetCount();
103. for ($i = 0; $i < $sheetCount; ++$i) {
104. $objWriter->writeElement('vt:lpstr', $pPHPExcel->getSheet($i)->getTitle());
105. }
107. $objWriter->endElement();
109. $objWriter->endElement();
111. // Company
112. $objWriter->writeElement('Company', $pPHPExcel->getProperties()->getCompany());
114. // Company
115. $objWriter->writeElement('Manager', $pPHPExcel->getProperties()->getManager());
117. // LinksUpToDate
118. $objWriter->writeElement('LinksUpToDate', 'false');
120. // SharedDoc
121. $objWriter->writeElement('SharedDoc', 'false');
123. // HyperlinksChanged
124. $objWriter->writeElement('HyperlinksChanged', 'false');
126. // AppVersion
127. $objWriter->writeElement('AppVersion', '12.0000');
129. $objWriter->endElement();
131. // Return
132. return $objWriter->getData();
133. }
135. /**
136. * Write docProps/core.xml to XML format
137. *
138. * @param PHPExcel $pPHPExcel
139. * @return string XML Output
140. * @throws Exception
141. */
142. public function writeDocPropsCore(PHPExcel $pPHPExcel = null)
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. }
152. // XML header
153. $objWriter->startDocument('1.0','UTF-8','yes');
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');
163. // dc:creator
164. $objWriter->writeElement('dc:creator', $pPHPExcel->getProperties()->getCreator());
166. // cp:lastModifiedBy
167. $objWriter->writeElement('cp:lastModifiedBy', $pPHPExcel->getProperties()->getLastModifiedBy());
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();
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();
181. // dc:title
182. $objWriter->writeElement('dc:title', $pPHPExcel->getProperties()->getTitle());
184. // dc:description
185. $objWriter->writeElement('dc:description', $pPHPExcel->getProperties()->getDescription());
187. // dc:subject
188. $objWriter->writeElement('dc:subject', $pPHPExcel->getProperties()->getSubject());
190. // cp:keywords
191. $objWriter->writeElement('cp:keywords', $pPHPExcel->getProperties()->getKeywords());
193. // cp:category
194. $objWriter->writeElement('cp:category', $pPHPExcel->getProperties()->getCategory());
196. $objWriter->endElement();
198. // Return
199. return $objWriter->getData();
200. }
202. /**
203. * Write docProps/custom.xml to XML format
204. *
205. * @param PHPExcel $pPHPExcel
206. * @return string XML Output
207. * @throws Exception
208. */
209. public function writeDocPropsCustom(PHPExcel $pPHPExcel = null)
210. {
211. $customPropertyList = $pPHPExcel->getProperties()->getCustomProperties();
212. if ( count($customPropertyList) == 0) {
213. return;
214. }
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. }
224. // XML header
225. $objWriter->startDocument('1.0','UTF-8','yes');
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');
233. foreach($customPropertyList as $key => $customProperty) {
234. $propertyValue = $pPHPExcel->getProperties()->getCustomPropertyValue($customProperty);
235. $propertyType = $pPHPExcel->getProperties()->getCustomPropertyType($customProperty);
237. $objWriter->startElement('property');
238. $objWriter->writeAttribute('fmtid', '{D5CDD505-2E9C-101B-9397-08002B2CF9AE}');
239. $objWriter->writeAttribute('pid', $key+2);
240. $objWriter->writeAttribute('name', $customProperty);
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. }
262. $objWriter->endElement();
263. }
266. $objWriter->endElement();
268. // Return
269. return $objWriter->getData();
270. }
272. }

Documentation generated on Sun, 27 Feb 2011 16:30:12 -0800 by phpDocumentor 1.4.3