Class PHPExcel_Worksheet
PHPExcel_Worksheet
- PHPExcel_Worksheet implements PHPExcel_IComparable
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Worksheet.php
public
|
|
public
|
#
disconnectCells( )
Disconnect all cells from this PHPExcel_Worksheet object, typically so that the worksheet object can be unset |
public
|
|
public
PHPExcel_CachedObjectStorage_xxx
|
|
public static
array
|
|
private static
string
|
|
private static
string
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
integer
|
|
public
false|
|
|
public
string[]
|
|
public
false|
|
|
public
|
|
public
|
|
public
string
|
|
public
string
|
|
public
PHPExcel_Worksheet;
|
#
calculateColumnWidths( boolean $calculateMergeCells = false )
Calculate widths for auto-size columns |
public
|
|
public
|
|
public
string
|
|
public
|
|
public
string
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
string
|
|
public
string
|
|
public
integer
|
|
public
string
|
|
public
array
|
|
public
|
#
setCellValue( string $pCoordinate = 'A1', mixed $pValue = null, boolean $returnCell = false )
Set a cell value |
public
|
#
setCellValueByColumnAndRow( string $pColumn = 0, string $pRow = 1, mixed $pValue = null, boolean $returnCell = false )
Set a cell value by using numeric cell coordinates |
public
|
#
setCellValueExplicit( string $pCoordinate = 'A1', mixed $pValue = null, string $pDataType =
Set a cell value |
public
|
#
setCellValueExplicitByColumnAndRow( string $pColumn = 0, string $pRow = 1, mixed $pValue = null, string $pDataType =
Set a cell value by using numeric cell coordinates |
public
|
|
public
|
#
getCellByColumnAndRow( string $pColumn = 0, string $pRow = 1 )
Get cell at a specific coordinate by using numeric cell coordinates |
private
|
|
public
boolean
|
|
public
boolean
|
#
cellExistsByColumnAndRow( string $pColumn = 0, string $pRow = 1 )
Cell at a specific coordinate by using numeric cell coordinates exists? |
public
|
|
public
|
#
getColumnDimension( string $pColumn = 'A', $create = TRUE )
Get column dimension at a specific column |
public
|
#
getColumnDimensionByColumn( string $pColumn = 0 )
Get column dimension at a specific column by using numeric cell coordinates |
public
|
|
public
|
|
public
|
#
setDefaultStyle(
Set default style - should only be used by PHPExcel_IReader implementations! |
public
|
|
public
|
|
public
boolean
|
|
public
|
|
public
array
|
|
public
|
|
public
|
#
getStyleByColumnAndRow( integer $pColumn = 0, integer $pRow = 1 )
Get style for cell by using numeric cell coordinates |
public
|
#
setSharedStyle(
Set shared cell style to a range of cells |
public
|
#
duplicateStyle(
Duplicate cell style to a range of cells |
public
|
#
duplicateConditionalStyle( array $pCellStyle = null, string $pRange = '' )
Duplicate conditional style to a range of cells |
public
|
#
duplicateStyleArray( array $pStyles = null, string $pRange = '', boolean $pAdvanced = true )
Duplicate cell style array to a range of cells |
public
|
#
setBreak( string $pCell = 'A1', integer $pBreak =
Set break on a cell |
public
|
#
setBreakByColumnAndRow( integer $pColumn = 0, integer $pRow = 1, integer $pBreak =
Set break on a cell by using numeric cell coordinates |
public
array[]
|
|
public
|
|
public
|
#
mergeCellsByColumnAndRow( integer $pColumn1 = 0, integer $pRow1 = 1, integer $pColumn2 = 0, integer $pRow2 = 1 )
Set merge on a cell range by using numeric cell coordinates |
public
|
|
public
|
#
unmergeCellsByColumnAndRow( integer $pColumn1 = 0, integer $pRow1 = 1, integer $pColumn2 = 0, integer $pRow2 = 1 )
Remove merge on a cell range by using numeric cell coordinates |
public
array[]
|
|
public
|
#
setMergeCells( array $pValue = array() )
Set merge cells array for the entire sheet. Use instead mergeCells() to merge a single cell range. |
public
|
#
protectCells( string $pRange = 'A1', string $pPassword = '', boolean $pAlreadyHashed = false )
Set protection on a cell range |
public
|
#
protectCellsByColumnAndRow( integer $pColumn1 = 0, integer $pRow1 = 1, integer $pColumn2 = 0, integer $pRow2 = 1, string $pPassword = '', boolean $pAlreadyHashed = false )
Set protection on a cell range by using numeric cell coordinates |
public
|
|
public
|
#
unprotectCellsByColumnAndRow( integer $pColumn1 = 0, integer $pRow1 = 1, integer $pColumn2 = 0, integer $pRow2 = 1, string $pPassword = '', boolean $pAlreadyHashed = false )
Remove protection on a cell range by using numeric cell coordinates |
public
array[]
|
|
public
|
|
public
|
|
public
|
#
setAutoFilterByColumnAndRow( integer $pColumn1 = 0, integer $pRow1 = 1, integer $pColumn2 = 0, integer $pRow2 = 1 )
Set Autofilter Range by using numeric cell coordinates |
public
|
|
public
string
|
|
public
|
|
public
|
#
freezePaneByColumnAndRow( integer $pColumn = 0, integer $pRow = 1 )
Freeze Pane by using numeric cell coordinates |
public
|
|
public
|
#
insertNewRowBefore( integer $pBefore = 1, integer $pNumRows = 1 )
Insert a new row, updating all possible related data |
public
|
#
insertNewColumnBefore( integer $pBefore = 'A', integer $pNumCols = 1 )
Insert a new column, updating all possible related data |
public
|
#
insertNewColumnBeforeByIndex( integer $pBefore = 0, integer $pNumCols = 1 )
Insert a new column, updating all possible related data |
public
|
|
public
|
#
removeColumn( integer $pColumn = 'A', integer $pNumCols = 1 )
Remove a column, updating all possible related data |
public
|
#
removeColumnByIndex( integer $pColumn = 0, integer $pNumCols = 1 )
Remove a column, updating all possible related data |
public
boolean
|
|
public
|
|
public
boolean
|
|
public
|
|
public
boolean
|
|
public
|
|
public
boolean
|
|
public
|
|
public
boolean
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
#
getCommentByColumnAndRow( integer $pColumn = 0, integer $pRow = 1 )
Get comment for cell by using numeric cell coordinates |
public
string
|
|
public
string
|
|
public
string
|
|
public
|
|
public
|
|
public
|
#
setSelectedCellByColumnAndRow( integer $pColumn = 0, integer $pRow = 1 )
Selected cell by using numeric cell coordinates |
public
boolean
|
|
public
|
|
public
|
|
public
array
|
#
rangeToArray( string $pRange = 'A1', mixed $nullValue = null, boolean $calculateFormulas = true, boolean $formatData = true, boolean $returnCellRef = false )
Create array from a range of cells |
public
array
|
#
namedRangeToArray( string $pNamedRange = '', mixed $nullValue = null, boolean $calculateFormulas = true, boolean $formatData = true, boolean $returnCellRef = false )
Create array from a range of cells |
public
array
|
|
public
|
|
public
|
|
public
string
|
|
public static
mixed
|
#
extractSheetTitle( string $pRange, boolean $returnRange = false )
Extract worksheet title from range. |
public
|
|
public
|
#
setHyperlink( string $pCellCoordinate = 'A1',
Set hyperlnk |
public
boolean
|
|
public
|
|
public
|
|
public
|
#
setDataValidation( string $pCellCoordinate = 'A1',
Set data validation |
public
boolean
|
#
dataValidationExists( string $pCoordinate = 'A1' )
Data validation at a specific coordinate exists? |
public
|
|
public
string
|
#
shrinkRangeToFit( string $range )
Accepts a range, returning it as a range that falls within the current highest row and column of the worksheet |
public
|
|
public
|
|
public
boolean
|
|
public
|
|
public
|
|
public
objWorksheet
|
|
public
null|string
|
|
public
boolean
|
integer |
BREAK_NONE
|
#
0
|
integer |
BREAK_ROW
|
#
1
|
integer |
BREAK_COLUMN
|
#
2
|
string |
SHEETSTATE_VISIBLE
|
#
'visible'
|
string |
SHEETSTATE_HIDDEN
|
#
'hidden'
|
string |
SHEETSTATE_VERYHIDDEN
|
#
'veryHidden'
|
private static
array
|
$_invalidCharacters
Invalid characters in sheet title |
#
array('*', ':', '/', '\\', '?', '[', ']')
|
private
|
$_parent
Parent spreadsheet |
|
private
PHPExcel_CachedObjectStorage_xxx
|
$_cellCollection
Cacheable collection of cells |
#
null
|
private
|
$_rowDimensions
Collection of row dimensions |
#
array()
|
private
|
$_defaultRowDimension
Default row dimension |
#
null
|
private
|
$_columnDimensions
Collection of column dimensions |
#
array()
|
private
|
$_defaultColumnDimension
Default column dimension |
#
null
|
private
|
$_drawingCollection
Collection of drawings |
#
null
|
private
|
$_chartCollection
Collection of Chart objects |
#
array()
|
private
string
|
$_title
Worksheet title |
|
private
string
|
$_sheetState
Sheet state |
|
private
|
$_pageSetup
Page setup |
|
private
|
$_pageMargins
Page margins |
|
private
|
$_headerFooter
Page header/footer |
|
private
|
$_sheetView
Sheet view |
|
private
|
$_protection
Protection |
|
private
|
$_styles
Collection of styles |
#
array()
|
private
array
|
$_conditionalStylesCollection
Conditional styles. Indexed by cell coordinate, e.g. 'A1' |
#
array()
|
private
boolean
|
$_cellCollectionIsSorted
Is the current cell collection sorted already? |
#
false
|
private
array
|
$_breaks
Collection of breaks |
#
array()
|
private
array
|
$_mergeCells
Collection of merged cell ranges |
#
array()
|
private
array
|
$_protectedCells
Collection of protected cell ranges |
#
array()
|
private
|
$_autoFilter
Autofilter Range and selection |
#
NULL
|
private
string
|
$_freezePane
Freeze pane |
#
''
|
private
boolean
|
$_showGridlines
Show gridlines? |
#
true
|
private
boolean
|
$_printGridlines
Print gridlines? |
#
false
|
private
boolean
|
$_showRowColHeaders
Show row and column headers? |
#
true
|
private
boolean
|
$_showSummaryBelow
Show summary below? (Row/Column outline) |
#
true
|
private
boolean
|
$_showSummaryRight
Show summary right? (Row/Column outline) |
#
true
|
private
|
$_comments
Collection of comments |
#
array()
|
private
string
|
$_activeCell
Active cell. (Only one!) |
#
'A1'
|
private
string
|
$_selectedCells
Selected cells |
#
'A1'
|
private
string
|
$_cachedHighestColumn
Cached highest column |
#
'A'
|
private
integer
|
$_cachedHighestRow
Cached highest row |
#
1
|
private
boolean
|
$_rightToLeft
Right-to-left? |
#
false
|
private
array
|
$_hyperlinkCollection
Hyperlinks. Indexed by cell coordinate, e.g. 'A1' |
#
array()
|
private
array
|
$_dataValidationCollection
Data validation objects. Indexed by cell coordinate, e.g. 'A1' |
#
array()
|
private
|
$_tabColor
Tab color |
|
private
boolean
|
$_dirty
Dirty flag |
#
true
|
private
string
|
$_hash
Hash |
#
null
|
private
string
|
$_codeName
CodeName |
#
null
|