ILIAS  release_5-2 Revision v5.2.25-18-g3f80b828510
Public Member Functions | Private Member Functions
PHPExcel_Writer_Excel2007_Workbook Class Reference
+ Inheritance diagram for PHPExcel_Writer_Excel2007_Workbook:
+ Collaboration diagram for PHPExcel_Writer_Excel2007_Workbook:

Public Member Functions

 writeWorkbook (PHPExcel $pPHPExcel=null, $recalcRequired=FALSE)
 Write workbook 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...
 

Private Member Functions

 _writeFileVersion (PHPExcel_Shared_XMLWriter $objWriter=null)
 Write file version. More...
 
 _writeWorkbookPr (PHPExcel_Shared_XMLWriter $objWriter=null)
 Write WorkbookPr. More...
 
 _writeBookViews (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel=null)
 Write BookViews. More...
 
 _writeWorkbookProtection (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel=null)
 Write WorkbookProtection. More...
 
 _writeCalcPr (PHPExcel_Shared_XMLWriter $objWriter=null, $recalcRequired=TRUE)
 Write calcPr. More...
 
 _writeSheets (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel=null)
 Write sheets. More...
 
 _writeSheet (PHPExcel_Shared_XMLWriter $objWriter=null, $pSheetname='', $pSheetId=1, $pRelId=1, $sheetState='visible')
 Write sheet. More...
 
 _writeDefinedNames (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel=null)
 Write Defined Names. More...
 
 _writeNamedRanges (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel)
 Write named ranges. More...
 
 _writeDefinedNameForNamedRange (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_NamedRange $pNamedRange)
 Write Defined Name for named range. More...
 
 _writeDefinedNameForAutofilter (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pSheetId=0)
 Write Defined Name for autoFilter. More...
 
 _writeDefinedNameForPrintTitles (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pSheetId=0)
 Write Defined Name for PrintTitles. More...
 
 _writeDefinedNameForPrintArea (PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pSheetId=0)
 Write Defined Name for PrintTitles. More...
 

Detailed Description

Definition at line 36 of file Workbook.php.

Member Function Documentation

◆ _writeBookViews()

PHPExcel_Writer_Excel2007_Workbook::_writeBookViews ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel  $pPHPExcel = null 
)
private

Write BookViews.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel$pPHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 136 of file Workbook.php.

137 {
138 // bookViews
139 $objWriter->startElement('bookViews');
140
141 // workbookView
142 $objWriter->startElement('workbookView');
143
144 $objWriter->writeAttribute('activeTab', $pPHPExcel->getActiveSheetIndex());
145 $objWriter->writeAttribute('autoFilterDateGrouping', '1');
146 $objWriter->writeAttribute('firstSheet', '0');
147 $objWriter->writeAttribute('minimized', '0');
148 $objWriter->writeAttribute('showHorizontalScroll', '1');
149 $objWriter->writeAttribute('showSheetTabs', '1');
150 $objWriter->writeAttribute('showVerticalScroll', '1');
151 $objWriter->writeAttribute('tabRatio', '600');
152 $objWriter->writeAttribute('visibility', 'visible');
153
154 $objWriter->endElement();
155
156 $objWriter->endElement();
157 }
$objWriter
$objWriter
Definition: 01pharSimple.php:81
PHPExcel\getActiveSheetIndex
getActiveSheetIndex()
Get active sheet index.
Definition: PHPExcel.php:671

References $objWriter.

Referenced by writeWorkbook().

+ Here is the caller graph for this function:

◆ _writeCalcPr()

PHPExcel_Writer_Excel2007_Workbook::_writeCalcPr ( PHPExcel_Shared_XMLWriter  $objWriter = null,
  $recalcRequired = TRUE 
)
private

Write calcPr.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
boolean$recalcRequiredIndicate whether formulas should be recalculated before writing
Exceptions
PHPExcel_Writer_Exception

Definition at line 193 of file Workbook.php.

194 {
195 $objWriter->startElement('calcPr');
196
197 // Set the calcid to a higher value than Excel itself will use, otherwise Excel will always recalc
198 // If MS Excel does do a recalc, then users opening a file in MS Excel will be prompted to save on exit
199 // because the file has changed
200 $objWriter->writeAttribute('calcId', '999999');
201 $objWriter->writeAttribute('calcMode', 'auto');
202 // fullCalcOnLoad isn't needed if we've recalculating for the save
203 $objWriter->writeAttribute('calcCompleted', ($recalcRequired) ? 1 : 0);
204 $objWriter->writeAttribute('fullCalcOnLoad', ($recalcRequired) ? 0 : 1);
205
206 $objWriter->endElement();
207 }

References $objWriter.

Referenced by writeWorkbook().

+ Here is the caller graph for this function:

◆ _writeDefinedNameForAutofilter()

PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForAutofilter ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null,
  $pSheetId = 0 
)
private

Write Defined Name for autoFilter.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheet
int$pSheetId
Exceptions
PHPExcel_Writer_Exception

Definition at line 351 of file Workbook.php.

352 {
353 // definedName for autoFilter
354 $autoFilterRange = $pSheet->getAutoFilter()->getRange();
355 if (!empty($autoFilterRange)) {
356 $objWriter->startElement('definedName');
357 $objWriter->writeAttribute('name', '_xlnm._FilterDatabase');
358 $objWriter->writeAttribute('localSheetId', $pSheetId);
359 $objWriter->writeAttribute('hidden', '1');
360
361 // Create absolute coordinate and write as raw text
362 $range = PHPExcel_Cell::splitRange($autoFilterRange);
363 $range = $range[0];
364 // Strip any worksheet ref so we can make the cell ref absolute
365 if (strpos($range[0],'!') !== false) {
366 list($ws,$range[0]) = explode('!',$range[0]);
367 }
368
369 $range[0] = PHPExcel_Cell::absoluteCoordinate($range[0]);
370 $range[1] = PHPExcel_Cell::absoluteCoordinate($range[1]);
371 $range = implode(':', $range);
372
373 $objWriter->writeRawData('\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!' . $range);
374
375 $objWriter->endElement();
376 }
377 }
PHPExcel_Cell\absoluteCoordinate
static absoluteCoordinate($pCoordinateString='A1')
Make string coordinate absolute.
Definition: Cell.php:631
PHPExcel_Cell\splitRange
static splitRange($pRange='A1:A1')
Split range into coordinate strings.
Definition: Cell.php:660
PHPExcel_Worksheet\getAutoFilter
getAutoFilter()
Get Autofilter.
Definition: Worksheet.php:1892
PHPExcel_Worksheet\getTitle
getTitle()
Get title.
Definition: Worksheet.php:817

Referenced by _writeDefinedNames().

+ Here is the caller graph for this function:

◆ _writeDefinedNameForNamedRange()

PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForNamedRange ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_NamedRange  $pNamedRange 
)
private

Write Defined Name for named range.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_NamedRange$pNamedRange
Exceptions
PHPExcel_Writer_Exception

Definition at line 319 of file Workbook.php.

320 {
321 // definedName for named range
322 $objWriter->startElement('definedName');
323 $objWriter->writeAttribute('name', $pNamedRange->getName());
324 if ($pNamedRange->getLocalOnly()) {
325 $objWriter->writeAttribute('localSheetId', $pNamedRange->getScope()->getParent()->getIndex($pNamedRange->getScope()));
326 }
327
328 // Create absolute coordinate and write as raw text
329 $range = PHPExcel_Cell::splitRange($pNamedRange->getRange());
330 for ($i = 0; $i < count($range); $i++) {
331 $range[$i][0] = '\'' . str_replace("'", "''", $pNamedRange->getWorksheet()->getTitle()) . '\'!' . PHPExcel_Cell::absoluteReference($range[$i][0]);
332 if (isset($range[$i][1])) {
333 $range[$i][1] = PHPExcel_Cell::absoluteReference($range[$i][1]);
334 }
335 }
336 $range = PHPExcel_Cell::buildRange($range);
337
338 $objWriter->writeRawData($range);
339
340 $objWriter->endElement();
341 }
PHPExcel_NamedRange\getLocalOnly
getLocalOnly()
Get localOnly.
Definition: NamedRange.php:185
PHPExcel_NamedRange\getName
getName()
Get name.
Definition: NamedRange.php:104
PHPExcel_NamedRange\getScope
getScope()
Get scope.
Definition: NamedRange.php:206
PHPExcel_NamedRange\getRange
getRange()
Get range.
Definition: NamedRange.php:163
PHPExcel_NamedRange\getWorksheet
getWorksheet()
Get worksheet.
Definition: NamedRange.php:141

References $objWriter, PHPExcel_NamedRange\getLocalOnly(), PHPExcel_NamedRange\getName(), PHPExcel_NamedRange\getRange(), PHPExcel_NamedRange\getScope(), PHPExcel_NamedRange\getWorksheet(), and PHPExcel_Cell\splitRange().

Referenced by _writeNamedRanges().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeDefinedNameForPrintArea()

PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForPrintArea ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null,
  $pSheetId = 0 
)
private

Write Defined Name for PrintTitles.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheet
int$pSheetId
Exceptions
PHPExcel_Writer_Exception

Definition at line 430 of file Workbook.php.

431 {
432 // definedName for PrintArea
433 if ($pSheet->getPageSetup()->isPrintAreaSet()) {
434 $objWriter->startElement('definedName');
435 $objWriter->writeAttribute('name', '_xlnm.Print_Area');
436 $objWriter->writeAttribute('localSheetId', $pSheetId);
437
438 // Setting string
439 $settingString = '';
440
441 // Print area
442 $printArea = PHPExcel_Cell::splitRange($pSheet->getPageSetup()->getPrintArea());
443
444 $chunks = array();
445 foreach ($printArea as $printAreaRect) {
446 $printAreaRect[0] = PHPExcel_Cell::absoluteReference($printAreaRect[0]);
447 $printAreaRect[1] = PHPExcel_Cell::absoluteReference($printAreaRect[1]);
448 $chunks[] = '\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!' . implode(':', $printAreaRect);
449 }
450
451 $objWriter->writeRawData(implode(',', $chunks));
452
453 $objWriter->endElement();
454 }
455 }
PHPExcel_Cell\absoluteReference
static absoluteReference($pCoordinateString='A1')
Make string row, column or cell coordinate absolute.
Definition: Cell.php:601
PHPExcel_Worksheet\getPageSetup
getPageSetup()
Get page setup.
Definition: Worksheet.php:914

Referenced by _writeDefinedNames().

+ Here is the caller graph for this function:

◆ _writeDefinedNameForPrintTitles()

PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForPrintTitles ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel_Worksheet  $pSheet = null,
  $pSheetId = 0 
)
private

Write Defined Name for PrintTitles.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel_Worksheet$pSheet
int$pSheetId
Exceptions
PHPExcel_Writer_Exception

Definition at line 387 of file Workbook.php.

388 {
389 // definedName for PrintTitles
390 if ($pSheet->getPageSetup()->isColumnsToRepeatAtLeftSet() || $pSheet->getPageSetup()->isRowsToRepeatAtTopSet()) {
391 $objWriter->startElement('definedName');
392 $objWriter->writeAttribute('name', '_xlnm.Print_Titles');
393 $objWriter->writeAttribute('localSheetId', $pSheetId);
394
395 // Setting string
396 $settingString = '';
397
398 // Columns to repeat
399 if ($pSheet->getPageSetup()->isColumnsToRepeatAtLeftSet()) {
400 $repeat = $pSheet->getPageSetup()->getColumnsToRepeatAtLeft();
401
402 $settingString .= '\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!$' . $repeat[0] . ':$' . $repeat[1];
403 }
404
405 // Rows to repeat
406 if ($pSheet->getPageSetup()->isRowsToRepeatAtTopSet()) {
407 if ($pSheet->getPageSetup()->isColumnsToRepeatAtLeftSet()) {
408 $settingString .= ',';
409 }
410
411 $repeat = $pSheet->getPageSetup()->getRowsToRepeatAtTop();
412
413 $settingString .= '\'' . str_replace("'", "''", $pSheet->getTitle()) . '\'!$' . $repeat[0] . ':$' . $repeat[1];
414 }
415
416 $objWriter->writeRawData($settingString);
417
418 $objWriter->endElement();
419 }
420 }

Referenced by _writeDefinedNames().

+ Here is the caller graph for this function:

◆ _writeDefinedNames()

PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNames ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel  $pPHPExcel = null 
)
private

Write Defined Names.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel$pPHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 269 of file Workbook.php.

