Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.10.x will end 8 November 2021 (12 months).
  • Bug fixes for security issues in 3.10.x will end 9 May 2022 (18 months).
  • PHP version: minimum PHP 7.2.0 Note: minimum PHP version has increased since Moodle 3.8. PHP 7.3.x and 7.4.x are supported too.

Differences Between: [Versions 310 and 311] [Versions 310 and 400] [Versions 310 and 401] [Versions 310 and 402] [Versions 310 and 403]

(no description)

File Size: 426 lines (16 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class


Class: Workbook  - X-Ref

writeWorkbook(Spreadsheet $spreadsheet, $recalcRequired = false)   X-Ref
Write workbook to XML format.

param: Spreadsheet $spreadsheet
param: bool $recalcRequired Indicate whether formulas should be recalculated before writing
return: string XML Output

writeFileVersion(XMLWriter $objWriter)   X-Ref
Write file version.

param: XMLWriter $objWriter XML Writer

writeWorkbookPr(XMLWriter $objWriter)   X-Ref
Write WorkbookPr.

param: XMLWriter $objWriter XML Writer

writeBookViews(XMLWriter $objWriter, Spreadsheet $spreadsheet)   X-Ref
Write BookViews.

param: XMLWriter $objWriter XML Writer
param: Spreadsheet $spreadsheet

writeWorkbookProtection(XMLWriter $objWriter, Spreadsheet $spreadsheet)   X-Ref
Write WorkbookProtection.

param: XMLWriter $objWriter XML Writer
param: Spreadsheet $spreadsheet

writeCalcPr(XMLWriter $objWriter, $recalcRequired = true)   X-Ref
Write calcPr.

param: XMLWriter $objWriter XML Writer
param: bool $recalcRequired Indicate whether formulas should be recalculated before writing

writeSheets(XMLWriter $objWriter, Spreadsheet $spreadsheet)   X-Ref
Write sheets.

param: XMLWriter $objWriter XML Writer
param: Spreadsheet $spreadsheet

writeSheet(XMLWriter $objWriter, $pSheetname, $pSheetId = 1, $pRelId = 1, $sheetState = 'visible')   X-Ref
Write sheet.

param: XMLWriter $objWriter XML Writer
param: string $pSheetname Sheet name
param: int $pSheetId Sheet id
param: int $pRelId Relationship ID
param: string $sheetState Sheet state (visible, hidden, veryHidden)

writeDefinedNames(XMLWriter $objWriter, Spreadsheet $spreadsheet)   X-Ref
Write Defined Names.

param: XMLWriter $objWriter XML Writer
param: Spreadsheet $spreadsheet

writeNamedRanges(XMLWriter $objWriter, Spreadsheet $spreadsheet)   X-Ref
Write named ranges.

param: XMLWriter $objWriter XML Writer
param: Spreadsheet $spreadsheet

writeDefinedNameForNamedRange(XMLWriter $objWriter, NamedRange $pNamedRange)   X-Ref
Write Defined Name for named range.

param: XMLWriter $objWriter XML Writer
param: NamedRange $pNamedRange

writeDefinedNameForAutofilter(XMLWriter $objWriter, Worksheet $pSheet, $pSheetId = 0)   X-Ref
Write Defined Name for autoFilter.

param: XMLWriter $objWriter XML Writer
param: Worksheet $pSheet
param: int $pSheetId

writeDefinedNameForPrintTitles(XMLWriter $objWriter, Worksheet $pSheet, $pSheetId = 0)   X-Ref
Write Defined Name for PrintTitles.

param: XMLWriter $objWriter XML Writer
param: Worksheet $pSheet
param: int $pSheetId

writeDefinedNameForPrintArea(XMLWriter $objWriter, Worksheet $pSheet, $pSheetId = 0)   X-Ref
Write Defined Name for PrintTitles.

param: XMLWriter $objWriter XML Writer
param: Worksheet $pSheet
param: int $pSheetId