Docs For Class PHPExcel_Worksheet

constructor __construct [line 160]

PHPExcel_Worksheet_Protection __construct(
)

Create a new PHPExcel_Worksheet_Protection

Tags:

access:

public

[ Top ]

method getAutoFilter [line 453]

boolean getAutoFilter(
)

Get AutoFilter

[ Top ]

method getDeleteColumns [line 373]

boolean getDeleteColumns(
)

Get DeleteColumns

[ Top ]

method getDeleteRows [line 393]

boolean getDeleteRows(
)

Get DeleteRows

[ Top ]

method getFormatCells [line 253]

boolean getFormatCells(
)

Get FormatCells

[ Top ]

method getFormatColumns [line 273]

boolean getFormatColumns(
)

Get FormatColumns

[ Top ]

method getFormatRows [line 293]

boolean getFormatRows(
)

Get FormatRows

[ Top ]

method getInsertColumns [line 313]

boolean getInsertColumns(
)

Get InsertColumns

[ Top ]

method getInsertHyperlinks [line 353]

boolean getInsertHyperlinks(
)

Get InsertHyperlinks

[ Top ]

method getInsertRows [line 333]

boolean getInsertRows(
)

Get InsertRows

[ Top ]

method getObjects [line 213]

boolean getObjects(
)

Get Objects

[ Top ]

method getPassword [line 513]

string getPassword(
)

Get Password (hashed)

[ Top ]

method getPivotTables [line 473]

boolean getPivotTables(
)

Get PivotTables

[ Top ]

method getScenarios [line 233]

boolean getScenarios(
)

Get Scenarios

[ Top ]

method getSelectLockedCells [line 413]

boolean getSelectLockedCells(
)

Get SelectLockedCells

[ Top ]

method getSelectUnlockedCells [line 493]

boolean getSelectUnlockedCells(
)

Get SelectUnlockedCells

[ Top ]

method getSheet [line 193]

boolean getSheet(
)

Get Sheet

[ Top ]

method getSort [line 433]

boolean getSort(
)

Get Sort

[ Top ]

method isProtectionEnabled [line 169]

boolean isProtectionEnabled(
)

Is some sort of protection enabled?

[ Top ]

method setAutoFilter [line 463]

PHPExcel_Worksheet_Protection setAutoFilter(
[boolean
$pValue = false])

Set AutoFilter

Parameters:

boolean

$pValue

[ Top ]

method setDeleteColumns [line 383]

PHPExcel_Worksheet_Protection setDeleteColumns(
[boolean
$pValue = false])

Set DeleteColumns

Parameters:

boolean

$pValue

[ Top ]

method setDeleteRows [line 403]

PHPExcel_Worksheet_Protection setDeleteRows(
[boolean
$pValue = false])

Set DeleteRows

Parameters:

boolean

$pValue

[ Top ]

method setFormatCells [line 263]

PHPExcel_Worksheet_Protection setFormatCells(
[boolean
$pValue = false])

Set FormatCells

Parameters:

boolean

$pValue

[ Top ]

method setFormatColumns [line 283]

PHPExcel_Worksheet_Protection setFormatColumns(
[boolean
$pValue = false])

Set FormatColumns

Parameters:

boolean

$pValue

[ Top ]

method setFormatRows [line 303]

PHPExcel_Worksheet_Protection setFormatRows(
[boolean
$pValue = false])

Set FormatRows

Parameters:

boolean

$pValue

[ Top ]

method setInsertColumns [line 323]

PHPExcel_Worksheet_Protection setInsertColumns(
[boolean
$pValue = false])

Set InsertColumns

Parameters:

boolean

$pValue

[ Top ]

method setInsertHyperlinks [line 363]

PHPExcel_Worksheet_Protection setInsertHyperlinks(
[boolean
$pValue = false])

Set InsertHyperlinks

Parameters:

boolean

$pValue

[ Top ]

method setInsertRows [line 343]

PHPExcel_Worksheet_Protection setInsertRows(
[boolean
$pValue = false])

Set InsertRows

Parameters:

boolean

$pValue

[ Top ]

method setObjects [line 223]

PHPExcel_Worksheet_Protection setObjects(
[boolean
$pValue = false])

Set Objects

Parameters:

boolean

$pValue

[ Top ]

method setPassword [line 524]

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

PHPExcel_Worksheet_Protection setPivotTables(
[boolean
$pValue = false])

Set PivotTables

Parameters:

boolean

$pValue

[ Top ]

method setScenarios [line 243]

PHPExcel_Worksheet_Protection setScenarios(
[boolean
$pValue = false])

Set Scenarios

Parameters:

boolean

$pValue

[ Top ]

method setSelectLockedCells [line 423]

PHPExcel_Worksheet_Protection setSelectLockedCells(
[boolean
$pValue = false])

Set SelectLockedCells

Parameters:

boolean

$pValue

[ Top ]

method setSelectUnlockedCells [line 503]

PHPExcel_Worksheet_Protection setSelectUnlockedCells(
[boolean
$pValue = false])

Set SelectUnlockedCells

Parameters:

boolean

$pValue

[ Top ]

method setSheet [line 203]

PHPExcel_Worksheet_Protection setSheet(
[boolean
$pValue = false])

Set Sheet

Parameters:

boolean

$pValue

[ Top ]

method setSort [line 443]

PHPExcel_Worksheet_Protection setSort(
[boolean
$pValue = false])

Set Sort

Parameters:

boolean

$pValue

[ Top ]

method __clone [line 535]

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:

Methods

Class Details

Tags:

Class Methods

constructor __construct [line 160]

Tags:

method getAutoFilter [line 453]

method getDeleteColumns [line 373]

method getDeleteRows [line 393]

method getFormatCells [line 253]

method getFormatColumns [line 273]

method getFormatRows [line 293]

method getInsertColumns [line 313]

method getInsertHyperlinks [line 353]

method getInsertRows [line 333]

method getObjects [line 213]

method getPassword [line 513]

method getPivotTables [line 473]

method getScenarios [line 233]

method getSelectLockedCells [line 413]

method getSelectUnlockedCells [line 493]

method getSheet [line 193]

method getSort [line 433]

method isProtectionEnabled [line 169]

method setAutoFilter [line 463]

Parameters:

method setDeleteColumns [line 383]

Parameters:

method setDeleteRows [line 403]

Parameters:

method setFormatCells [line 263]

Parameters:

method setFormatColumns [line 283]

Parameters:

method setFormatRows [line 303]

Parameters:

method setInsertColumns [line 323]

Parameters:

method setInsertHyperlinks [line 363]

Parameters:

method setInsertRows [line 343]

Parameters:

method setObjects [line 223]

Parameters:

method setPassword [line 524]

Parameters:

method setPivotTables [line 483]

Parameters:

method setScenarios [line 243]

Parameters:

method setSelectLockedCells [line 423]

Parameters:

method setSelectUnlockedCells [line 503]

Parameters:

method setSheet [line 203]

Parameters:

method setSort [line 443]

Parameters:

method __clone [line 535]

Tags: