Constants

SHEETVIEW_NORMAL

SHEETVIEW_NORMAL = 'normal'

SHEETVIEW_PAGE_LAYOUT

SHEETVIEW_PAGE_LAYOUT = 'pageLayout'

SHEETVIEW_PAGE_BREAK_PREVIEW

SHEETVIEW_PAGE_BREAK_PREVIEW = 'pageBreakPreview'

Properties

$sheetViewTypes

$sheetViewTypes : 

Type

$zoomScale

$zoomScale : integer

ZoomScale.

Valid values range from 10 to 400.

Type

integer

$zoomScaleNormal

$zoomScaleNormal : integer

ZoomScaleNormal.

Valid values range from 10 to 400.

Type

integer

$showZeros

$showZeros : boolean

ShowZeros.

If true, "null" values from a calculation will be shown as "0". This is the default Excel behaviour and can be changed with the advanced worksheet option "Show a zero in cells that have zero value"

Type

boolean

$sheetviewType

$sheetviewType : string

View.

Valid values range from 10 to 400.

Type

string

Methods

__construct()

__construct() 

Create a new SheetView.

getZoomScale()

getZoomScale() : integer

Get ZoomScale.

Returns

integer

setZoomScale()

setZoomScale(integer  $pValue) : $this

Set ZoomScale.

Valid values range from 10 to 400.

Parameters

integer $pValue

Throws

\PhpOffice\PhpSpreadsheet\Exception

Returns

$this

getZoomScaleNormal()

getZoomScaleNormal() : integer

Get ZoomScaleNormal.

Returns

integer

setZoomScaleNormal()

setZoomScaleNormal(integer  $pValue) : $this

Set ZoomScale.

Valid values range from 10 to 400.

Parameters

integer $pValue

Throws

\PhpOffice\PhpSpreadsheet\Exception

Returns

$this

setShowZeros()

setShowZeros(boolean  $pValue) 

Set ShowZeroes setting.

Parameters

boolean $pValue

getShowZeros()

getShowZeros() : boolean

Returns

boolean

getView()

getView() : string

Get View.

Returns

string

setView()

setView(string  $pValue) : $this

Set View.

Valid values are 'normal' self::SHEETVIEW_NORMAL 'pageLayout' self::SHEETVIEW_PAGE_LAYOUT 'pageBreakPreview' self::SHEETVIEW_PAGE_BREAK_PREVIEW

Parameters

string $pValue

Throws

\PhpOffice\PhpSpreadsheet\Exception

Returns

$this

__clone()

__clone() 

Implement PHP __clone to create a deep clone, not just a shallow copy.