[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

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

(no description)

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

Defines 1 class

StyleHelper:: (10 methods):
  __construct()
  extractRelevantInfo()
  extractNumberFormats()
  extractStyleAttributes()
  getCustomNumberFormats()
  getStylesAttributes()
  shouldFormatNumericValueAsDate()
  doesNumFmtIdIndicateDate()
  isNumFmtIdBuiltInDateFormat()
  isNumFmtIdCustomDateFormat()


Class: StyleHelper  - X-Ref

Class StyleHelper
This class provides helper functions related to XLSX styles

__construct($filePath)   X-Ref

param: string $filePath Path of the XLSX file being read

extractRelevantInfo()   X-Ref
Reads the styles.xml file and extract the relevant information from the file.

return: void

extractNumberFormats($numFmtsNode)   X-Ref
Extracts number formats from the "numFmt" nodes.
For simplicity, the styles attributes are kept in memory. This is possible thanks
to the reuse of formats. So 1 million cells should not use 1 million formats.

param: SimpleXMLElement $numFmtsNode The "numFmts" node
return: void

extractStyleAttributes($cellXfsNode)   X-Ref
Extracts style attributes from the "xf" nodes, inside the "cellXfs" section.
For simplicity, the styles attributes are kept in memory. This is possible thanks
to the reuse of styles. So 1 million cells should not use 1 million styles.

param: SimpleXMLElement $cellXfsNode The "cellXfs" node
return: void

getCustomNumberFormats()   X-Ref

return: array The custom number formats

getStylesAttributes()   X-Ref

return: array The styles attributes

shouldFormatNumericValueAsDate($styleId)   X-Ref
Returns whether the style with the given ID should consider
numeric values as timestamps and format the cell as a date.

param: int $styleId Zero-based style ID
return: bool Whether the cell with the given cell should display a date instead of a numeric value

doesNumFmtIdIndicateDate($numFmtId)   X-Ref

param: int $numFmtId
return: bool Whether the number format ID indicates that the number is a timestamp

isNumFmtIdBuiltInDateFormat($numFmtId)   X-Ref

param: int $numFmtId
return: bool Whether the number format ID indicates that the number is a timestamp

isNumFmtIdCustomDateFormat($numFmtId)   X-Ref

param: int $numFmtId
return: bool Whether the number format ID indicates that the number is a timestamp



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