270 {
271 // Write defined names
272 $objWriter->startElement('definedNames');
273
274 // Named ranges
275 if (count($pPHPExcel->getNamedRanges()) > 0) {
276 // Named ranges
277 $this->_writeNamedRanges($objWriter, $pPHPExcel);
278 }
279
280 // Other defined names
281 $sheetCount = $pPHPExcel->getSheetCount();
282 for ($i = 0; $i < $sheetCount; ++$i) {
283 // definedName for autoFilter
284 $this->_writeDefinedNameForAutofilter($objWriter, $pPHPExcel->getSheet($i), $i);
285
286 // definedName for Print_Titles
287 $this->_writeDefinedNameForPrintTitles($objWriter, $pPHPExcel->getSheet($i), $i);
288
289 // definedName for Print_Area
290 $this->_writeDefinedNameForPrintArea($objWriter, $pPHPExcel->getSheet($i), $i);
291 }
292
293 $objWriter->endElement();
294 }
PHPExcel_Writer_Excel2007_Workbook\_writeDefinedNameForPrintArea
_writeDefinedNameForPrintArea(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pSheetId=0)
Write Defined Name for PrintTitles.
Definition: Workbook.php:430
PHPExcel_Writer_Excel2007_Workbook\_writeDefinedNameForPrintTitles
_writeDefinedNameForPrintTitles(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pSheetId=0)
Write Defined Name for PrintTitles.
Definition: Workbook.php:387
PHPExcel_Writer_Excel2007_Workbook\_writeDefinedNameForAutofilter
_writeDefinedNameForAutofilter(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_Worksheet $pSheet=null, $pSheetId=0)
Write Defined Name for autoFilter.
Definition: Workbook.php:351
PHPExcel_Writer_Excel2007_Workbook\_writeNamedRanges
_writeNamedRanges(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel)
Write named ranges.
Definition: Workbook.php:303
PHPExcel\getSheetCount
getSheetCount()
Get sheet count.
Definition: PHPExcel.php:661
PHPExcel\getNamedRanges
getNamedRanges()
Get named ranges.
Definition: PHPExcel.php:768
PHPExcel\getSheet
getSheet($pIndex=0)
Get sheet by index.
Definition: PHPExcel.php:573

References $objWriter, _writeDefinedNameForAutofilter(), _writeDefinedNameForPrintArea(), _writeDefinedNameForPrintTitles(), and _writeNamedRanges().

Referenced by writeWorkbook().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeFileVersion()

PHPExcel_Writer_Excel2007_Workbook::_writeFileVersion ( PHPExcel_Shared_XMLWriter  $objWriter = null)
private

Write file version.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
Exceptions
PHPExcel_Writer_Exception

Definition at line 100 of file Workbook.php.

101 {
102 $objWriter->startElement('fileVersion');
103 $objWriter->writeAttribute('appName', 'xl');
104 $objWriter->writeAttribute('lastEdited', '4');
105 $objWriter->writeAttribute('lowestEdited', '4');
106 $objWriter->writeAttribute('rupBuild', '4505');
107 $objWriter->endElement();
108 }

References $objWriter.

Referenced by writeWorkbook().

+ Here is the caller graph for this function:

◆ _writeNamedRanges()

PHPExcel_Writer_Excel2007_Workbook::_writeNamedRanges ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel  $pPHPExcel 
)
private

Write named ranges.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel$pPHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 303 of file Workbook.php.

304 {
305 // Loop named ranges
306 $namedRanges = $pPHPExcel->getNamedRanges();
307 foreach ($namedRanges as $namedRange) {
308 $this->_writeDefinedNameForNamedRange($objWriter, $namedRange);
309 }
310 }
PHPExcel_Writer_Excel2007_Workbook\_writeDefinedNameForNamedRange
_writeDefinedNameForNamedRange(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel_NamedRange $pNamedRange)
Write Defined Name for named range.
Definition: Workbook.php:319

References $objWriter, _writeDefinedNameForNamedRange(), and PHPExcel\getNamedRanges().

Referenced by _writeDefinedNames().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeSheet()

PHPExcel_Writer_Excel2007_Workbook::_writeSheet ( PHPExcel_Shared_XMLWriter  $objWriter = null,
  $pSheetname = '',
  $pSheetId = 1,
  $pRelId = 1,
  $sheetState = 'visible' 
)
private

Write sheet.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
string$pSheetnameSheet name
int$pSheetIdSheet id
int$pRelIdRelationship ID
string$sheetStateSheet state (visible, hidden, veryHidden)
Exceptions
PHPExcel_Writer_Exception

Definition at line 245 of file Workbook.php.

