Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.3.x will end 7 October 2024 (12 months).
  • Bug fixes for security issues in 4.3.x will end 21 April 2025 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.2.x is supported too.

(no description)

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

Defines 1 class


Class: XLSX  - X-Ref


escape(string $string)   X-Ref
Escapes the given string to make it compatible with XLSX.

param: string $string The string to escape
return: string The escaped string

unescape(string $string)   X-Ref
Unescapes the given string to make it compatible with XLSX.

param: string $string The string to unescape
return: string The unescaped string

initIfNeeded()   X-Ref
Initializes the control characters if not already done.


getEscapableControlCharactersPattern()   X-Ref

return: string Regex pattern containing all escapable control characters

getControlCharactersEscapingMap()   X-Ref
Builds the map containing control characters to be escaped
mapped to their escaped values.
"\t", "\r" and "\n" don't need to be escaped.

NOTE: the logic has been adapted from the XlsxWriter library (BSD License)

return: string[]

escapeControlCharacters(string $string)   X-Ref
Converts PHP control characters from the given string to OpenXML escaped control characters.

Excel escapes control characters with _xHHHH_ and also escapes any
literal strings of that type by encoding the leading underscore.
So "\0" -> _x0000_ and "_x0000_" -> _x005F_x0000_.

NOTE: the logic has been adapted from the XlsxWriter library (BSD License)

param: string $string String to escape

escapeEscapeCharacter(string $string)   X-Ref
Escapes the escape character: "_x0000_" -> "_x005F_x0000_".

param: string $string String to escape
return: string The escaped string

unescapeControlCharacters(string $string)   X-Ref
Converts OpenXML escaped control characters from the given string to PHP control characters.

Excel escapes control characters with _xHHHH_ and also escapes any
literal strings of that type by encoding the leading underscore.
So "_x0000_" -> "\0" and "_x005F_x0000_" -> "_x0000_"

NOTE: the logic has been adapted from the XlsxWriter library (BSD License)

param: string $string String to unescape

unescapeEscapeCharacter(string $string)   X-Ref
Unecapes the escape character: "_x005F_x0000_" => "_x0000_".

param: string $string String to unescape
return: string The unescaped string