Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 3.9.x will end* 10 May 2021 (12 months).
  • Bug fixes for security issues in 3.9.x will end* 8 May 2023 (36 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 39 and 311] [Versions 39 and 400] [Versions 39 and 401] [Versions 39 and 402] [Versions 39 and 403]

(no description)

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

Defines 1 class


Class: Worksheet  - X-Ref


writeWorksheet(PhpspreadsheetWorksheet $pSheet, $pStringTable = null, $includeCharts = false)   X-Ref
Write worksheet to XML format.

param: PhpspreadsheetWorksheet $pSheet
param: string[] $pStringTable
param: bool $includeCharts Flag indicating if we should write charts
return: string XML Output

writeSheetPr(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write SheetPr.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeDimension(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write Dimension.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeSheetViews(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write SheetViews.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeSheetFormatPr(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write SheetFormatPr.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeCols(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write Cols.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeSheetProtection(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write SheetProtection.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeConditionalFormatting(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write ConditionalFormatting.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeDataValidations(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write DataValidations.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeHyperlinks(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write Hyperlinks.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeProtectedRanges(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write ProtectedRanges.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeMergeCells(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write MergeCells.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writePrintOptions(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write PrintOptions.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writePageMargins(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write PageMargins.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeAutoFilter(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write AutoFilter.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writePageSetup(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write PageSetup.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeHeaderFooter(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write Header / Footer.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeBreaks(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write Breaks.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeSheetData(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet, array $pStringTable)   X-Ref
Write SheetData.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet
param: string[] $pStringTable String table

writeCell(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet, $pCellAddress, array $pFlippedStringTable)   X-Ref
Write Cell.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet
param: Cell $pCellAddress Cell Address
param: string[] $pFlippedStringTable String table (flipped), for faster index searching

writeDrawings(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet, $includeCharts = false)   X-Ref
Write Drawings.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet
param: bool $includeCharts Flag indicating if we should include drawing details for charts

writeLegacyDrawing(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write LegacyDrawing.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeLegacyDrawingHF(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
Write LegacyDrawingHF.

param: XMLWriter $objWriter XML Writer
param: PhpspreadsheetWorksheet $pSheet Worksheet

writeAlternateContent(XMLWriter $objWriter, PhpspreadsheetWorksheet $pSheet)   X-Ref
No description