Property | Type | Description | |
---|---|---|---|
$externalSheet | The "external" sheet | ||
$lastWrittenRowIndex | Index of the last written row | ||
$sharedStringsHelper | Helper to write shared strings | ||
$sheetFilePointer | Pointer to the sheet data file (e.g. xl/worksheets/sheet1.xml) | ||
$shouldUseInlineStrings | Whether inline or shared strings should be used | ||
$stringHelper | String helper | ||
$stringsEscaper | Strings escaper | ||
$styleHelper | Helper to work with styles | ||
$worksheetFilePath | Path to the XML file that will contain the sheet data |
Method | Description | |
---|---|---|
__construct ( |
||
addRow ( array $dataRow, |
Adds data to the worksheet. | |
close ( ) : void | Closes the worksheet | |
getExternalSheet ( ) : |
||
getId ( ) : integer | ||
getLastWrittenRowIndex ( ) : integer |
Method | Description | |
---|---|---|
startSheet ( ) : void | Prepares the worksheet to accept data | |
throwIfSheetFilePointerIsNotAvailable ( ) : void | Checks if the book has been created. Throws an exception if not created yet. |
Method | Description | |
---|---|---|
addNonEmptyRow ( array $dataRow, |
Adds non empty row to the worksheet. | |
getCellXML ( integer $rowIndex, integer $cellNumber, mixed $cellValue, integer $styleId ) : string | Build and return xml for a single cell. | |
getCellXMLFragmentForNonEmptyString ( string $cellValue ) : string | Returns the XML fragment for a cell containing a non empty string | |
isEmptyRow ( array $dataRow ) : boolean | Returns whether the given row is empty |
public __construct ( |
||
$externalSheet | The associated "external" sheet | |
$worksheetFilesFolder | string | Temporary folder where the files to create the XLSX will be stored |
$sharedStringsHelper | Box\Spout\Writer\XLSX\Helper\SharedStringsHelper | Helper for shared strings |
$shouldUseInlineStrings | boolean | Whether inline or shared strings should be used |
public getExternalSheet ( ) : |
||
return | The "external" sheet |
public getLastWrittenRowIndex ( ) : integer | ||
return | integer | The index of the last written row |
protected startSheet ( ) : void | ||
return | void |
protected throwIfSheetFilePointerIsNotAvailable ( ) : void | ||
return | void |
protected $lastWrittenRowIndex |
protected $sheetFilePointer |
protected $shouldUseInlineStrings |