Docs For Class PHPExcel_Worksheet

$_autoFilter =

[line 146]

AutoFilter

Tags:

access:

private

Type:

boolean

[ Top ]

$_deleteColumns =

[line 118]

Delete columns

Tags:

access:

private

Type:

boolean

[ Top ]

$_deleteRows =

[line 125]

Delete rows

Tags:

access:

private

Type:

boolean

[ Top ]

$_formatCells =

[line 76]

Format cells

Tags:

access:

private

Type:

boolean

[ Top ]

$_formatColumns =

[line 83]

Format columns

Tags:

access:

private

Type:

boolean

[ Top ]

$_formatRows =

[line 90]

Format rows

Tags:

access:

private

Type:

boolean

[ Top ]

$_insertColumns =

[line 97]

Insert columns

Tags:

access:

private

Type:

boolean

[ Top ]

$_insertHyperlinks =

[line 111]

Insert hyperlinks

Tags:

access:

private

Type:

boolean

[ Top ]

$_insertRows =

[line 104]

Insert rows

Tags:

access:

private

Type:

boolean

[ Top ]

$_objects =

[line 62]

Objects

Tags:

access:

private

Type:

boolean

[ Top ]

$_password =

[line 167]

Password

Tags:

access:

private

Type:

string

[ Top ]

$_pivotTables =

[line 153]

Pivot tables

Tags:

access:

private

Type:

boolean

[ Top ]

$_scenarios =

[line 69]

Scenarios

Tags:

access:

private

Type:

boolean

[ Top ]

$_selectLockedCells =

[line 132]

Select locked cells

Tags:

access:

private

Type:

boolean

[ Top ]

$_selectUnlockedCells =

[line 160]

Select unlocked cells

Tags:

access:

private

Type:

boolean

[ Top ]

$_sheet =

[line 55]

Sheet

Tags:

access:

private

Type:

boolean

[ Top ]

$_sort =

[line 139]

Sort

Tags:

access:

private

Type:

boolean

[ Top ]

constructor __construct [line 172]

PHPExcel_Worksheet_Protection __construct(
)

Create a new PHPExcel_Worksheet_Protection

Tags:

access:

public

[ Top ]

method getAutoFilter [line 483]

boolean getAutoFilter(
)

Get AutoFilter

[ Top ]

method getDeleteColumns [line 403]

boolean getDeleteColumns(
)

Get DeleteColumns

[ Top ]

method getDeleteRows [line 423]

boolean getDeleteRows(
)

Get DeleteRows

[ Top ]

method getFormatCells [line 283]

boolean getFormatCells(
)

Get FormatCells

[ Top ]

method getFormatColumns [line 303]

boolean getFormatColumns(
)

Get FormatColumns

[ Top ]

method getFormatRows [line 323]

boolean getFormatRows(
)

Get FormatRows

[ Top ]

method getInsertColumns [line 343]

boolean getInsertColumns(
)

Get InsertColumns

[ Top ]

method getInsertHyperlinks [line 383]

boolean getInsertHyperlinks(
)

Get InsertHyperlinks

[ Top ]

method getInsertRows [line 363]

boolean getInsertRows(
)

Get InsertRows

[ Top ]

method getObjects [line 243]

boolean getObjects(
)

Get Objects

[ Top ]

method getPassword [line 543]

string getPassword(
)

Get Password (hashed)

[ Top ]

method getPivotTables [line 503]

boolean getPivotTables(
)

Get PivotTables

[ Top ]

method getScenarios [line 263]

boolean getScenarios(
)

Get Scenarios

[ Top ]

method getSelectLockedCells [line 443]

boolean getSelectLockedCells(
)

Get SelectLockedCells

[ Top ]

method getSelectUnlockedCells [line 523]

boolean getSelectUnlockedCells(
)

Get SelectUnlockedCells

[ Top ]

method getSheet [line 223]

boolean getSheet(
)

Get Sheet

[ Top ]

method getSort [line 463]

boolean getSort(
)

Get Sort

[ Top ]

method isProtectionEnabled [line 199]

boolean isProtectionEnabled(
)

Is some sort of protection enabled?

[ Top ]

method setAutoFilter [line 493]

PHPExcel_Worksheet_Protection setAutoFilter(
[boolean
$pValue = false])

Set AutoFilter

Parameters:

boolean

$pValue

[ Top ]

method setDeleteColumns [line 413]

PHPExcel_Worksheet_Protection setDeleteColumns(
[boolean
$pValue = false])

Set DeleteColumns

Parameters:

boolean

$pValue

[ Top ]

method setDeleteRows [line 433]

PHPExcel_Worksheet_Protection setDeleteRows(
[boolean
$pValue = false])

Set DeleteRows

Parameters:

boolean

$pValue

[ Top ]

method setFormatCells [line 293]

PHPExcel_Worksheet_Protection setFormatCells(
[boolean
$pValue = false])

Set FormatCells

Parameters:

boolean

$pValue

[ Top ]

method setFormatColumns [line 313]

PHPExcel_Worksheet_Protection setFormatColumns(
[boolean
$pValue = false])

Set FormatColumns

Parameters:

boolean

$pValue

[ Top ]

method setFormatRows [line 333]

PHPExcel_Worksheet_Protection setFormatRows(
[boolean
$pValue = false])

Set FormatRows

Parameters:

boolean

$pValue

[ Top ]

method setInsertColumns [line 353]

PHPExcel_Worksheet_Protection setInsertColumns(
[boolean
$pValue = false])

Set InsertColumns

Parameters:

boolean

$pValue

[ Top ]

method setInsertHyperlinks [line 393]

PHPExcel_Worksheet_Protection setInsertHyperlinks(
[boolean
$pValue = false])

Set InsertHyperlinks

Parameters:

boolean

$pValue

[ Top ]

method setInsertRows [line 373]

PHPExcel_Worksheet_Protection setInsertRows(
[boolean
$pValue = false])

Set InsertRows

Parameters:

boolean

$pValue

[ Top ]

method setObjects [line 253]

PHPExcel_Worksheet_Protection setObjects(
[boolean
$pValue = false])

Set Objects

Parameters:

boolean

$pValue

[ Top ]

method setPassword [line 554]

PHPExcel_Worksheet_Protection 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 513]

PHPExcel_Worksheet_Protection setPivotTables(
[boolean
$pValue = false])

Set PivotTables

Parameters:

boolean

$pValue

[ Top ]

method setScenarios [line 273]

PHPExcel_Worksheet_Protection setScenarios(
[boolean
$pValue = false])

Set Scenarios

Parameters:

boolean

$pValue

[ Top ]

method setSelectLockedCells [line 453]

PHPExcel_Worksheet_Protection setSelectLockedCells(
[boolean
$pValue = false])

Set SelectLockedCells

Parameters:

boolean

$pValue

[ Top ]

method setSelectUnlockedCells [line 533]

PHPExcel_Worksheet_Protection setSelectUnlockedCells(
[boolean
$pValue = false])

Set SelectUnlockedCells

Parameters:

boolean

$pValue

[ Top ]

method setSheet [line 233]

PHPExcel_Worksheet_Protection setSheet(
[boolean
$pValue = false])

Set Sheet

Parameters:

boolean

$pValue

[ Top ]

method setSort [line 473]

PHPExcel_Worksheet_Protection setSort(
[boolean
$pValue = false])

Set Sort

Parameters:

boolean

$pValue

[ Top ]

method __clone [line 565]

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 172]

Tags:

method getAutoFilter [line 483]

method getDeleteColumns [line 403]

method getDeleteRows [line 423]

method getFormatCells [line 283]

method getFormatColumns [line 303]

method getFormatRows [line 323]

method getInsertColumns [line 343]

method getInsertHyperlinks [line 383]

method getInsertRows [line 363]

method getObjects [line 243]

method getPassword [line 543]

method getPivotTables [line 503]

method getScenarios [line 263]

method getSelectLockedCells [line 443]

method getSelectUnlockedCells [line 523]

method getSheet [line 223]

method getSort [line 463]

method isProtectionEnabled [line 199]

method setAutoFilter [line 493]

Parameters:

method setDeleteColumns [line 413]

Parameters:

method setDeleteRows [line 433]

Parameters:

method setFormatCells [line 293]

Parameters:

method setFormatColumns [line 313]

Parameters:

method setFormatRows [line 333]

Parameters:

method setInsertColumns [line 353]

Parameters:

method setInsertHyperlinks [line 393]

Parameters: