Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx/ -> Worksheet.php (source)

[Source view]

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

(no description)

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

Defines 1 class

Worksheet:: (40 methods):
  writeWorksheet()
  writeSheetPr()
  writeDimension()
  writeSheetViews()
  writeSheetFormatPr()
  writeCols()
  writeSheetProtection()
  writeAttributeIf()
  writeAttributeNotNull()
  writeElementIf()
  writeOtherCondElements()
  writeTimePeriodCondElements()
  writeTextCondElements()
  writeExtConditionalFormattingElements()
  writeDataBarElements()
  writeConditionalFormatting()
  writeDataValidations()
  writeHyperlinks()
  writeProtectedRanges()
  writeMergeCells()
  writePrintOptions()
  writePageMargins()
  writeAutoFilter()
  writeTable()
  writePageSetup()
  writeHeaderFooter()
  writeBreaks()
  writeSheetData()
  writeCellInlineStr()
  writeCellString()
  writeCellNumeric()
  writeCellBoolean()
  writeCellError()
  writeCellFormula()
  writeCell()
  writeDrawings()
  writeLegacyDrawing()
  writeLegacyDrawingHF()
  writeAlternateContent()
  writeExtLst()


Class: Worksheet  - X-Ref

writeWorksheet(PhpspreadsheetWorksheet $worksheet, $stringTable = [], $includeCharts = false)   X-Ref
Write worksheet to XML format.

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

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


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


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


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


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


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


writeAttributeIf(XMLWriter $objWriter, ?bool $condition, string $attr, string $val)   X-Ref
No description

writeAttributeNotNull(XMLWriter $objWriter, string $attr, ?string $val)   X-Ref
No description

writeElementIf(XMLWriter $objWriter, bool $condition, string $attr, string $val)   X-Ref
No description

writeOtherCondElements(XMLWriter $objWriter, Conditional $conditional, string $cellCoordinate)   X-Ref
No description

writeTimePeriodCondElements(XMLWriter $objWriter, Conditional $conditional, string $cellCoordinate)   X-Ref
No description

writeTextCondElements(XMLWriter $objWriter, Conditional $conditional, string $cellCoordinate)   X-Ref
No description

writeExtConditionalFormattingElements(XMLWriter $objWriter, ConditionalFormattingRuleExtension $ruleExtension)   X-Ref
No description

writeDataBarElements(XMLWriter $objWriter, ?ConditionalDataBar $dataBar)   X-Ref
No description

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


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


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


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


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


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


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


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


writeTable(XMLWriter $objWriter, PhpspreadsheetWorksheet $worksheet)   X-Ref
Write Table.


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


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


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


writeSheetData(XMLWriter $objWriter, PhpspreadsheetWorksheet $worksheet, array $stringTable)   X-Ref
Write SheetData.

param: string[] $stringTable String table

writeCellInlineStr(XMLWriter $objWriter, string $mappedType, $cellValue)   X-Ref

param: RichText|string $cellValue

writeCellString(XMLWriter $objWriter, string $mappedType, $cellValue, array $flippedStringTable)   X-Ref

param: RichText|string $cellValue
param: string[] $flippedStringTable

writeCellNumeric(XMLWriter $objWriter, $cellValue)   X-Ref

param: float|int $cellValue

writeCellBoolean(XMLWriter $objWriter, string $mappedType, bool $cellValue)   X-Ref
No description

writeCellError(XMLWriter $objWriter, string $mappedType, string $cellValue, string $formulaerr = ')   X-Ref
No description

writeCellFormula(XMLWriter $objWriter, string $cellValue, Cell $cell)   X-Ref
No description

writeCell(XMLWriter $objWriter, PhpspreadsheetWorksheet $worksheet, string $cellAddress, array $flippedStringTable)   X-Ref
Write Cell.

param: string $cellAddress Cell Address
param: string[] $flippedStringTable String table (flipped), for faster index searching

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

param: bool $includeCharts Flag indicating if we should include drawing details for charts

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


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


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

writeExtLst(XMLWriter $objWriter, PhpspreadsheetWorksheet $worksheet)   X-Ref
write <ExtLst>
only implementation conditionalFormattings.