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.

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

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  }
PHPExcel\getSheetCount
getSheetCount()
Get sheet count.
Definition: PHPExcel.php:661
PHPExcel\getProperties
getProperties()
Get properties.
Definition: PHPExcel.php:425
PHPExcel_Writer_Excel2007_WriterPart\getParentWriter
getParentWriter()
Get parent IWriter object.
Definition: WriterPart.php:61
$objWriter
$objWriter
Definition: 01pharSimple.php:81
PHPExcel_Shared_XMLWriter\STORAGE_DISK
const STORAGE_DISK
Definition: XMLWriter.php:47
$i
$i
Definition: disco.tpl.php:19
PHPExcel\getSheet
getSheet($pIndex=0)
Get sheet by index.
Definition: PHPExcel.php:573
PHPExcel_Shared_XMLWriter\STORAGE_MEMORY
const STORAGE_MEMORY
Temporary storage method.
Definition: XMLWriter.php:46
PHPExcel_Shared_XMLWriter
Definition: XMLWriter.php:44
+ 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.

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

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  }
PHPExcel\getProperties
getProperties()
Get properties.
Definition: PHPExcel.php:425
PHPExcel_Writer_Excel2007_WriterPart\getParentWriter
getParentWriter()
Get parent IWriter object.
Definition: WriterPart.php:61
$objWriter
$objWriter
Definition: 01pharSimple.php:81
date
date( 'd-M-Y', $objPHPExcel->getProperties() ->getCreated())
Definition: 31docproperties_write-xls.php:86
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_Shared_XMLWriter
Definition: XMLWriter.php:44
+ 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.

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

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  }
PHPExcel\getProperties
getProperties()
Get properties.
Definition: PHPExcel.php:425
PHPExcel_Writer_Excel2007_WriterPart\getParentWriter
getParentWriter()
Get parent IWriter object.
Definition: WriterPart.php:61
$objWriter
$objWriter
Definition: 01pharSimple.php:81
date
date( 'd-M-Y', $objPHPExcel->getProperties() ->getCreated())
Definition: 31docproperties_write-xls.php:86
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
$key
$key
Definition: croninfo.php:18
PHPExcel_Shared_XMLWriter
Definition: XMLWriter.php:44
+ Here is the call graph for this function:
The documentation for this class was generated from the following file: