Docs For Class PHPExcel

static method extractSheetTitle [line 2262]

static mixed extractSheetTitle(
string
$pRange, [bool
$returnRange = false])

Extract worksheet title from range.

Example: extractSheetTitle('test!A1') ==> 'A1' Example: extractSheetTitle('test!A1', true) ==> array('test', 'A1');

Tags:

access:

public

Parameters:

string	$pRange	Range to extract title from
bool	$returnRange	Return range? (see example)

[ Top ]

static method getInvalidCharacters [line 379]

static array getInvalidCharacters(
)

Get array of invalid characters for sheet title

Tags:

access:

public

[ Top ]

constructor __construct [line 313]

PHPExcel_Worksheet __construct(
[
$pParent = null], [string
$pTitle = 'Worksheet'])

Create a new worksheet

Tags:

access:

public

Parameters:

PHPExcel	$pParent
string	$pTitle

[ Top ]

method calculateColumnWidths [line 546]

PHPExcel_Worksheet; calculateColumnWidths(
[boolean
$calculateMergeCells = false])

Calculate widths for auto-size columns

Tags:

access:

public

Parameters:

boolean

$calculateMergeCells

Calculate merge cell width

[ Top ]

method calculateWorksheetDimension [line 534]

string calculateWorksheetDimension(
)

Calculate worksheet dimension

Tags:

return:	String containing the dimension of this worksheet
access:	public

[ Top ]

method cellExists [line 998]

boolean cellExists(
[string
$pCoordinate = 'A1'])

Cell at a specific coordinate exists?

Tags:

throws:	Exception
access:	public

Parameters:

string

$pCoordinate

Coordinate of the cell

[ Top ]

method cellExistsByColumnAndRow [line 1045]

boolean cellExistsByColumnAndRow(
[string
$pColumn = 0], [string
$pRow = 0])

Cell at a specific coordinate by using numeric cell coordinates exists?

Tags:

access:

public

Parameters:

string	$pColumn	Numeric column coordinate of the cell
string	$pRow	Numeric row coordinate of the cell

[ Top ]

method conditionalStylesExists [line 1183]

boolean conditionalStylesExists(
[string
$pCoordinate = 'A1'])

Do conditional styles exist for this cell?

Tags:

access:

public

Parameters:

string

$pCoordinate

[ Top ]

method copy [line 2469]

PHPExcel_Worksheet copy(
)

Copy worksheet (!= clone!)

Tags:

access:

public

[ Top ]

method dataValidationExists [line 2385]

boolean dataValidationExists(
[
$pCoordinate = 'A1'], string
$pCellCoordinate)

Data validation at a specific coordinate exists?

Tags:

access:

public

Parameters:

string	$pCellCoordinate
	$pCoordinate

[ Top ]

method disconnectCells [line 356]

void disconnectCells(
)

Tags:

access:

public

[ Top ]

method duplicateStyle [line 1265]

PHPExcel_Worksheet duplicateStyle(
[
$pCellStyle = null], [string
$pRange = ''])

Duplicate cell style to a range of cells

Please note that this will overwrite existing cell styles for cells in range!

Tags:

throws:	Exception
access:	public

Parameters:

PHPExcel_Style	$pCellStyle	Cell style to duplicate
string	$pRange	Range of cells (i.e. "A1:B10"), or just one cell (i.e. "A1")

[ Top ]

method duplicateStyleArray [line 1333]

PHPExcel_Worksheet duplicateStyleArray(
[array
$pStyles = null], [string
$pRange = ''], [boolean
$pAdvanced = true])

Duplicate cell style array to a range of cells

Please note that this will overwrite existing cell styles for cells in range, if they are in the styles array. For example, if you decide to set a range of cells to font bold, only include font bold in the styles array.

Tags:

deprecated:
throws:	Exception
access:	public

Parameters:

array	$pStyles	Array containing style information
string	$pRange	Range of cells (i.e. "A1:B10"), or just one cell (i.e. "A1")
boolean	$pAdvanced	Advanced mode for setting borders.

[ Top ]

method freezePane [line 1658]

PHPExcel_Worksheet freezePane(
[string
$pCell = ''])

Freeze Pane

Tags:

throws:	Exception
access:	public

Parameters:

string

$pCell

Cell (i.e. A1)

[ Top ]

method freezePaneByColumnAndRow [line 1679]

PHPExcel_Worksheet freezePaneByColumnAndRow(
[int
$pColumn = 0], [int
$pRow = 0])

Freeze Pane by using numeric cell coordinates

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn	Numeric column coordinate of the cell
int	$pRow	Numeric row coordinate of the cell

[ Top ]

method fromArray [line 2069]

PHPExcel_Worksheet fromArray(
[array
$source = null], [mixed
$nullValue = null], [
$pCell = 'A1'])

Fill worksheet from values in array

Tags:

throws:	Exception
access:	public

Parameters:

array	$source	Source array
mixed	$nullValue	Value in source array that stands for blank cell
	$pCell

[ Top ]

method garbageCollect [line 2161]

PHPExcel_Worksheet garbageCollect(
)

Run PHPExcel garabage collector.

Tags:

access:

public

[ Top ]

method getActiveCell [line 1968]

string getActiveCell(
)

Get active cell

Tags:

return:	Example: 'A1'
access:	public

[ Top ]

method getAutoFilter [line 1597]

string getAutoFilter(
)

Get Autofilter Range

Tags:

access:

public

[ Top ]

method getBreaks [line 1380]

array[] getBreaks(
)

Get breaks

Tags:

access:

public

[ Top ]

method getCell [line 899]

PHPExcel_Cell getCell(
[string
$pCoordinate = 'A1'])

Get cell at a specific coordinate

Tags:

return:	Cell that was found
throws:	Exception
access:	public

Parameters:

string

$pCoordinate

Coordinate of the cell

[ Top ]

method getCellByColumnAndRow [line 970]

PHPExcel_Cell getCellByColumnAndRow(
[string
$pColumn = 0], [string
$pRow = 0])

Get cell at a specific coordinate by using numeric cell coordinates

Tags:

return:	Cell that was found
access:	public

Parameters:

string	$pColumn	Numeric column coordinate of the cell
string	$pRow	Numeric row coordinate of the cell

[ Top ]

method getCellCacheController [line 369]

PHPExcel_CachedObjectStorage_xxx getCellCacheController(
)

Return the cache controller for the cell collection

Tags:

access:

public

[ Top ]

method getCellCollection [line 412]

PHPExcel_Cell[] getCellCollection(
[boolean
$pSorted = true])

Get collection of cells

Tags:

access:

public

Parameters:

boolean

$pSorted

Also sort the cell collection?

[ Top ]

method getColumnDimension [line 1077]

PHPExcel_Worksheet_ColumnDimension getColumnDimension(
[string
$pColumn = 'A'])

Get column dimension at a specific column

Tags:

access:

public

Parameters:

string

$pColumn

String index of the column

[ Top ]

method getColumnDimensionByColumn [line 1099]

PHPExcel_Worksheet_ColumnDimension getColumnDimensionByColumn(
[string
$pColumn = 0], string
$pRow)

Get column dimension at a specific column by using numeric cell coordinates

Tags:

access:

public

Parameters:

string	$pColumn	Numeric column coordinate of the cell
string	$pRow	Numeric row coordinate of the cell

[ Top ]

method getColumnDimensions [line 466]

PHPExcel_Worksheet_ColumnDimension[] getColumnDimensions(
)

Get collection of column dimensions

Tags:

access:

public

[ Top ]

method getComment [line 1916]

PHPExcel_Comment getComment(
[string
$pCellCoordinate = 'A1'])

Get comment for cell

Tags:

throws:	Exception
access:	public

Parameters:

string

$pCellCoordinate

Cell coordinate to get comment for

[ Top ]

method getCommentByColumnAndRow [line 1947]

PHPExcel_Comment getCommentByColumnAndRow(
[int
$pColumn = 0], [int
$pRow = 0])

Get comment for cell by using numeric cell coordinates

Tags:

access:

public

Parameters:

int	$pColumn	Numeric column coordinate of the cell
int	$pRow	Numeric row coordinate of the cell

[ Top ]

method getComments [line 1904]

PHPExcel_Comment[] getComments(
)

Get comments

Tags:

access:

public

[ Top ]

method getConditionalStyles [line 1169]

PHPExcel_Style_Conditional[] getConditionalStyles(
[string
$pCoordinate = 'A1'])

Get conditional styles for a cell

Tags:

access:

public

Parameters:

string

$pCoordinate

[ Top ]

method getConditionalStylesCollection [line 1208]

array getConditionalStylesCollection(
)

Get collection of conditional styles

Tags:

access:

public

[ Top ]

method getDataValidation [line 2350]

void getDataValidation(
[string
$pCellCoordinate = 'A1'])

Get data validation

Tags:

access:

public

Parameters:

string

$pCellCoordinate

Cell coordinate to get data validation for

[ Top ]

method getDataValidationCollection [line 2395]

PHPExcel_Cell_DataValidation[] getDataValidationCollection(
)

Get collection of data validations

Tags:

access:

public

[ Top ]

method getDefaultColumnDimension [line 476]

PHPExcel_Worksheet_ColumnDimension getDefaultColumnDimension(
)

Get default column dimension

Tags:

access:

public

[ Top ]

method getDefaultRowDimension [line 456]

PHPExcel_Worksheet_RowDimension getDefaultRowDimension(
)

Get default row dimension

Tags:

access:

public

[ Top ]

method getDefaultStyle [line 1121]

PHPExcel_Style getDefaultStyle(
)

Get default style of workbork.

Tags:

deprecated:
throws:	Exception
access:	public

[ Top ]

method getDrawingCollection [line 486]

PHPExcel_Worksheet_BaseDrawing[] getDrawingCollection(
)

Get collection of drawings

Tags:

access:

public

[ Top ]

method getFreezePane [line 1646]

string getFreezePane(
)

Get Freeze Pane

Tags:

access:

public

[ Top ]

method getHashCode [line 2242]

string getHashCode(
)

Get hash code

Tags:

return:	Hash code
access:	public

[ Top ]

method getHeaderFooter [line 754]

PHPExcel_Worksheet_HeaderFooter getHeaderFooter(
)

Get page header/footer

Tags:

access:

public

[ Top ]

method getHighestColumn [line 820]

string getHighestColumn(
)

Get highest worksheet column

Tags:

return:	Highest column name
access:	public

[ Top ]

method getHighestRow [line 830]

int getHighestRow(
)

Get highest worksheet row

Tags:

return:	Highest row number
access:	public

[ Top ]

method getHyperlink [line 2295]

void getHyperlink(
[string
$pCellCoordinate = 'A1'])

Get hyperlink

Tags:

access:

public

Parameters:

string

$pCellCoordinate

Cell coordinate to get hyperlink for

[ Top ]

method getHyperlinkCollection [line 2340]

PHPExcel_Cell_Hyperlink[] getHyperlinkCollection(
)

Get collection of hyperlinks

Tags:

access:

public

[ Top ]

method getMergeCells [line 1486]

array[] getMergeCells(
)

Get merge cells array.

Tags:

access:

public

[ Top ]

method getPageMargins [line 732]

PHPExcel_Worksheet_PageMargins getPageMargins(
)

Get page margins

Tags:

access:

public

[ Top ]

method getPageSetup [line 710]

PHPExcel_Worksheet_PageSetup getPageSetup(
)

Get page setup

Tags:

access:

public

[ Top ]

method getParent [line 607]

PHPExcel getParent(
)

Get parent

Tags:

access:

public

[ Top ]

method getPrintGridlines [line 1824]

boolean getPrintGridlines(
)

Print gridlines?

Tags:

access:

public

[ Top ]

method getProtectedCells [line 1587]

array[] getProtectedCells(
)

Get protected cells

Tags:

access:

public

[ Top ]

method getProtection [line 798]

PHPExcel_Worksheet_Protection getProtection(
)

Get Protection

Tags:

access:

public

[ Top ]

method getRightToLeft [line 2046]

boolean getRightToLeft(
)

Get right-to-left

Tags:

access:

public

[ Top ]

method getRowDimension [line 1056]

PHPExcel_Worksheet_RowDimension getRowDimension(
[int
$pRow = 0])

Get row dimension at a specific row

Tags:

access:

public

Parameters:

int

$pRow

Numeric index of the row

[ Top ]

method getRowDimensions [line 446]

PHPExcel_Worksheet_RowDimension[] getRowDimensions(
)

Get collection of row dimensions

Tags:

access:

public

[ Top ]

method getRowIterator [line 2152]

PHPExcel_Worksheet_RowIterator getRowIterator(
)

Get row iterator

Tags:

access:

public

[ Top ]

method getSelectedCell [line 1958]

string getSelectedCell(
)

Get selected cell

Tags:

deprecated:
access:	public

[ Top ]

method getSelectedCells [line 1978]

string getSelectedCells(
)

Get selected cells

Tags:

access:

public

[ Top ]

method getSheetState [line 690]

string getSheetState(
)

Get sheet state

Tags:

return:	Sheet state (visible, hidden, veryHidden)
access:	public

[ Top ]

method getSheetView [line 776]

PHPExcel_Worksheet_HeaderFooter getSheetView(
)

Get sheet view

Tags:

access:

public

[ Top ]

method getShowGridlines [line 1804]

boolean getShowGridlines(
)

Show gridlines?

Tags:

access:

public

[ Top ]

method getShowRowColHeaders [line 1844]

boolean getShowRowColHeaders(
)

Show row and column headers?

Tags:

access:

public

[ Top ]

method getShowSummaryBelow [line 1864]

boolean getShowSummaryBelow(
)

Show summary below? (Row/Column outlining)

Tags:

access:

public

[ Top ]

method getShowSummaryRight [line 1884]

boolean getShowSummaryRight(
)

Show summary right? (Row/Column outlining)

Tags:

access:

public

[ Top ]

method getStyle [line 1152]

PHPExcel_Style getStyle(
[string
$pCellCoordinate = 'A1'])

Get style for cell

Tags:

throws:	Exception
access:	public

Parameters:

string

$pCellCoordinate

Cell coordinate to get style for

[ Top ]

method getStyleByColumnAndRow [line 1233]

PHPExcel_Style getStyleByColumnAndRow(
[int
$pColumn = 0], [int
$pRow = 0])

Get style for cell by using numeric cell coordinates

Tags:

access:

public

Parameters:

int	$pColumn	Numeric column coordinate of the cell
int	$pRow	Numeric row coordinate of the cell

[ Top ]

method getStyles [line 1109]

PHPExcel_Style[] getStyles(
)

Get styles

Tags:

access:

public

[ Top ]

method getTabColor [line 2433]

PHPExcel_Style_Color getTabColor(
)

Get tab color

Tags:

access:

public

[ Top ]

method getTitle [line 636]

string getTitle(
)

Get title

Tags:

access:

public

[ Top ]

method hyperlinkExists [line 2330]

boolean hyperlinkExists(
[
$pCoordinate = 'A1'], string
$pCellCoordinate)

Hyperlink at a specific coordinate exists?

Tags:

access:

public

Parameters:

string	$pCellCoordinate
	$pCoordinate

[ Top ]

method insertNewColumnBefore [line 1720]

PHPExcel_Worksheet insertNewColumnBefore(
[int
$pBefore = 'A'], [int
$pNumCols = 1])

Insert a new column, updating all possible related data

Tags:

throws:	Exception
access:	public

Parameters:

int	$pBefore	Insert before this one
int	$pNumCols	Number of columns to insert

[ Top ]

method insertNewColumnBeforeByIndex [line 1738]

PHPExcel_Worksheet insertNewColumnBeforeByIndex(
[int
$pBefore = 0], [int
$pNumCols = 1])

Insert a new column, updating all possible related data

Tags:

throws:	Exception
access:	public

Parameters:

int	$pBefore	Insert before this one (numeric column coordinate of the cell)
int	$pNumCols	Number of columns to insert

[ Top ]

method insertNewRowBefore [line 1702]

PHPExcel_Worksheet insertNewRowBefore(
[int
$pBefore = 1], [int
$pNumRows = 1])

Insert a new row, updating all possible related data

Tags:

throws:	Exception
access:	public

Parameters:

int	$pBefore	Insert before this one
int	$pNumRows	Number of rows to insert

[ Top ]

method isTabColorSet [line 2459]

boolean isTabColorSet(
)

Tab color set?

Tags:

access:

public

[ Top ]

method mergeCells [line 1392]

PHPExcel_Worksheet mergeCells(
[string
$pRange = 'A1:A1'])

Set merge on a cell range

Tags:

throws:	Exception
access:	public

Parameters:

string

$pRange

Cell range (e.g. A1:E1)

[ Top ]

method mergeCellsByColumnAndRow [line 1434]

PHPExcel_Worksheet mergeCellsByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 0], [int
$pColumn2 = 0], [int
$pRow2 = 0])

Set merge on a cell range by using numeric cell coordinates

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn1	Numeric column coordinate of the first cell
int	$pRow1	Numeric row coordinate of the first cell
int	$pColumn2	Numeric column coordinate of the last cell
int	$pRow2	Numeric row coordinate of the last cell

[ Top ]

method protectCells [line 1513]

PHPExcel_Worksheet protectCells(
[string
$pRange = 'A1'], [string
$pPassword = ''], [boolean
$pAlreadyHashed = false])

Set protection on a cell range

Tags:

throws:	Exception
access:	public

Parameters:

string	$pRange	Cell (e.g. A1) or cell range (e.g. A1:E1)
string	$pPassword	Password to unlock the protection
boolean	$pAlreadyHashed	If the password has already been hashed, set this to true

[ Top ]

method protectCellsByColumnAndRow [line 1538]

PHPExcel_Worksheet protectCellsByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 0], [int
$pColumn2 = 0], [int
$pRow2 = 0], [string
$pPassword = ''], [boolean
$pAlreadyHashed = false])

Set protection on a cell range by using numeric cell coordinates

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn1	Numeric column coordinate of the first cell
int	$pRow1	Numeric row coordinate of the first cell
int	$pColumn2	Numeric column coordinate of the last cell
int	$pRow2	Numeric row coordinate of the last cell
string	$pPassword	Password to unlock the protection
boolean	$pAlreadyHashed	If the password has already been hashed, set this to true

[ Top ]

method rebindParent [line 617]

PHPExcel_Worksheet rebindParent(

$parent)

Re-bind parent

Tags:

access:

public

Parameters:

PHPExcel

$parent

[ Top ]

method refreshColumnDimensions [line 496]

PHPExcel_Worksheet refreshColumnDimensions(
)

Refresh column dimensions

Tags:

access:

public

[ Top ]

method refreshRowDimensions [line 515]

PHPExcel_Worksheet refreshRowDimensions(
)

Refresh row dimensions

Tags:

access:

public

[ Top ]

method removeColumn [line 1772]

PHPExcel_Worksheet removeColumn(
[int
$pColumn = 'A'], [int
$pNumCols = 1])

Remove a column, updating all possible related data

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn	Remove starting with this one
int	$pNumCols	Number of columns to remove

[ Top ]

method removeColumnByIndex [line 1791]

PHPExcel_Worksheet removeColumnByIndex(
[int
$pColumn = 0], [int
$pNumCols = 1])

Remove a column, updating all possible related data

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn	Remove starting with this one (numeric column coordinate of the cell)
int	$pNumCols	Number of columns to remove

[ Top ]

method removeConditionalStyles [line 1197]

PHPExcel_Worksheet removeConditionalStyles(
[string
$pCoordinate = 'A1'])

Removes conditional styles for a cell

Tags:

access:

public

Parameters:

string

$pCoordinate

[ Top ]

method removeRow [line 1754]

PHPExcel_Worksheet removeRow(
[int
$pRow = 1], [int
$pNumRows = 1])

Delete a row, updating all possible related data

Tags:

throws:	Exception
access:	public

Parameters:

int	$pRow	Remove starting with this one
int	$pNumRows	Number of rows to remove

[ Top ]

method resetTabColor [line 2446]

PHPExcel_Worksheet resetTabColor(
)

Reset tab color

Tags:

access:

public

[ Top ]

method setAutoFilter [line 1609]

PHPExcel_Worksheet setAutoFilter(
[string
$pRange = ''])

Set Autofilter Range

Tags:

throws:	Exception
access:	public

Parameters:

string

$pRange

Cell range (i.e. A1:E10)

[ Top ]

method setAutoFilterByColumnAndRow [line 1632]

PHPExcel_Worksheet setAutoFilterByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 0], [int
$pColumn2 = 0], [int
$pRow2 = 0])

Set Autofilter Range by using numeric cell coordinates

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn1	Numeric column coordinate of the first cell
int	$pRow1	Numeric row coordinate of the first cell
int	$pColumn2	Numeric column coordinate of the second cell
int	$pRow2	Numeric row coordinate of the second cell

[ Top ]

method setBreak [line 1347]

PHPExcel_Worksheet setBreak(
[string
$pCell = 'A1'], [int
$pBreak = PHPExcel_Worksheet::BREAK_NONE])

Set break on a cell

Tags:

throws:	Exception
access:	public

Parameters:

string	$pCell	Cell coordinate (e.g. A1)
int	$pBreak	Break type (type of PHPExcel_Worksheet::BREAK_*)

[ Top ]

method setBreakByColumnAndRow [line 1370]

PHPExcel_Worksheet setBreakByColumnAndRow(
[int
$pColumn = 0], [int
$pRow = 0], [int
$pBreak = PHPExcel_Worksheet::BREAK_NONE])

Set break on a cell by using numeric cell coordinates

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn	Numeric column coordinate of the cell
int	$pRow	Numeric row coordinate of the cell
int	$pBreak	Break type (type of PHPExcel_Worksheet::BREAK_*)

[ Top ]

method setCellValue [line 842]

PHPExcel_Worksheet setCellValue(
[string
$pCoordinate = 'A1'], [mixed
$pValue = null])

Set a cell value

Tags:

access:

public

Parameters:

string	$pCoordinate	Coordinate of the cell
mixed	$pValue	Value of the cell

[ Top ]

method setCellValueByColumnAndRow [line 858]

PHPExcel_Worksheet setCellValueByColumnAndRow(
[string
$pColumn = 0], [string
$pRow = 0], [mixed
$pValue = null])

Set a cell value by using numeric cell coordinates

Tags:

access:

public

Parameters:

string	$pColumn	Numeric column coordinate of the cell
string	$pRow	Numeric row coordinate of the cell
mixed	$pValue	Value of the cell

[ Top ]

method setCellValueExplicit [line 871]

PHPExcel_Worksheet setCellValueExplicit(
[string
$pCoordinate = 'A1'], [mixed
$pValue = null], [string
$pDataType = PHPExcel_Cell_DataType::TYPE_STRING])

Set a cell value

Tags:

access:

public

Parameters:

string	$pCoordinate	Coordinate of the cell
mixed	$pValue	Value of the cell
string	$pDataType	Explicit data type

[ Top ]

method setCellValueExplicitByColumnAndRow [line 887]

PHPExcel_Worksheet setCellValueExplicitByColumnAndRow(
[string
$pColumn = 0], [string
$pRow = 0], [mixed
$pValue = null], [string
$pDataType = PHPExcel_Cell_DataType::TYPE_STRING])

Set a cell value by using numeric cell coordinates

Tags:

access:

public

Parameters:

string	$pColumn	Numeric column coordinate of the cell
string	$pRow	Numeric row coordinate of the cell
mixed	$pValue	Value of the cell
string	$pDataType	Explicit data type

[ Top ]

method setConditionalStyles [line 1220]

PHPExcel_Worksheet setConditionalStyles(
[$pCoordinate
$pCoordinate = 'A1'], $pValue
$pValue)

Set conditional styles

Tags:

access:

public

Parameters:

$pCoordinate	$pCoordinate	string E.g. 'A1'
$pValue	$pValue	PHPExcel_Style_Conditional[]

[ Top ]

method setDataValidation [line 2369]

PHPExcel_Worksheet setDataValidation(
[string
$pCellCoordinate = 'A1'], [
$pDataValidation = null])

Set data validation

Tags:

access:

public

Parameters:

string	$pCellCoordinate	Cell coordinate to insert data validation
PHPExcel_Cell_DataValidation	$pDataValidation

[ Top ]

method setDefaultStyle [line 1134]

PHPExcel_Worksheet setDefaultStyle(

$pValue, PHPExcel_Style
$value)

Set default style - should only be used by PHPExcel_IReader implementations!

Tags:

deprecated:
throws:	Exception
access:	public

Parameters:

PHPExcel_Style	$value
PHPExcel_Style	$pValue

[ Top ]

method setHeaderFooter [line 765]

PHPExcel_Worksheet setHeaderFooter(
PHPExcel_Worksheet_HeaderFooter
$pValue)

Set page header/footer

Tags:

access:

public

Parameters:

PHPExcel_Worksheet_HeaderFooter

$pValue

[ Top ]

method setHyperlink [line 2314]

PHPExcel_Worksheet setHyperlink(
[string
$pCellCoordinate = 'A1'], [
$pHyperlink = null])

Set hyperlnk

Tags:

access:

public

Parameters:

string	$pCellCoordinate	Cell coordinate to insert hyperlink
PHPExcel_Cell_Hyperlink	$pHyperlink

[ Top ]

method setMergeCells [line 1497]

void setMergeCells(
[array
$pValue = array()])

Set merge cells array for the entire sheet. Use instead mergeCells() to merge a single cell range.

Tags:

access:

public

Parameters:

array

$pValue

[ Top ]

method setPageMargins [line 743]

PHPExcel_Worksheet setPageMargins(
PHPExcel_Worksheet_PageMargins
$pValue)

Set page margins

Tags:

access:

public

Parameters:

PHPExcel_Worksheet_PageMargins

$pValue

[ Top ]

method setPageSetup [line 721]

PHPExcel_Worksheet setPageSetup(
PHPExcel_Worksheet_PageSetup
$pValue)

Set page setup

Tags:

access:

public

Parameters:

PHPExcel_Worksheet_PageSetup

$pValue

[ Top ]

method setPrintGridlines [line 1834]

PHPExcel_Worksheet setPrintGridlines(
[boolean
$pValue = false])

Set print gridlines

Tags:

access:

public

Parameters:

boolean

$pValue

Print gridlines (true/false)

[ Top ]

method setProtection [line 809]

PHPExcel_Worksheet setProtection(
PHPExcel_Worksheet_Protection
$pValue)

Set Protection

Tags:

access:

public

Parameters:

PHPExcel_Worksheet_Protection

$pValue

[ Top ]

method setRightToLeft [line 2056]

PHPExcel_Worksheet setRightToLeft(
[boolean
$value = false])

Set right-to-left

Tags:

access:

public

Parameters:

boolean

$value

Right-to-left true/false

[ Top ]

method setSelectedCell [line 1989]

PHPExcel_Worksheet setSelectedCell(
[
$pCoordinate = 'A1'], string
$pCell)

Selected cell

Tags:

access:

public

Parameters:

string	$pCell	Cell (i.e. A1)
	$pCoordinate

[ Top ]

method setSelectedCellByColumnAndRow [line 2036]

PHPExcel_Worksheet setSelectedCellByColumnAndRow(
[int
$pColumn = 0], [int
$pRow = 0])

Selected cell by using numeric cell coordinates

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn	Numeric column coordinate of the cell
int	$pRow	Numeric row coordinate of the cell

[ Top ]

method setSelectedCells [line 2001]

PHPExcel_Worksheet setSelectedCells(
[string
$pCoordinate = 'A1'])

Select a range of cells.

Tags:

throws:	Exception
access:	public

Parameters:

string

$pCoordinate

Cell range, examples: 'A1', 'B2:G5', 'A:C', '3:6'

[ Top ]

method setSharedStyle [line 1249]

PHPExcel_Worksheet setSharedStyle(
[
$pSharedCellStyle = null], [string
$pRange = ''])

Set shared cell style to a range of cells

Please note that this will overwrite existing cell styles for cells in range!

Tags:

deprecated:
throws:	Exception
access:	public

Parameters:

PHPExcel_Style	$pSharedCellStyle	Cell style to share
string	$pRange	Range of cells (i.e. "A1:B10"), or just one cell (i.e. "A1")

[ Top ]

method setSheetState [line 700]

PHPExcel_Worksheet setSheetState(
[string
$value = PHPExcel_Worksheet::SHEETSTATE_VISIBLE])

Set sheet state

Tags:

access:

public

Parameters:

string

$value

Sheet state (visible, hidden, veryHidden)

[ Top ]

method setSheetView [line 787]

PHPExcel_Worksheet setSheetView(
PHPExcel_Worksheet_SheetView
$pValue)

Set sheet view

Tags:

access:

public

Parameters:

PHPExcel_Worksheet_SheetView

$pValue

[ Top ]

method setShowGridlines [line 1814]

PHPExcel_Worksheet setShowGridlines(
[boolean
$pValue = false])

Set show gridlines

Tags:

access:

public

Parameters:

boolean

$pValue

Show gridlines (true/false)

[ Top ]

method setShowRowColHeaders [line 1854]

PHPExcel_Worksheet setShowRowColHeaders(
[boolean
$pValue = false])

Set show row and column headers

Tags:

access:

public

Parameters:

boolean

$pValue

Show row and column headers (true/false)

[ Top ]

method setShowSummaryBelow [line 1874]

PHPExcel_Worksheet setShowSummaryBelow(
[boolean
$pValue = true])

Set show summary below

Tags:

access:

public

Parameters:

boolean

$pValue

Show summary below (true/false)

[ Top ]

method setShowSummaryRight [line 1894]

PHPExcel_Worksheet setShowSummaryRight(
[boolean
$pValue = true])

Set show summary right

Tags:

access:

public

Parameters:

boolean

$pValue

Show summary right (true/false)

[ Top ]

method setTitle [line 647]

PHPExcel_Worksheet setTitle(
[string
$pValue = 'Worksheet'])

Set title

Tags:

access:

public

Parameters:

string

$pValue

String containing the dimension of this worksheet

[ Top ]

method shrinkRangeToFit [line 2406]

string shrinkRangeToFit(
string
$range)

Accepts a range, returning it as a range that falls within the current highest row and column of the worksheet

Tags:

return:	Adjusted range value
access:	public