246 {
247 if ($pSheetname != '') {
248 // Write sheet
249 $objWriter->startElement('sheet');
250 $objWriter->writeAttribute('name', $pSheetname);
251 $objWriter->writeAttribute('sheetId', $pSheetId);
252 if ($sheetState != 'visible' && $sheetState != '') {
253 $objWriter->writeAttribute('state', $sheetState);
254 }
255 $objWriter->writeAttribute('r:id', 'rId' . $pRelId);
256 $objWriter->endElement();
257 } else {
258 throw new PHPExcel_Writer_Exception("Invalid parameters passed.");
259 }
260 }
PHPExcel_Writer_Exception
Definition: Exception.php:36

References $objWriter.

Referenced by _writeSheets().

+ Here is the caller graph for this function:

◆ _writeSheets()

PHPExcel_Writer_Excel2007_Workbook::_writeSheets ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel  $pPHPExcel = null 
)
private

Write sheets.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel$pPHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 216 of file Workbook.php.

217 {
218 // Write sheets
219 $objWriter->startElement('sheets');
220 $sheetCount = $pPHPExcel->getSheetCount();
221 for ($i = 0; $i < $sheetCount; ++$i) {
222 // sheet
223 $this->_writeSheet(
224 $objWriter,
225 $pPHPExcel->getSheet($i)->getTitle(),
226 ($i + 1),
227 ($i + 1 + 3),
228 $pPHPExcel->getSheet($i)->getSheetState()
229 );
230 }
231
232 $objWriter->endElement();
233 }
PHPExcel_Writer_Excel2007_Workbook\_writeSheet
_writeSheet(PHPExcel_Shared_XMLWriter $objWriter=null, $pSheetname='', $pSheetId=1, $pRelId=1, $sheetState='visible')
Write sheet.
Definition: Workbook.php:245

References $objWriter, and _writeSheet().

Referenced by writeWorkbook().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeWorkbookPr()

PHPExcel_Writer_Excel2007_Workbook::_writeWorkbookPr ( PHPExcel_Shared_XMLWriter  $objWriter = null)
private

Write WorkbookPr.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
Exceptions
PHPExcel_Writer_Exception

Definition at line 116 of file Workbook.php.

117 {
118 $objWriter->startElement('workbookPr');
119
120 if (PHPExcel_Shared_Date::getExcelCalendar() == PHPExcel_Shared_Date::CALENDAR_MAC_1904) {
121 $objWriter->writeAttribute('date1904', '1');
122 }
123
124 $objWriter->writeAttribute('codeName', 'ThisWorkbook');
125
126 $objWriter->endElement();
127 }
PHPExcel_Shared_Date\CALENDAR_MAC_1904
const CALENDAR_MAC_1904
Definition: Date.php:41
PHPExcel_Shared_Date\getExcelCalendar
static getExcelCalendar()
Return the Excel calendar (Windows 1900 or Mac 1904)
Definition: Date.php:106

References $objWriter, PHPExcel_Shared_Date\CALENDAR_MAC_1904, and PHPExcel_Shared_Date\getExcelCalendar().

Referenced by writeWorkbook().

+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ _writeWorkbookProtection()

PHPExcel_Writer_Excel2007_Workbook::_writeWorkbookProtection ( PHPExcel_Shared_XMLWriter  $objWriter = null,
PHPExcel  $pPHPExcel = null 
)
private

Write WorkbookProtection.

Parameters
PHPExcel_Shared_XMLWriter$objWriterXML Writer
PHPExcel$pPHPExcel
Exceptions
PHPExcel_Writer_Exception

Definition at line 166 of file Workbook.php.

167 {
168 if ($pPHPExcel->getSecurity()->isSecurityEnabled()) {
169 $objWriter->startElement('workbookProtection');
170 $objWriter->writeAttribute('lockRevision', ($pPHPExcel->getSecurity()->getLockRevision() ? 'true' : 'false'));
171 $objWriter->writeAttribute('lockStructure', ($pPHPExcel->getSecurity()->getLockStructure() ? 'true' : 'false'));
172 $objWriter->writeAttribute('lockWindows', ($pPHPExcel->getSecurity()->getLockWindows() ? 'true' : 'false'));
173
174 if ($pPHPExcel->getSecurity()->getRevisionsPassword() != '') {
175 $objWriter->writeAttribute('revisionsPassword', $pPHPExcel->getSecurity()->getRevisionsPassword());
176 }
177
178 if ($pPHPExcel->getSecurity()->getWorkbookPassword() != '') {
179 $objWriter->writeAttribute('workbookPassword', $pPHPExcel->getSecurity()->getWorkbookPassword());
180 }
181
182 $objWriter->endElement();
183 }
184 }
PHPExcel\getSecurity
getSecurity()
Get security.
Definition: PHPExcel.php:445

References $objWriter.

Referenced by writeWorkbook().

+ Here is the caller graph for this function:

◆ writeWorkbook()

PHPExcel_Writer_Excel2007_Workbook::writeWorkbook ( PHPExcel  $pPHPExcel = null,
  $recalcRequired = FALSE 
)

Write workbook to XML format.

Parameters
PHPExcel$pPHPExcel
boolean$recalcRequiredIndicate whether formulas should be recalculated before writing
Returns
string XML Output
Exceptions
PHPExcel_Writer_Exception

Definition at line 46 of file Workbook.php.

47 {
48 // Create XML writer
49 $objWriter = null;
50 if ($this->getParentWriter()->getUseDiskCaching()) {
51 $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_DISK, $this->getParentWriter()->getDiskCachingDirectory());
52 } else {
53 $objWriter = new PHPExcel_Shared_XMLWriter(PHPExcel_Shared_XMLWriter::STORAGE_MEMORY);
54 }
55
56 // XML header
57 $objWriter->startDocument('1.0','UTF-8','yes');
58
59 // workbook
60 $objWriter->startElement('workbook');
61 $objWriter->writeAttribute('xml:space', 'preserve');
62 $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/spreadsheetml/2006/main');
63 $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
64
65 // fileVersion
66 $this->_writeFileVersion($objWriter);
67
68 // workbookPr
69 $this->_writeWorkbookPr($objWriter);
70
71 // workbookProtection
72 $this->_writeWorkbookProtection($objWriter, $pPHPExcel);
73
74 // bookViews
75 if ($this->getParentWriter()->getOffice2003Compatibility() === false) {
76 $this->_writeBookViews($objWriter, $pPHPExcel);
77 }
78
79 // sheets
80 $this->_writeSheets($objWriter, $pPHPExcel);
81
82 // definedNames
83 $this->_writeDefinedNames($objWriter, $pPHPExcel);
84
85 // calcPr
86 $this->_writeCalcPr($objWriter,$recalcRequired);
87
88 $objWriter->endElement();
89
90 // Return
91 return $objWriter->getData();
92 }
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_Workbook\_writeCalcPr
_writeCalcPr(PHPExcel_Shared_XMLWriter $objWriter=null, $recalcRequired=TRUE)
Write calcPr.
Definition: Workbook.php:193
PHPExcel_Writer_Excel2007_Workbook\_writeWorkbookPr
_writeWorkbookPr(PHPExcel_Shared_XMLWriter $objWriter=null)
Write WorkbookPr.
Definition: Workbook.php:116
PHPExcel_Writer_Excel2007_Workbook\_writeBookViews
_writeBookViews(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel=null)
Write BookViews.
Definition: Workbook.php:136
PHPExcel_Writer_Excel2007_Workbook\_writeWorkbookProtection
_writeWorkbookProtection(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel=null)
Write WorkbookProtection.
Definition: Workbook.php:166
PHPExcel_Writer_Excel2007_Workbook\_writeFileVersion
_writeFileVersion(PHPExcel_Shared_XMLWriter $objWriter=null)
Write file version.
Definition: Workbook.php:100
PHPExcel_Writer_Excel2007_Workbook\_writeDefinedNames
_writeDefinedNames(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel=null)
Write Defined Names.
Definition: Workbook.php:269
PHPExcel_Writer_Excel2007_Workbook\_writeSheets
_writeSheets(PHPExcel_Shared_XMLWriter $objWriter=null, PHPExcel $pPHPExcel=null)
Write sheets.
Definition: Workbook.php:216
PHPExcel_Writer_Excel2007_WriterPart\getParentWriter
getParentWriter()
Get parent IWriter object.
Definition: WriterPart.php:61

References $objWriter, _writeBookViews(), _writeCalcPr(), _writeDefinedNames(), _writeFileVersion(), _writeSheets(), _writeWorkbookPr(), _writeWorkbookProtection(), 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: