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: 881 lines (35 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class


Class: Xml  - X-Ref

Reader for SpreadsheetML, the XML schema for Microsoft Office Excel 2003.

__construct()   X-Ref
Create a new Excel2003XML Reader instance.


canRead($pFilename)   X-Ref
Can the current IReader read the file?

param: string $pFilename
return: bool

trySimpleXMLLoadString($pFilename)   X-Ref
Check if the file is a valid SimpleXML.

param: string $pFilename
return: false|\SimpleXMLElement

listWorksheetNames($pFilename)   X-Ref
Reads names of the worksheets from a file, without parsing the whole file to a Spreadsheet object.

param: string $pFilename
return: array

listWorksheetInfo($pFilename)   X-Ref
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).

param: string $pFilename
return: array

load($pFilename)   X-Ref
Loads Spreadsheet from file.

param: string $pFilename
return: Spreadsheet

identifyFixedStyleValue($styleList, &$styleAttributeValue)   X-Ref
No description

pixel2WidthUnits($pxs)   X-Ref
pixel units to excel width units(units of 1/256th of a character width).

param: float $pxs
return: float

widthUnits2Pixel($widthUnits)   X-Ref
excel width units(units of 1/256th of a character width) to pixel units.

param: float $widthUnits
return: float

hex2str($hex)   X-Ref
No description

loadIntoExisting($pFilename, Spreadsheet $spreadsheet)   X-Ref
Loads from file into Spreadsheet instance.

param: string $pFilename
param: Spreadsheet $spreadsheet
return: Spreadsheet

convertStringEncoding($string, $charset)   X-Ref
No description

parseRichText($is)   X-Ref
No description

parseStyles(SimpleXMLElement $xml, array $namespaces)   X-Ref

param: SimpleXMLElement $xml
param: array $namespaces

parseStyleAlignment($styleID, SimpleXMLElement $styleAttributes)   X-Ref

param: string $styleID
param: SimpleXMLElement $styleAttributes

parseStyleBorders($styleID, SimpleXMLElement $styleData, array $namespaces)   X-Ref

param: $styleID
param: SimpleXMLElement $styleData
param: array $namespaces

parseStyleFont($styleID, SimpleXMLElement $styleAttributes)   X-Ref

param: $styleID
param: SimpleXMLElement $styleAttributes

parseStyleInterior($styleID, SimpleXMLElement $styleAttributes)   X-Ref

param: $styleID
param: SimpleXMLElement $styleAttributes

parseStyleNumberFormat($styleID, SimpleXMLElement $styleAttributes)   X-Ref

param: $styleID
param: SimpleXMLElement $styleAttributes