Docs For Class PHPExcel_Worksheet

$_autoFilter =

[line 138]

AutoFilter

Tags:

access:

private

Type:

boolean

[ Top ]

$_deleteColumns =

[line 110]

Delete columns

Tags:

access:

private

Type:

boolean

[ Top ]

$_deleteRows =

[line 117]

Delete rows

Tags:

access:

private

Type:

boolean

[ Top ]

$_formatCells =

[line 68]

Format cells

Tags:

access:

private

Type:

boolean

[ Top ]

$_formatColumns =

[line 75]

Format columns

Tags:

access:

private

Type:

boolean

[ Top ]

$_formatRows =

[line 82]

Format rows

Tags:

access:

private

Type:

boolean

[ Top ]

$_insertColumns =

[line 89]

Insert columns

Tags:

access:

private

Type:

boolean

[ Top ]

$_insertHyperlinks =

[line 103]

Insert hyperlinks

Tags:

access:

private

Type:

boolean

[ Top ]

$_insertRows =

[line 96]

Insert rows

Tags:

access:

private

Type:

boolean

[ Top ]

$_objects =

[line 54]

Objects

Tags:

access:

private

Type:

boolean

[ Top ]

$_password =

[line 159]

Password

Tags:

access:

private

Type:

string

[ Top ]

$_pivotTables =

[line 145]

Pivot tables

Tags:

access:

private

Type:

boolean

[ Top ]

$_scenarios =

[line 61]

Scenarios

Tags:

access:

private

Type:

boolean

[ Top ]

$_selectLockedCells =

[line 124]

Select locked cells

Tags:

access:

private

Type:

boolean

[ Top ]

$_selectUnlockedCells =

[line 152]

Select unlocked cells

Tags:

access:

private

Type:

boolean

[ Top ]

$_sheet =

[line 47]

Sheet

Tags:

access:

private

Type:

boolean

[ Top ]

$_sort =

[line 131]

Sort

Tags:

access:

private

Type:

boolean

[ Top ]

constructor __construct [line 164]

PHPExcel_Worksheet_Protection __construct(
)

Create a new PHPExcel_Worksheet_Protection

Tags:

access:

public

[ Top ]

method getAutoFilter [line 449]

boolean getAutoFilter(
)

Get AutoFilter

[ Top ]

method getDeleteColumns [line 377]

boolean getDeleteColumns(
)

Get DeleteColumns

[ Top ]

method getDeleteRows [line 395]

boolean getDeleteRows(
)

Get DeleteRows

[ Top ]

method getFormatCells [line 269]

boolean getFormatCells(
)

Get FormatCells

[ Top ]

method getFormatColumns [line 287]

boolean getFormatColumns(
)

Get FormatColumns

[ Top ]

method getFormatRows [line 305]

boolean getFormatRows(
)

Get FormatRows

[ Top ]

method getInsertColumns [line 323]

boolean getInsertColumns(
)

Get InsertColumns

[ Top ]

method getInsertHyperlinks [line 359]

boolean getInsertHyperlinks(
)

Get InsertHyperlinks

[ Top ]

method getInsertRows [line 341]

boolean getInsertRows(
)

Get InsertRows

[ Top ]

method getObjects [line 233]

boolean getObjects(
)

Get Objects

[ Top ]

method getPassword [line 503]

string getPassword(
)

Get Password (hashed)

[ Top ]

method getPivotTables [line 467]

boolean getPivotTables(
)

Get PivotTables

[ Top ]

method getScenarios [line 251]

boolean getScenarios(
)

Get Scenarios

[ Top ]

method getSelectLockedCells [line 413]

boolean getSelectLockedCells(
)

Get SelectLockedCells

[ Top ]

method getSelectUnlockedCells [line 485]

boolean getSelectUnlockedCells(
)

Get SelectUnlockedCells

[ Top ]

method getSheet [line 215]

boolean getSheet(
)

Get Sheet

[ Top ]

method getSort [line 431]

boolean getSort(
)

Get Sort

[ Top ]

method isProtectionEnabled [line 191]

boolean isProtectionEnabled(
)

Is some sort of protection enabled?

[ Top ]

method setAutoFilter [line 458]

void setAutoFilter(
[boolean
$pValue = false])

Set AutoFilter

Parameters:

boolean

$pValue

[ Top ]

method setDeleteColumns [line 386]

void setDeleteColumns(
[boolean
$pValue = false])

Set DeleteColumns

Parameters:

boolean

$pValue

[ Top ]

method setDeleteRows [line 404]