Parameters:

string

$range

[ Top ]

method sortCellCollection [line 430]

PHPExcel_Worksheet sortCellCollection(
)

Sort collection of cells

Tags:

access:

public

[ Top ]

method toArray [line 2103]

array toArray(
[mixed
$nullValue = null], [boolean
$calculateFormulas = true])

Create array from worksheet

Tags:

access:

public

Parameters:

mixed	$nullValue	Value treated as "null"
boolean	$calculateFormulas	Should formulas be calculated?

[ Top ]

method unfreezePane [line 1689]

PHPExcel_Worksheet unfreezePane(
)

Unfreeze Pane

Tags:

access:

public

[ Top ]

method unmergeCells [line 1447]

PHPExcel_Worksheet unmergeCells(
[string
$pRange = 'A1:A1'])

Remove merge on a cell range

Tags:

throws:	Exception
access:	public

Parameters:

string

$pRange

Cell range (e.g. A1:E1)

[ Top ]

method unmergeCellsByColumnAndRow [line 1475]

PHPExcel_Worksheet unmergeCellsByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 0], [int
$pColumn2 = 0], [int
$pRow2 = 0])

Remove merge on a cell range by using numeric cell coordinates

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn1	Numeric column coordinate of the first cell
int	$pRow1	Numeric row coordinate of the first cell
int	$pColumn2	Numeric column coordinate of the last cell
int	$pRow2	Numeric row coordinate of the last cell

[ Top ]

method unprotectCells [line 1551]

PHPExcel_Worksheet unprotectCells(
[string
$pRange = 'A1'])

Remove protection on a cell range

Tags:

throws:	Exception
access:	public

Parameters:

string

$pRange

Cell (e.g. A1) or cell range (e.g. A1:E1)

[ Top ]

method unprotectCellsByColumnAndRow [line 1576]

PHPExcel_Worksheet unprotectCellsByColumnAndRow(
[int
$pColumn1 = 0], [int
$pRow1 = 0], [int
$pColumn2 = 0], [int
$pRow2 = 0], [string
$pPassword = ''], [boolean
$pAlreadyHashed = false])

Remove protection on a cell range by using numeric cell coordinates

Tags:

throws:	Exception
access:	public

Parameters:

int	$pColumn1	Numeric column coordinate of the first cell
int	$pRow1	Numeric row coordinate of the first cell
int	$pColumn2	Numeric column coordinate of the last cell
int	$pRow2	Numeric row coordinate of the last cell
string	$pPassword	Password to unlock the protection
boolean	$pAlreadyHashed	If the password has already been hashed, set this to true

[ Top ]

method __clone [line 2478]

void __clone(
)

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

Tags:

access:

public

[ Top ]

Class: PHPExcel_Worksheet

Class Overview

Author(s):

Copyright:

Constants

Methods

Class Details

Tags:

Class Methods

static method extractSheetTitle [line 2262]

Tags:

Parameters:

static method getInvalidCharacters [line 379]

Tags:

constructor __construct [line 313]

Tags:

Parameters:

method calculateColumnWidths [line 546]

Tags:

Parameters:

method calculateWorksheetDimension [line 534]

Tags:

method cellExists [line 998]

Tags:

Parameters:

method cellExistsByColumnAndRow [line 1045]

Tags:

Parameters:

method conditionalStylesExists [line 1183]

Tags:

Parameters:

method copy [line 2469]

Tags:

method dataValidationExists [line 2385]

Tags:

Parameters:

method disconnectCells [line 356]

Tags:

method duplicateStyle [line 1265]

Tags:

Parameters:

method duplicateStyleArray [line 1333]

Tags:

Parameters:

method freezePane [line 1658]

Tags:

Parameters:

method freezePaneByColumnAndRow [line 1679]

Tags:

Parameters:

method fromArray [line 2069]

Tags:

Parameters:

method garbageCollect [line 2161]

Tags:

method getActiveCell [line 1968]

Tags:

method getAutoFilter [line 1597]

Tags:

method getBreaks [line 1380]

Tags:

method getCell [line 899]

Tags:

Parameters:

method getCellByColumnAndRow [line 970]

Tags:

Parameters:

method getCellCacheController [line 369]

Tags:

method getCellCollection [line 412]

Tags:

Parameters:

method getColumnDimension [line 1077]

Tags:

Parameters:

method getColumnDimensionByColumn [line 1099]

Tags:

Parameters:

method getColumnDimensions [line 466]

Tags: