PHP 클래스 Box\Spout\Reader\XLSX\Helper\SheetHelper

보호된 프로퍼티들

프로퍼티	타입	설명
$filePath		Path of the XLSX file being read
$globalFunctionsHelper		Helper to work with global functions
$options		Reader's current options
$sharedStringsHelper		Helper to work with shared strings

공개 메소드들

메소드	설명
__construct ( string $filePath, ReaderOptions $options, $sharedStringsHelper, Box\Spout\Common\Helper\GlobalFunctionsHelper $globalFunctionsHelper )
getSheets ( ) : Sheet[]	Returns the sheets metadata of the file located at the previously given file path.

보호된 메소드들

메소드	설명
getSheetDataXMLFilePathForSheetId ( string $sheetId ) : string
getSheetFromSheetXMLNode ( Box\Spout\Reader\Wrapper\XMLReader $xmlReaderOnSheetNode, integer $sheetIndexZeroBased ) : Sheet	Returns an instance of a sheet, given the XML node describing the sheet - from "workbook.xml".

메소드 상세

__construct() 공개 메소드

public __construct ( string $filePath, ReaderOptions $options, $sharedStringsHelper, Box\Spout\Common\Helper\GlobalFunctionsHelper $globalFunctionsHelper )
$filePath	string	Path of the XLSX file being read
$options	Box\Spout\Reader\XLSX\ReaderOptions	Reader's current options
$globalFunctionsHelper	Box\Spout\Common\Helper\GlobalFunctionsHelper

getSheetDataXMLFilePathForSheetId() 보호된 메소드

protected getSheetDataXMLFilePathForSheetId ( string $sheetId ) : string
$sheetId	string	The sheet ID, as defined in "workbook.xml"
리턴	string	The XML file path describing the sheet inside "workbook.xml.res", for the given sheet ID

getSheetFromSheetXMLNode() 보호된 메소드

We can find the XML file path describing the sheet inside "workbook.xml.res", by mapping with the sheet ID ("r:id" in "workbook.xml", "Id" in "workbook.xml.res").

protected getSheetFromSheetXMLNode ( Box\Spout\Reader\Wrapper\XMLReader $xmlReaderOnSheetNode, integer $sheetIndexZeroBased ) : Sheet
$xmlReaderOnSheetNode	Box\Spout\Reader\Wrapper\XMLReader	XML Reader instance, pointing on the node describing the sheet, as defined in "workbook.xml"
$sheetIndexZeroBased	integer	Index of the sheet, based on order of appearance in the workbook (zero-based)
리턴	Box\Spout\Reader\XLSX\Sheet	Sheet instance

getSheets() 공개 메소드

The paths to the sheets' data are read from the [Content_Types].xml file.

public getSheets ( ) : Sheet[]
리턴	Box\Spout\Reader\XLSX\Sheet[]	Sheets within the XLSX file

프로퍼티 상세

$filePath 보호되어 있는 프로퍼티

Path of the XLSX file being read

protected $filePath

$globalFunctionsHelper 보호되어 있는 프로퍼티

Helper to work with global functions

protected $globalFunctionsHelper

$options 보호되어 있는 프로퍼티

Reader's current options

protected $options

$sharedStringsHelper 보호되어 있는 프로퍼티

Helper to work with shared strings

protected $sharedStringsHelper