Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.2.x will end 22 April 2024 (12 months).
  • Bug fixes for security issues in 4.2.x will end 7 October 2024 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.1.x is supported too.
/lib/openspout/src/Common/Helper/Escaper/ -> XLSX.php (source)

[Source view]

(no description)

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

Defines 1 class

XLSX:: (9 methods):
  escape()
  unescape()
  initIfNeeded()
  getEscapableControlCharactersPattern()
  getControlCharactersEscapingMap()
  escapeControlCharacters()
  escapeEscapeCharacter()
  unescapeControlCharacters()
  unescapeEscapeCharacter()


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