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.
$namedRanges : \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.
createSheet(null|int $sheetIndex = null) : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet
Create sheet and add it to this workbook.
| null|int | $sheetIndex | Index where sheet should go (0,1,..., or null for last) |
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) |
getNamedRange(string $namedRange, null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet = null) : null|\PhpOffice\PhpSpreadsheet\NamedRange
Get named range.
| string | $namedRange | |
| null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | Scope. Use null for global scope |
removeNamedRange(string $namedRange, null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet = null) : \PhpOffice\PhpSpreadsheet\Spreadsheet
Remove named range.
| string | $namedRange | |
| null|\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | scope: use null for global scope |
setVisibility(string $visibility) : mixed
Set the visibility status of the workbook.
Valid values are:
| string | $visibility | visibility status of the workbook |
if the given value is invalid
setTabRatio(int $tabRatio) : mixed
Set 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.
| int | $tabRatio | Ratio between the tabs bar and the horizontal scroll bar |
if the given value is invalid