[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

/lib/spout/src/Spout/Reader/XLSX/Helper/ -> CellValueFormatter.php (summary)

(no description)

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

Defines 1 class

CellValueFormatter:: (10 methods):
  __construct()
  extractAndFormatNodeValue()
  getVNodeValue()
  formatInlineStringCellValue()
  formatSharedStringCellValue()
  formatStrCellValue()
  formatNumericCellValue()
  formatExcelTimestampValue()
  formatBooleanCellValue()
  formatDateCellValue()


Class: CellValueFormatter  - X-Ref

Class CellValueFormatter
This class provides helper functions to format cell values

__construct($sharedStringsHelper, $styleHelper)   X-Ref

param: SharedStringsHelper $sharedStringsHelper Helper to work with shared strings
param: StyleHelper $styleHelper Helper to work with styles

extractAndFormatNodeValue($node)   X-Ref
Returns the (unescaped) correctly marshalled, cell value associated to the given XML node.

param: \DOMNode $node
return: string|int|float|bool|\DateTime|null The value associated with the cell (null when the cell has an error)

getVNodeValue($node)   X-Ref
Returns the cell's string value from a node's nested value node

param: \DOMNode $node
return: string The value associated with the cell

formatInlineStringCellValue($node)   X-Ref
Returns the cell String value where string is inline.

param: \DOMNode $node
return: string The value associated with the cell (null when the cell has an error)

formatSharedStringCellValue($nodeValue)   X-Ref
Returns the cell String value from shared-strings file using nodeValue index.

param: string $nodeValue
return: string The value associated with the cell (null when the cell has an error)

formatStrCellValue($nodeValue)   X-Ref
Returns the cell String value, where string is stored in value node.

param: string $nodeValue
return: string The value associated with the cell (null when the cell has an error)

formatNumericCellValue($nodeValue, $cellStyleId)   X-Ref
Returns the cell Numeric value from string of nodeValue.
The value can also represent a timestamp and a DateTime will be returned.

param: string $nodeValue
param: int $cellStyleId 0 being the default style
return: int|float|\DateTime|null The value associated with the cell

formatExcelTimestampValue($nodeValue)   X-Ref
Returns a cell's PHP Date value, associated to the given timestamp.
NOTE: The timestamp is a float representing the number of days since January 1st, 1900.

param: float $nodeValue
return: \DateTime|null The value associated with the cell or NULL if invalid date value

formatBooleanCellValue($nodeValue)   X-Ref
Returns the cell Boolean value from a specific node's Value.

param: string $nodeValue
return: bool The value associated with the cell

formatDateCellValue($nodeValue)   X-Ref
Returns a cell's PHP Date value, associated to the given stored nodeValue.

param: string $nodeValue
return: \DateTime|null The value associated with the cell or NULL if invalid date value



Generated: Thu Aug 11 10:00:09 2016 Cross-referenced by PHPXref 0.7.1