void setDeleteRows(
[boolean
$pValue = false])

Set DeleteRows

Parameters:

boolean

$pValue

[ Top ]

method setFormatCells [line 278]

void setFormatCells(
[boolean
$pValue = false])

Set FormatCells

Parameters:

boolean

$pValue

[ Top ]

method setFormatColumns [line 296]

void setFormatColumns(
[boolean
$pValue = false])

Set FormatColumns

Parameters:

boolean

$pValue

[ Top ]

method setFormatRows [line 314]

void setFormatRows(
[boolean
$pValue = false])

Set FormatRows

Parameters:

boolean

$pValue

[ Top ]

method setInsertColumns [line 332]

void setInsertColumns(
[boolean
$pValue = false])

Set InsertColumns

Parameters:

boolean

$pValue

[ Top ]

method setInsertHyperlinks [line 368]

void setInsertHyperlinks(
[boolean
$pValue = false])

Set InsertHyperlinks

Parameters:

boolean

$pValue

[ Top ]

method setInsertRows [line 350]

void setInsertRows(
[boolean
$pValue = false])

Set InsertRows

Parameters:

boolean

$pValue

[ Top ]

method setObjects [line 242]

void setObjects(
[boolean
$pValue = false])

Set Objects

Parameters:

boolean

$pValue

[ Top ]

method setPassword [line 513]

void setPassword(
[string
$pValue = ''], [boolean
$pAlreadyHashed = false])

Set Password

Parameters:

string	$pValue
boolean	$pAlreadyHashed	If the password has already been hashed, set this to true

[ Top ]

method setPivotTables [line 476]

void setPivotTables(
[boolean
$pValue = false])

Set PivotTables

Parameters:

boolean

$pValue

[ Top ]

method setScenarios [line 260]

void setScenarios(
[boolean
$pValue = false])

Set Scenarios

Parameters:

boolean

$pValue

[ Top ]

method setSelectLockedCells [line 422]

void setSelectLockedCells(
[boolean
$pValue = false])

Set SelectLockedCells

Parameters:

boolean

$pValue

[ Top ]

method setSelectUnlockedCells [line 494]

void setSelectUnlockedCells(
[boolean
$pValue = false])

Set SelectUnlockedCells

Parameters:

boolean

$pValue

[ Top ]

method setSheet [line 224]

void setSheet(
[boolean
$pValue = false])

Set Sheet

Parameters:

boolean

$pValue

[ Top ]

method setSort [line 440]

void setSort(
[boolean
$pValue = false])

Set Sort

Parameters:

boolean

$pValue

[ Top ]

method __clone [line 523]

void __clone(
)

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

Tags:

access:

public

[ Top ]

Class: PHPExcel_Worksheet_Protection

Class Overview

Author(s):

Copyright:

Variables

Methods

Class Details

Tags:

Class Variables

$_autoFilter =

Tags:

$_deleteColumns =

Tags:

$_deleteRows =

Tags:

$_formatCells =

Tags:

$_formatColumns =

Tags:

$_formatRows =

Tags:

$_insertColumns =

Tags:

$_insertHyperlinks =

Tags:

$_insertRows =

Tags:

$_objects =

Tags:

$_password =

Tags:

$_pivotTables =

Tags:

$_scenarios =

Tags:

$_selectLockedCells =

Tags:

$_selectUnlockedCells =

Tags:

$_sheet =

Tags:

$_sort =

Tags:

Class Methods

constructor __construct [line 164]

Tags:

method getAutoFilter [line 449]

method getDeleteColumns [line 377]

method getDeleteRows [line 395]

method getFormatCells [line 269]

method getFormatColumns [line 287]

method getFormatRows [line 305]

method getInsertColumns [line 323]

method getInsertHyperlinks [line 359]

method getInsertRows [line 341]

method getObjects [line 233]

method getPassword [line 503]

method getPivotTables [line 467]

method getScenarios [line 251]

method getSelectLockedCells [line 413]

method getSelectUnlockedCells [line 485]

method getSheet [line 215]

method getSort [line 431]

method isProtectionEnabled [line 191]

method setAutoFilter [line 458]

Parameters:

method setDeleteColumns [line 386]

Parameters:

method setDeleteRows [line 404]

Parameters:

method setFormatCells [line 278]

Parameters:

method setFormatColumns [line 296]

Parameters:

method setFormatRows [line 314]

Parameters:

method setInsertColumns [line 332]

Parameters:

method setInsertHyperlinks [line 368]

Parameters: