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.
/lib/spout/src/Spout/Writer/XLSX/Manager/ -> WorksheetManager.php (source)

[Source view]

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

(no description)

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

Defines 1 class

WorksheetManager:: (10 methods):
  __construct()
  getSharedStringsManager()
  startSheet()
  throwIfSheetFilePointerIsNotAvailable()
  addRow()
  addNonEmptyRow()
  applyStyleAndGetCellXML()
  getCellXML()
  getCellXMLFragmentForNonEmptyString()
  close()


Class: WorksheetManager  - X-Ref

Class WorksheetManager
XLSX worksheet manager, providing the interfaces to work with XLSX worksheets.

__construct(OptionsManagerInterface $optionsManager,RowManager $rowManager,StyleManager $styleManager,StyleMerger $styleMerger,SharedStringsManager $sharedStringsManager,XLSXEscaper $stringsEscaper,StringHelper $stringHelper,InternalEntityFactory $entityFactory)   X-Ref
WorksheetManager constructor.

param: OptionsManagerInterface $optionsManager
param: RowManager $rowManager
param: StyleManager $styleManager
param: StyleMerger $styleMerger
param: SharedStringsManager $sharedStringsManager
param: XLSXEscaper $stringsEscaper
param: StringHelper $stringHelper
param: InternalEntityFactory $entityFactory

getSharedStringsManager()   X-Ref

return: SharedStringsManager

startSheet(Worksheet $worksheet)   X-Ref
{@inheritdoc}


throwIfSheetFilePointerIsNotAvailable($sheetFilePointer)   X-Ref
Checks if the sheet has been sucessfully created. Throws an exception if not.

param: bool|resource $sheetFilePointer Pointer to the sheet data file or FALSE if unable to open the file
return: void

addRow(Worksheet $worksheet, Row $row)   X-Ref
{@inheritdoc}


addNonEmptyRow(Worksheet $worksheet, Row $row)   X-Ref
Adds non empty row to the worksheet.

param: Worksheet $worksheet The worksheet to add the row to
param: Row $row The row to be written
return: void

applyStyleAndGetCellXML(Cell $cell, Style $rowStyle, $rowIndex, $cellIndex)   X-Ref
Applies styles to the given style, merging the cell's style with its row's style
Then builds and returns xml for the cell.

param: Cell $cell
param: Style $rowStyle
param: int $rowIndex
param: int $cellIndex
return: string

getCellXML($rowIndex, $cellNumber, Cell $cell, $styleId)   X-Ref
Builds and returns xml for a single cell.

param: int $rowIndex
param: int $cellNumber
param: Cell $cell
param: int $styleId
return: string

getCellXMLFragmentForNonEmptyString($cellValue)   X-Ref
Returns the XML fragment for a cell containing a non empty string

param: string $cellValue The cell value
return: string The XML fragment representing the cell

close(Worksheet $worksheet)   X-Ref
{@inheritdoc}