VISIBILITY_VISIBLE
VISIBILITY_VISIBLE = 'visible'
$uniqueID : string
Unique ID.
$properties : \PhpOffice\PhpSpreadsheet\Document\Properties
Document properties.
$security : \PhpOffice\PhpSpreadsheet\Document\Security
Document security.
$workSheetCollection : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet[]
Collection of Worksheet objects.
$calculationEngine : \PhpOffice\PhpSpreadsheet\Calculation\Calculation
Calculation Engine.
$activeSheetIndex : int
Active sheet index.
$definedNames : \PhpOffice\PhpSpreadsheet\NamedRange[]
Named ranges.
$cellXfSupervisor : \PhpOffice\PhpSpreadsheet\Style\Style
CellXf supervisor.
$cellXfCollection : \PhpOffice\PhpSpreadsheet\Style\Style[]
CellXf collection.
$cellStyleXfCollection : \PhpOffice\PhpSpreadsheet\Style\Style[]
CellStyleXf collection.
$hasMacros : bool
hasMacros : this workbook have macros ?
$macrosCode : string
macrosCode : all macros code as binary data (the vbaProject.bin file, this include form, code, etc.), null if no macro.
$macrosCertificate : string
macrosCertificate : if macros are signed, contains binary data vbaProjectSignature.bin file, null if not signed.
$ribbonXMLData : null|string
ribbonXMLData : null if workbook is'nt Excel 2007 or not contain a customized UI.
$ribbonBinObjects : null|array
ribbonBinObjects : null if workbook is'nt Excel 2007 or not contain embedded objects (picture(s)) for Ribbon Elements ignored if $ribbonXMLData is null.
$unparsedLoadedData : array
List of unparsed loaded data for export to same format with better compatibility.
It has to be minimized when the library start to support currently unparsed data.
$showHorizontalScroll : bool
Controls visibility of the horizonal scroll bar in the application.
$showVerticalScroll : bool
Controls visibility of the horizonal scroll bar in the application.
$showSheetTabs : bool
Controls visibility of the sheet tabs in the application.
$minimized : bool
Specifies a boolean value that indicates whether the workbook window is minimized.
$autoFilterDateGrouping : bool
Specifies a boolean value that indicates whether to group dates when presenting the user with filtering optiomd in the user interface.
$firstSheetIndex : int
Specifies the index to the first sheet in the book view.
$visibility : string
Specifies the visible status of the workbook.
$tabRatio : int
Specifies the ratio between the workbook tabs bar and the horizontal scroll bar. TabRatio is assumed to be out of 1000 of the horizontal window width.
addSheet(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, null|int $iSheetIndex = null) : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Add sheet.
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | |
| null|int | $iSheetIndex | Index where sheet should go (0,1,..., or null for last) |
addExternalSheet(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, null|int $iSheetIndex = null) : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Add external sheet.
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | External sheet to add |
| null|int | $iSheetIndex | Index where sheet should go (0,1,..., or null for last) |
addDefinedName(\PhpOffice\PhpSpreadsheet\DefinedName $definedName) : void
Add a defined name (either a named range or a named formula).
If a defined named with this name already exists, then this will replace the existing value.
| \PhpOffice\PhpSpreadsheet\DefinedName | $definedName |
getNamedRange(string $namedRange, null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet = null) : ?\PhpOffice\PhpSpreadsheet\NamedRange
Get named range.
| string | $namedRange | |
| null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | Scope. Use null for global scope |
getNamedFormula(string $namedFormula, null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet = null) : ?\PhpOffice\PhpSpreadsheet\NamedFormula
Get named formula.
| string | $namedFormula | |
| null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | Scope. Use null for global scope |
getDefinedName(string $definedName, null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet = null) : ?\PhpOffice\PhpSpreadsheet\DefinedName
Get named range.
| string | $definedName | |
| null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | Scope. Use null for global scope |
setVisibility(string $visibility) : void
Set the visibility status of the workbook.
Valid values are:
| string | $visibility | visibility status of the workbook |
getLocalDefinedNameByType(string $name, bool $type, ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet = null) : ?\PhpOffice\PhpSpreadsheet\DefinedName
| string | $name | |
| bool | $type | |
| ?\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet |