A

Financial::ACCRINT() — Method in class Financial
ACCRINT.
Financial::ACCRINTM() — Method in class Financial
ACCRINTM.
Financial::AMORDEGRC() — Method in class Financial
AMORDEGRC.
Financial::AMORLINC() — Method in class Financial
AMORLINC.
MathTrig::ATAN2() — Method in class MathTrig
ATAN2.
MathTrig::ACOT() — Method in class MathTrig
ACOT.
MathTrig::ACOTH() — Method in class MathTrig
ACOTH.
Statistical::AVEDEV() — Method in class Statistical
AVEDEV.
Statistical::AVERAGE() — Method in class Statistical
AVERAGE.
Statistical::AVERAGEA() — Method in class Statistical
AVERAGEA.
Statistical::AVERAGEIF() — Method in class Statistical
AVERAGEIF.
TextData::ASCIICODE() — Method in class TextData
ASCIICODE.
AdvancedValueBinderClass in namespace PhpOffice\PhpSpreadsheet\Cell
Cell::attach() — Method in class Cell
Coordinate::absoluteReference() — Method in class Coordinate
Make string row, column or cell coordinate absolute.
Coordinate::absoluteCoordinate() — Method in class Coordinate
Make string coordinate absolute.
AxisClass in namespace PhpOffice\PhpSpreadsheet\Chart
Created by PhpStorm.
Cells::add() — Method in class Cells
Add or update a cell identified by its coordinate into the collection.
HashTable::addFromSource() — Method in class HashTable
Add HashTable items from source.
HashTable::add() — Method in class HashTable
Add HashTable item.
MD5::add() — Method in class MD5
Add data to context.
ReferenceHelper::adjustPageBreaks() — Method in class ReferenceHelper
Update page breaks when inserting/deleting rows/columns.
ReferenceHelper::adjustComments() — Method in class ReferenceHelper
Update cell comments when inserting/deleting rows/columns.
ReferenceHelper::adjustHyperlinks() — Method in class ReferenceHelper
Update hyperlinks when inserting/deleting rows/columns.
ReferenceHelper::adjustDataValidations() — Method in class ReferenceHelper
Update data validations when inserting/deleting rows/columns.
ReferenceHelper::adjustMergeCells() — Method in class ReferenceHelper
Update merged cells when inserting/deleting rows/columns.
ReferenceHelper::adjustProtectedCells() — Method in class ReferenceHelper
Update protected cells when inserting/deleting rows/columns.
ReferenceHelper::adjustColumnDimensions() — Method in class ReferenceHelper
Update column dimensions when inserting/deleting rows/columns.
ReferenceHelper::adjustRowDimensions() — Method in class ReferenceHelper
Update row dimensions when inserting/deleting rows/columns.
RichText::addText() — Method in class RichText
Add text.
Drawing::angleToDegrees() — Method in class Drawing
Convert angle to degrees.
SpgrContainer::addChild() — Method in class SpgrContainer
Add a child. This will be either spgrContainer or spContainer.
BstoreContainer::addBSE() — Method in class BstoreContainer
Add a BLIP Store Entry.
File::assertFile() — Method in class File
Assert that given path is an existing file and is readable, otherwise throw exception.
$Matrix#AProperty in class Matrix
Matrix storage.
Matrix::arrayTimes() — Method in class Matrix
arrayTimes.
Matrix::arrayTimesEquals() — Method in class Matrix
arrayTimesEquals.
Matrix::arrayRightDivide() — Method in class Matrix
arrayRightDivide.
Matrix::arrayRightDivideEquals() — Method in class Matrix
arrayRightDivideEquals.
Matrix::arrayLeftDivide() — Method in class Matrix
arrayLeftDivide.
Matrix::arrayLeftDivideEquals() — Method in class Matrix
arrayLeftDivideEquals.
OLE::ascToUcs() — Method in class OLE
Utility function to transform ASCII text to Unicode.
File::append() — Method in class File
Append data to PPS.
$BestFit#adjustToZeroProperty in class BestFit
Flag indicating whether values should be adjusted to Y=0.
Spreadsheet::addSheet() — Method in class Spreadsheet
Add sheet.
Spreadsheet::addExternalSheet() — Method in class Spreadsheet
Add external sheet.
Spreadsheet::addNamedRange() — Method in class Spreadsheet
Add named range.
Spreadsheet::addCellXf() — Method in class Spreadsheet
Add a cellXf to the workbook.
Spreadsheet::addCellStyleXf() — Method in class Spreadsheet
Add a cellStyleXf to the workbook.
AlignmentClass in namespace PhpOffice\PhpSpreadsheet\Style
Alignment::applyFromArray() — Method in class Alignment
Apply styles from array.
Border::applyFromArray() — Method in class Border
Apply styles from array.
$Borders#allBordersProperty in class Borders
All borders pseudo-border. Only applies to supervisor.
Borders::applyFromArray() — Method in class Borders
Apply styles from array.
$Color#argbProperty in class Color
ARGB - Alpha RGB.
Color::applyFromArray() — Method in class Color
Apply styles from array.
Conditional::addCondition() — Method in class Conditional
Add Condition.
Fill::applyFromArray() — Method in class Fill
Apply styles from array.
Font::applyFromArray() — Method in class Font
Apply styles from array.
NumberFormat::applyFromArray() — Method in class NumberFormat
Apply styles from array.
Protection::applyFromArray() — Method in class Protection
Apply styles from array.
$Style#alignmentProperty in class Style
Alignment.
Style::applyFromArray() — Method in class Style
Apply styles from array.
AutoFilterClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
Column::addRule() — Method in class Column
Add a new AutoFilter Column Rule to the ruleset.
CellIterator::adjustForExistingOnlyRange() — Method in class CellIterator
Validate start/end values for "IterateOnlyExistingCells" mode, and adjust if necessary.
ColumnCellIterator::adjustForExistingOnlyRange() — Method in class ColumnCellIterator
Validate start/end values for "IterateOnlyExistingCells" mode, and adjust if necessary.
HeaderFooter::addImage() — Method in class HeaderFooter
Add header/footer image.
PageSetup::addPrintArea() — Method in class PageSetup
Add a new print area (e.g. 'A1:D10' or 'A1:D10,G5:M20') to the list of print areas.
PageSetup::addPrintAreaByColumnAndRow() — Method in class PageSetup
Add a new print area to the list of print areas.
RowCellIterator::adjustForExistingOnlyRange() — Method in class RowCellIterator
Validate start/end values for "IterateOnlyExistingCells" mode, and adjust if necessary.
Worksheet::addChart() — Method in class Worksheet
Add chart.
BIFFwriter::append() — Method in class BIFFwriter
General storage function.
Workbook::addXfWriter() — Method in class Workbook
Add a new XF writer.
Workbook::addFont() — Method in class Workbook
Add a font to added fonts.
Drawing::allDrawings() — Method in class Drawing
Get an array of all drawings.
Style::allStyles() — Method in class Style
Get an array of all styles.
Style::allConditionalStyles() — Method in class Style
Get an array of all conditional styles.
Style::allFills() — Method in class Style
Get an array of all fills.
Style::allFonts() — Method in class Style
Get an array of all fonts.
Style::allBorders() — Method in class Style
Get an array of all borders.
Style::allNumberFormats() — Method in class Style
Get an array of all number formats.

B

Engineering::BESSELI() — Method in class Engineering
BESSELI.
Engineering::BESSELJ() — Method in class Engineering
BESSELJ.
Engineering::BESSELK() — Method in class Engineering
BESSELK.
Engineering::BESSELY() — Method in class Engineering
BESSELY.
Engineering::BINTODEC() — Method in class Engineering
BINTODEC.
Engineering::BINTOHEX() — Method in class Engineering
BINTOHEX.
Engineering::BINTOOCT() — Method in class Engineering
BINTOOCT.
Engineering::BITAND() — Method in class Engineering
BITAND.
Engineering::BITOR() — Method in class Engineering
BITOR.
Engineering::BITXOR() — Method in class Engineering
BITXOR.
Engineering::BITLSHIFT() — Method in class Engineering
BITLSHIFT.
Engineering::BITRSHIFT() — Method in class Engineering
BITRSHIFT.
Statistical::BETADIST() — Method in class Statistical
BETADIST.
Statistical::BETAINV() — Method in class Statistical
BETAINV.
Statistical::BINOMDIST() — Method in class Statistical
BINOMDIST.
AdvancedValueBinder::bindValue() — Method in class AdvancedValueBinder
Bind value to a cell.
Coordinate::buildRange() — Method in class Coordinate
Build range from coordinate strings.
DefaultValueBinder::bindValue() — Method in class DefaultValueBinder
Bind value to a cell.
IValueBinder::bindValue() — Method in class IValueBinder
Bind value to a cell.
$Html#boldProperty in class Html
Html::buildTextRun() — Method in class Html
Html::breakTag() — Method in class Html
BaseReaderClass in namespace PhpOffice\PhpSpreadsheet\Reader
BIFF5Class in namespace PhpOffice\PhpSpreadsheet\Reader\Xls\Color
BIFF8Class in namespace PhpOffice\PhpSpreadsheet\Reader\Xls\Color
BuiltInClass in namespace PhpOffice\PhpSpreadsheet\Reader\Xls\Color
BorderClass in namespace PhpOffice\PhpSpreadsheet\Reader\Xls\Style
BstoreContainerClass in namespace PhpOffice\PhpSpreadsheet\Shared\Escher\DggContainer
BSEClass in namespace PhpOffice\PhpSpreadsheet\Shared\Escher\DggContainer\BstoreContainer
BlipClass in namespace PhpOffice\PhpSpreadsheet\Shared\Escher\DggContainer\BstoreContainer\BSE
$OLE#bbatProperty in class OLE
Big Block Allocation Table.
$OLE#bigBlockSizeProperty in class OLE
Size of big blocks. This is usually 512.
$OLE#bigBlockThresholdProperty in class OLE
Threshold for big blocks.
BestFitClass in namespace PhpOffice\PhpSpreadsheet\Shared\Trend
$BestFit#bestFitTypeProperty in class BestFit
Algorithm type to use for best-fit.
$ExponentialBestFit#bestFitTypeProperty in class ExponentialBestFit
Algorithm type to use for best-fit (Name of this Trend class).
$LinearBestFit#bestFitTypeProperty in class LinearBestFit
Algorithm type to use for best-fit (Name of this Trend class).
$LogarithmicBestFit#bestFitTypeProperty in class LogarithmicBestFit
Algorithm type to use for best-fit (Name of this Trend class).
$PolynomialBestFit#bestFitTypeProperty in class PolynomialBestFit
Algorithm type to use for best-fit (Name of this Trend class).
$PowerBestFit#bestFitTypeProperty in class PowerBestFit
Algorithm type to use for best-fit (Name of this Trend class).
BorderClass in namespace PhpOffice\PhpSpreadsheet\Style
$Border#borderStyleProperty in class Border
Border style.
BordersClass in namespace PhpOffice\PhpSpreadsheet\Style
$Borders#bottomProperty in class Borders
Bottom.
$Font#boldProperty in class Font
Bold.
$NumberFormat#builtInFormatsProperty in class NumberFormat
Excel built-in number formats.
$NumberFormat#builtInFormatCodeProperty in class NumberFormat
Built-in format Code.
NumberFormat::builtInFormatCode() — Method in class NumberFormat
Get built-in format code.
NumberFormat::builtInFormatCodeIndex() — Method in class NumberFormat
Get built-in format code index.
$Style#bordersProperty in class Style
Borders.
Supervisor::bindParent() — Method in class Supervisor
Bind parent. Only used for supervisor.
BaseDrawingClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
BaseWriterClass in namespace PhpOffice\PhpSpreadsheet\Writer
Html::buildCSS() — Method in class Html
Build CSS styles.
BIFFwriterClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xls

C

CalculationClass in namespace PhpOffice\PhpSpreadsheet\Calculation
$Calculation#cyclicFormulaCountProperty in class Calculation
Number of iterations for cyclic formulae.
Calculation::clearCalculationCache() — Method in class Calculation
Clear calculation cache.
Calculation::clearCalculationCacheForWorksheet() — Method in class Calculation
Clear calculation cache for a specified worksheet.
Calculation::calculate() — Method in class Calculation
Calculate cell value (using formula from a cell ID) Retained for backward compatibility.
Calculation::calculateCellValue() — Method in class Calculation
Calculate the value of a cell formula.
Calculation::calculateFormula() — Method in class Calculation
Calculate the value of a formula.
CategoryClass in namespace PhpOffice\PhpSpreadsheet\Calculation
CyclicReferenceStackClass in namespace PhpOffice\PhpSpreadsheet\Calculation\Engine
CyclicReferenceStack::count() — Method in class CyclicReferenceStack
Return the number of entries on the stack.
CyclicReferenceStack::clear() — Method in class CyclicReferenceStack
Clear the stack.
Logger::clearLog() — Method in class Logger
Clear the calculation engine debug log.
Engineering::COMPLEX() — Method in class Engineering
COMPLEX.
Engineering::CONVERTUOM() — Method in class Engineering
CONVERTUOM.
Financial::COUPDAYBS() — Method in class Financial
COUPDAYBS.
Financial::COUPDAYS() — Method in class Financial
COUPDAYS.
Financial::COUPDAYSNC() — Method in class Financial
COUPDAYSNC.
Financial::COUPNCD() — Method in class Financial
COUPNCD.
Financial::COUPNUM() — Method in class Financial
COUPNUM.
Financial::COUPPCD() — Method in class Financial
COUPPCD.
Financial::CUMIPMT() — Method in class Financial
CUMIPMT.
Financial::CUMPRINC() — Method in class Financial
CUMPRINC.
$Functions#compatibilityModeProperty in class Functions
Compatibility mode to use for error checking and responses.
LookupRef::cellAddress() — Method in class LookupRef
CELL_ADDRESS.
LookupRef::COLUMN() — Method in class LookupRef
COLUMN.
LookupRef::COLUMNS() — Method in class LookupRef
COLUMNS.
LookupRef::CHOOSE() — Method in class LookupRef
CHOOSE.
MathTrig::CEILING() — Method in class MathTrig
CEILING.
MathTrig::COMBIN() — Method in class MathTrig
COMBIN.
MathTrig::CSC() — Method in class MathTrig
CSC.
MathTrig::CSCH() — Method in class MathTrig
CSCH.
MathTrig::COT() — Method in class MathTrig
COT.
MathTrig::COTH() — Method in class MathTrig
COTH.
Statistical::CHIDIST() — Method in class Statistical
CHIDIST.
Statistical::CHIINV() — Method in class Statistical
CHIINV.
Statistical::CONFIDENCE() — Method in class Statistical
CONFIDENCE.
Statistical::CORREL() — Method in class Statistical
CORREL.
Statistical::COUNT() — Method in class Statistical
COUNT.
Statistical::COUNTA() — Method in class Statistical
COUNTA.
Statistical::COUNTBLANK() — Method in class Statistical
COUNTBLANK.
Statistical::COUNTIF() — Method in class Statistical
COUNTIF.
Statistical::COVAR() — Method in class Statistical
COVAR.
Statistical::CRITBINOM() — Method in class Statistical
CRITBINOM.
TextData::CHARACTER() — Method in class TextData
CHARACTER.
TextData::CONCATENATE() — Method in class TextData
CONCATENATE.
Stack::count() — Method in class Stack
Return the number of entries on the stack.
Stack::clear() — Method in class Stack
Clear the stack.
CellClass in namespace PhpOffice\PhpSpreadsheet\Cell
Cell::compareCells() — Method in class Cell
Compare 2 cells.
CoordinateClass in namespace PhpOffice\PhpSpreadsheet\Cell
Helper class to manipulate cell coordinates.
Coordinate::coordinateFromString() — Method in class Coordinate
Coordinate from string.
Coordinate::coordinateIsRange() — Method in class Coordinate
Checks if a coordinate represents a range of cells.
Coordinate::columnIndexFromString() — Method in class Coordinate
Column index from string.
DataType::checkString() — Method in class DataType
Check a string that it satisfies Excel requirements.
DataType::checkErrorCode() — Method in class DataType
Check a value that it is a valid error code.
ChartClass in namespace PhpOffice\PhpSpreadsheet\Chart
CellsClass in namespace PhpOffice\PhpSpreadsheet\Collection
Cells::cloneCellCollection() — Method in class Cells
Clone the cell collection.
CellsFactoryClass in namespace PhpOffice\PhpSpreadsheet\Collection
Memory::clear() — Method in class Memory
CommentClass in namespace PhpOffice\PhpSpreadsheet
Properties::convertProperty() — Method in class Properties
Properties::convertPropertyType() — Method in class Properties
HashTable::clear() — Method in class HashTable
Clear HashTable.
HashTable::count() — Method in class HashTable
Count.
$Html#colourMapProperty in class Html
$Html#colorProperty in class Html
Html::cleanWhitespace() — Method in class Html
Html::colourNameLookup() — Method in class Html
IOFactory::createWriter() — Method in class IOFactory
Create Writer\IWriter.
IOFactory::createReader() — Method in class IOFactory
Create Reader\IReader.
IOFactory::createReaderForFile() — Method in class IOFactory
Create Reader\IReader for file using automatic Reader\IReader resolution.
CsvClass in namespace PhpOffice\PhpSpreadsheet\Reader
Csv::checkSeparator() — Method in class Csv
Identify any separator that is explicitly set in the file.
Csv::canRead() — Method in class Csv
Can the current IReader read the file?
Gnumeric::canRead() — Method in class Gnumeric
Can the current IReader read the file?
Html::canRead() — Method in class Html
Validate that the current file is an HTML file.
IReader::canRead() — Method in class IReader
Can the current IReader read the file?
Ods::canRead() — Method in class Ods
Can the current IReader read the file?
Slk::canRead() — Method in class Slk
Validate that the current file is a SYLK file.
Xls::canRead() — Method in class Xls
Can the current IReader read the file?
ColorClass in namespace PhpOffice\PhpSpreadsheet\Reader\Xls
Xlsx::canRead() — Method in class Xlsx
Can the current IReader read the file?
ChartClass in namespace PhpOffice\PhpSpreadsheet\Reader\Xlsx
$Xml#charSetProperty in class Xml
Character set used in the file.
Xml::canRead() — Method in class Xml
Can the current IReader read the file?
Xml::convertStringEncoding() — Method in class Xml
ReferenceHelper::columnSort() — Method in class ReferenceHelper
Compare two column addresses Intended for use as a Callback function for sorting column addresses by column.
ReferenceHelper::columnReverseSort() — Method in class ReferenceHelper
Compare two column addresses Intended for use as a Callback function for reverse sorting column addresses by column.
ReferenceHelper::cellSort() — Method in class ReferenceHelper
Compare two cell addresses Intended for use as a Callback function for sorting cell addresses by column and row.
ReferenceHelper::cellReverseSort() — Method in class ReferenceHelper
Compare two cell addresses Intended for use as a Callback function for sorting cell addresses by column and row.
RichText::createText() — Method in class RichText
Create text.
RichText::createTextRun() — Method in class RichText
Create text run.
CodePageClass in namespace PhpOffice\PhpSpreadsheet\Shared
Drawing::cellDimensionToPixels() — Method in class Drawing
Convert column width from (intrinsic) Excel units to pixels.
Font::calculateColumnWidth() — Method in class Font
Calculate an (approximate) OpenXML column width, based on font size and text contained.
Font::centimeterSizeToPixels() — Method in class Font
Calculate an (approximate) pixel size, based on centimeter size.
CholeskyDecompositionClass in namespace PhpOffice\PhpSpreadsheet\Shared\JAMA
Cholesky decomposition class.
Matrix::checkMatrixDimensions() — Method in class Matrix
checkMatrixDimensions.
Matrix::concat() — Method in class Matrix
concat.
SingularValueDecomposition::cond() — Method in class SingularValueDecomposition
Two norm condition number.
ChainedBlockStreamClass in namespace PhpOffice\PhpSpreadsheet\Shared\OLE
$PPS#childrenProperty in class PPS
Array of child PPS's (only used by Root and Dir PPS's).
StringHelper::controlCharacterOOXML2PHP() — Method in class StringHelper
Convert from OpenXML escaped control character to PHP control character.
StringHelper::controlCharacterPHP2OOXML() — Method in class StringHelper
Convert from PHP control character to OpenXML escaped control character.
StringHelper::convertEncoding() — Method in class StringHelper
Convert string from one encoding to another.
StringHelper::countCharacters() — Method in class StringHelper
Get character count.
StringHelper::convertToNumberIfFraction() — Method in class StringHelper
Identify whether a string contains a fractional numeric value, and convert it to a numeric if it is.
$BestFit#covarianceProperty in class BestFit
$BestFit#correlationProperty in class BestFit
BestFit::calculateGoodnessOfFit() — Method in class BestFit
Trend::calculate() — Method in class Trend
Spreadsheet::createSheet() — Method in class Spreadsheet
Create sheet and add it to this workbook.
Spreadsheet::copy() — Method in class Spreadsheet
Copy workbook (!= clone!).
Spreadsheet::cellXfExists() — Method in class Spreadsheet
Check if style exists in style collection.
$Border#colorProperty in class Border
Border color.
$Border#colorIndexProperty in class Border
ColorClass in namespace PhpOffice\PhpSpreadsheet\Style
Color::changeBrightness() — Method in class Color
Adjust the brightness of a color.
ConditionalClass in namespace PhpOffice\PhpSpreadsheet\Style
$Font#colorProperty in class Font
Foreground color.
$Font#colorIndexProperty in class Font
$Style#conditionalStylesProperty in class Style
Conditional styles.
AutoFilter::clearColumn() — Method in class AutoFilter
Clear a specified AutoFilter Column.
ColumnClass in namespace PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter
Column::createRule() — Method in class Column
Create a new AutoFilter Column Rule in the ruleset.
Column::clearRules() — Method in class Column
Delete all AutoFilter Column Rules.
$BaseDrawing#coordinatesProperty in class BaseDrawing
Coordinates.
CellIteratorClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
ColumnClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
ColumnCellIteratorClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
ColumnCellIterator::current() — Method in class ColumnCellIterator
Return the current cell in this worksheet column.
ColumnDimensionClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
ColumnIteratorClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
ColumnIterator::current() — Method in class ColumnIterator
Return the current column in this worksheet.
Iterator::current() — Method in class Iterator
Current Worksheet.
PageSetup::clearPrintArea() — Method in class PageSetup
Clear a print area.
RowCellIterator::current() — Method in class RowCellIterator
Return the current cell in this worksheet row.
RowIterator::current() — Method in class RowIterator
Return the current row in this worksheet.
Worksheet::calculateWorksheetDimension() — Method in class Worksheet
Calculate worksheet dimension.
Worksheet::calculateWorksheetDataDimension() — Method in class Worksheet
Calculate worksheet data dimension.
Worksheet::calculateColumnWidths() — Method in class Worksheet
Calculate widths for auto-size columns.
Worksheet::cellExists() — Method in class Worksheet
Does the cell at a specific coordinate exist?
Worksheet::cellExistsByColumnAndRow() — Method in class Worksheet
Cell at a specific coordinate by using numeric cell coordinates exists?
Worksheet::conditionalStylesExists() — Method in class Worksheet
Do conditional styles exist for this cell?
Worksheet::copy() — Method in class Worksheet
Copy worksheet (!= clone!).
CsvClass in namespace PhpOffice\PhpSpreadsheet\Writer
CommentClass in namespace PhpOffice\PhpSpreadsheet\Writer\Ods\Cell
ContentClass in namespace PhpOffice\PhpSpreadsheet\Writer\Ods
Dompdf::createExternalWriterInstance() — Method in class Dompdf
Gets the implementation of external PDF library that should be used.
Mpdf::createExternalWriterInstance() — Method in class Mpdf
Gets the implementation of external PDF library that should be used.
Tcpdf::createExternalWriterInstance() — Method in class Tcpdf
Gets the implementation of external PDF library that should be used.
Escher::close() — Method in class Escher
Process the object to be written.
$Parser#currentCharacterProperty in class Parser
The index of the character we are currently looking at.
$Parser#currentTokenProperty in class Parser
The token we are working on.
Worksheet::close() — Method in class Worksheet
Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook.
ChartClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx
$Chart#calculateCellValuesProperty in class Chart
CommentsClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx
ContentTypesClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx
StringTable::createStringTable() — Method in class StringTable
Create worksheet stringtable.

D

Calculation::disableCalculationCache() — Method in class Calculation
Disable calculation cache.
DatabaseClass in namespace PhpOffice\PhpSpreadsheet\Calculation
Database::DAVERAGE() — Method in class Database
DAVERAGE.
Database::DCOUNT() — Method in class Database
DCOUNT.
Database::DCOUNTA() — Method in class Database
DCOUNTA.
Database::DGET() — Method in class Database
DGET.
Database::DMAX() — Method in class Database
DMAX.
Database::DMIN() — Method in class Database
DMIN.
Database::DPRODUCT() — Method in class Database
DPRODUCT.
Database::DSTDEV() — Method in class Database
DSTDEV.
Database::DSTDEVP() — Method in class Database
DSTDEVP.
Database::DSUM() — Method in class Database
DSUM.
Database::DVAR() — Method in class Database
DVAR.
Database::DVARP() — Method in class Database
DVARP.
DateTimeClass in namespace PhpOffice\PhpSpreadsheet\Calculation
DateTime::DATETIMENOW() — Method in class DateTime
DATETIMENOW.
DateTime::DATENOW() — Method in class DateTime
DATENOW.
DateTime::DATE() — Method in class DateTime
DATE.
DateTime::DATEVALUE() — Method in class DateTime
DATEVALUE.
DateTime::DATEDIF() — Method in class DateTime
DATEDIF.
DateTime::DAYS() — Method in class DateTime
DAYS.
DateTime::DAYS360() — Method in class DateTime
DAYS360.
DateTime::DAYOFMONTH() — Method in class DateTime
DAYOFMONTH.
Engineering::DECTOBIN() — Method in class Engineering
DECTOBIN.
Engineering::DECTOHEX() — Method in class Engineering
DECTOHEX.
Engineering::DECTOOCT() — Method in class Engineering
DECTOOCT.
Engineering::DELTA() — Method in class Engineering
DELTA.
Financial::DB() — Method in class Financial
DB.
Financial::DDB() — Method in class Financial
DDB.
Financial::DISC() — Method in class Financial
DISC.
Financial::DOLLARDE() — Method in class Financial
DOLLARDE.
Financial::DOLLARFR() — Method in class Financial
DOLLARFR.
Functions::DUMMY() — Method in class Functions
DUMMY.
Functions::DIV0() — Method in class Functions
DIV0.
Statistical::DEVSQ() — Method in class Statistical
DEVSQ.
TextData::DOLLAR() — Method in class TextData
DOLLAR.
Cell::detach() — Method in class Cell
DataTypeClass in namespace PhpOffice\PhpSpreadsheet\Cell
DataValidationClass in namespace PhpOffice\PhpSpreadsheet\Cell
DataValidatorClass in namespace PhpOffice\PhpSpreadsheet\Cell
Validate a cell value according to its validation rules.
DefaultValueBinderClass in namespace PhpOffice\PhpSpreadsheet\Cell
DefaultValueBinder::dataTypeForValue() — Method in class DefaultValueBinder
DataType for value.
DataSeriesClass in namespace PhpOffice\PhpSpreadsheet\Chart
DataSeriesValuesClass in namespace PhpOffice\PhpSpreadsheet\Chart
Cells::delete() — Method in class Cells
Delete a cell in cache identified by coordinate.
Memory::delete() — Method in class Memory
Memory::deleteMultiple() — Method in class Memory
DefaultReadFilterClass in namespace PhpOffice\PhpSpreadsheet\Reader
$Html#dataArrayProperty in class Html
DateClass in namespace PhpOffice\PhpSpreadsheet\Shared
$Date#defaultTimeZoneProperty in class Date
Default timezone to use for DateTime objects.
Date::dateTimeToExcel() — Method in class Date
Convert a PHP DateTime object to an MS Excel serialized date/time value.
Date::dayStringToNumber() — Method in class Date
Strips an ordinal from a numeric value.
DrawingClass in namespace PhpOffice\PhpSpreadsheet\Shared
Drawing::degreesToAngle() — Method in class Drawing
Convert degrees to angle.
DgContainerClass in namespace PhpOffice\PhpSpreadsheet\Shared\Escher
DggContainerClass in namespace PhpOffice\PhpSpreadsheet\Shared\Escher
$Font#defaultColumnWidthsProperty in class Font
How wide is a default column for a given default font and size? Empirical data found by inspecting real Excel files and reading off the pixel width in Microsoft Office Excel 2007.
LUDecomposition::det() — Method in class LUDecomposition
Count determinants.
Matrix::diagonal() — Method in class Matrix
diagonal.
Matrix::det() — Method in class Matrix
det.
$OLERead#documentSummaryInformationProperty in class OLERead
$ChainedBlockStream#dataProperty in class ChainedBlockStream
The binary data of the file.
$PPS#DirPpsProperty in class PPS
The index of it's first child if this is a Dir or Root PPS.
$BestFit#DFResidualsProperty in class BestFit
$XMLWriter#debugEnabledProperty in class XMLWriter
Spreadsheet::discardMacros() — Method in class Spreadsheet
Remove all macros, certificate from spreadsheet.
Spreadsheet::disconnectWorksheets() — Method in class Spreadsheet
Disconnect all worksheets from this PhpSpreadsheet workbook object, typically so that the PhpSpreadsheet object can be unset.
$Borders#diagonalProperty in class Borders
Diagonal.
$Borders#diagonalDirectionProperty in class Borders
DiagonalDirection.
Column::deleteRule() — Method in class Column
Delete a specified AutoFilter Column Rule If the number of rules is reduced to 1, then we reset And/Or logic to Or.
$BaseDrawing#descriptionProperty in class BaseDrawing
Description.
DimensionClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
DrawingClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
Worksheet::disconnectCells() — Method in class Worksheet
Disconnect all cells from this Worksheet object, typically so that the worksheet object can be unset.
Worksheet::duplicateStyle() — Method in class Worksheet
Duplicate cell style to a range of cells.
Worksheet::duplicateConditionalStyle() — Method in class Worksheet
Duplicate conditional style to a range of cells.
Worksheet::dataValidationExists() — Method in class Worksheet
Data validation at a specific coordinate exists?
DompdfClass in namespace PhpOffice\PhpSpreadsheet\Writer\Pdf
DocPropsClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx
DrawingClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx

E

Calculation::enableCalculationCache() — Method in class Calculation
Enable calculation cache.
Calculation::extractCellRange() — Method in class Calculation
Extract range values.
Calculation::extractNamedRange() — Method in class Calculation
Extract range values.
DateTime::EDATE() — Method in class DateTime
EDATE.
DateTime::EOMONTH() — Method in class DateTime
EOMONTH.
EngineeringClass in namespace PhpOffice\PhpSpreadsheet\Calculation
Engineering::erfVal() — Method in class Engineering
Engineering::ERF() — Method in class Engineering
ERF.
Engineering::ERFPRECISE() — Method in class Engineering
ERFPRECISE.
Engineering::ERFC() — Method in class Engineering
ERFC.
ExceptionClass in namespace PhpOffice\PhpSpreadsheet\Calculation
Exception::errorHandlerCallback() — Method in class Exception
Error handler callback.
ExceptionHandlerClass in namespace PhpOffice\PhpSpreadsheet\Calculation
Financial::EFFECT() — Method in class Financial
EFFECT.
$Functions#errorCodesProperty in class Functions
List of error codes.
Functions::errorType() — Method in class Functions
ERROR_TYPE.
MathTrig::EVEN() — Method in class MathTrig
EVEN.
Statistical::EXPONDIST() — Method in class Statistical
EXPONDIST.
TextData::EXACT() — Method in class TextData
Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise.
Coordinate::extractAllCellReferencesInRange() — Method in class Coordinate
Extract all cell references in range, which may be comprised of multiple cell ranges.
ExceptionClass in namespace PhpOffice\PhpSpreadsheet\Chart
ExceptionClass in namespace PhpOffice\PhpSpreadsheet
$Html#endTagCallbacksProperty in class Html
Html::endFontTag() — Method in class Html
Html::endBoldTag() — Method in class Html
Html::endItalicTag() — Method in class Html
Html::endUnderlineTag() — Method in class Html
Html::endSubscriptTag() — Method in class Html
Html::endSuperscriptTag() — Method in class Html
Html::endStrikethruTag() — Method in class Html
ExceptionClass in namespace PhpOffice\PhpSpreadsheet\Reader
ErrorCodeClass in namespace PhpOffice\PhpSpreadsheet\Reader\Xls
EscherClass in namespace PhpOffice\PhpSpreadsheet\Reader\Xls
$Date#excelCalendarProperty in class Date
Base calendar year to use for calculations Value is either CALENDAR_WINDOWS_1900 (1900) or CALENDAR_MAC_1904 (1904).
Date::excelToDateTimeObject() — Method in class Date
Convert a MS serialized datetime value from Excel to a PHP Date/Time object.
Date::excelToTimestamp() — Method in class Date
Convert a MS serialized datetime value from Excel to a unix timestamp.
Drawing::EMUToPixels() — Method in class Drawing
Convert EMU to pixels.
EscherClass in namespace PhpOffice\PhpSpreadsheet\Shared
EigenvalueDecompositionClass in namespace PhpOffice\PhpSpreadsheet\Shared\JAMA
Class to obtain eigenvalues and eigenvectors of a real matrix.
$BestFit#errorProperty in class BestFit
Indicator flag for a calculation error.
ExponentialBestFitClass in namespace PhpOffice\PhpSpreadsheet\Shared\Trend
$Fill#endcolorIndexProperty in class Fill
$Fill#endColorProperty in class Fill
End color.
Worksheet::extractSheetTitle() — Method in class Worksheet
Extract worksheet title from range.
ExceptionClass in namespace PhpOffice\PhpSpreadsheet\Writer
EscherClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xls

F

$Calculation#formulaErrorProperty in class Calculation
Error message for any error that was raised/thrown by the calculation engine.
Calculation::flushInstance() — Method in class Calculation
Flush the calculation cache for any existing instance of this class but only if a Calculation instance exists.
FinancialClass in namespace PhpOffice\PhpSpreadsheet\Calculation
Financial::FV() — Method in class Financial
FV.
Financial::FVSCHEDULE() — Method in class Financial
FVSCHEDULE.
FormulaParserClass in namespace PhpOffice\PhpSpreadsheet\Calculation
PARTLY BASED ON: Copyright (c) 2007 E. W. Bachtal, Inc.
FormulaTokenClass in namespace PhpOffice\PhpSpreadsheet\Calculation
PARTLY BASED ON: Copyright (c) 2007 E. W. Bachtal, Inc.
FunctionsClass in namespace PhpOffice\PhpSpreadsheet\Calculation
Functions::flattenArray() — Method in class Functions
Convert a multi-dimensional array to a simple 1-dimensional array.
Functions::flattenArrayIndexed() — Method in class Functions
Convert a multi-dimensional array to a simple 1-dimensional array, but retain an element of indexing.
Functions::flattenSingleValue() — Method in class Functions
Convert an array to a single scalar value by extracting the first element.
Logical::false() — Method in class Logical
FALSE.
LookupRef::FORMULATEXT() — Method in class LookupRef
FORMULATEXT.
MathTrig::FACT() — Method in class MathTrig
FACT.
MathTrig::FACTDOUBLE() — Method in class MathTrig
FACTDOUBLE.
MathTrig::FLOOR() — Method in class MathTrig
FLOOR.
MathTrig::filterHiddenArgs() — Method in class MathTrig
MathTrig::filterFormulaArgs() — Method in class MathTrig
Statistical::FISHER() — Method in class Statistical
FISHER.
Statistical::FISHERINV() — Method in class Statistical
FISHERINV.
Statistical::FORECAST() — Method in class Statistical
FORECAST.
TextData::FIXEDFORMAT() — Method in class TextData
FIXEDFORMAT.
$Html#faceProperty in class Html
$BaseReader#fileHandleProperty in class BaseReader
$Html#formatsProperty in class Html
Formats.
Html::flushCell() — Method in class Html
FillPatternClass in namespace PhpOffice\PhpSpreadsheet\Reader\Xls\Style
Date::formattedPHPToExcel() — Method in class Date
formattedPHPToExcel.
FileClass in namespace PhpOffice\PhpSpreadsheet\Shared
File::fileExists() — Method in class File
Verify if a file exists.
FontClass in namespace PhpOffice\PhpSpreadsheet\Shared
Font::fontSizeToPixels() — Method in class Font
Calculate an (approximate) pixel size, based on a font points size.
FileClass in namespace PhpOffice\PhpSpreadsheet\Shared\OLE\PPS
Class for creating File PPS's for OLE containers.
StringHelper::formatNumber() — Method in class StringHelper
Formats a numeric value as a string for output in various output writers forcing point as decimal separator in case locale is other than English.
$BestFit#fProperty in class BestFit
FillClass in namespace PhpOffice\PhpSpreadsheet\Style
$Fill#fillTypeProperty in class Fill
Fill type.
FontClass in namespace PhpOffice\PhpSpreadsheet\Style
$NumberFormat#flippedBuiltInFormatsProperty in class NumberFormat
Excel built-in number formats (flipped, for faster lookups).
$NumberFormat#formatCodeProperty in class NumberFormat
Format Code.
$Style#fontProperty in class Style
Font.
$Style#fillProperty in class Style
Fill.
Worksheet::freezePane() — Method in class Worksheet
Freeze Pane.
Worksheet::freezePaneByColumnAndRow() — Method in class Worksheet
Freeze Pane by using numeric cell coordinates.
Worksheet::fromArray() — Method in class Worksheet
Fill worksheet from values in array.
Html::formatColor() — Method in class Html
Add color to formatted string as inline style.
$Pdf#fontProperty in class Pdf
Font.
FontClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xls
$Worksheet#fontHashIndexProperty in class Worksheet
Array of font hashes associated to FONT records index.
StringTable::flipStringTable() — Method in class StringTable
Flip string table (for index searching).

G

Calculation::getInstance() — Method in class Calculation
Get an instance of this class.
Calculation::getDebugLog() — Method in class Calculation
Get the Logger for this calculation engine instance.
Calculation::getTRUE() — Method in class Calculation
Return the locale-specific translation of TRUE.
Calculation::getFALSE() — Method in class Calculation
Return the locale-specific translation of FALSE.
Calculation::getArrayReturnType() — Method in class Calculation
Return the Array Return Type (Array or Value of first element in the array).
Calculation::getCalculationCacheEnabled() — Method in class Calculation
Is calculation caching enabled?
Calculation::getLocale() — Method in class Calculation
Get the currently defined locale code.
Calculation::getValueFromCache() — Method in class Calculation
Calculation::getMatrixDimensions() — Method in class Calculation
Read the dimensions of a matrix, and re-index it with straight numeric keys starting from row 0, column 0.
Calculation::getFunctions() — Method in class Calculation
Get a list of all implemented functions as an array of function objects.
Calculation::getImplementedFunctionNames() — Method in class Calculation
Get a list of implemented Excel function names.
DateTime::getDateValue() — Method in class DateTime
getDateValue.
Logger::getWriteDebugLog() — Method in class Logger
Return whether calculation engine logging is enabled or disabled.
Logger::getEchoDebugLog() — Method in class Logger
Return whether echoing of debug log information is enabled or disabled.
Logger::getLog() — Method in class Logger
Return the calculation engine debug log.
Engineering::GESTEP() — Method in class Engineering
GESTEP.
Engineering::getConversionGroups() — Method in class Engineering
getConversionGroups Returns a list of the different conversion groups for UOM conversions.
Engineering::getConversionGroupUnits() — Method in class Engineering
getConversionGroupUnits Returns an array of units of measure, for a specified conversion group, or for all groups.
Engineering::getConversionGroupUnitDetails() — Method in class Engineering
getConversionGroupUnitDetails.
Engineering::getConversionMultipliers() — Method in class Engineering
getConversionMultipliers Returns an array of the Multiplier prefixes that can be used with Units of Measure in CONVERTUOM().
FormulaParser::getFormula() — Method in class FormulaParser
Get Formula.
FormulaParser::getToken() — Method in class FormulaParser
Get Token.
FormulaParser::getTokenCount() — Method in class FormulaParser
Get Token count.
FormulaParser::getTokens() — Method in class FormulaParser
Get Tokens.
FormulaToken::getValue() — Method in class FormulaToken
Get Value.
FormulaToken::getTokenType() — Method in class FormulaToken
Get Token Type (represented by TOKEN_TYPE_*).
FormulaToken::getTokenSubType() — Method in class FormulaToken
Get Token SubType (represented by TOKEN_SUBTYPE_*).
Functions::getCompatibilityMode() — Method in class Functions
Return the current Compatibility Mode.
Functions::getReturnDateType() — Method in class Functions
Return the current Return Date Format for functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object).
MathTrig::GCD() — Method in class MathTrig
GCD.
Statistical::GAMMADIST() — Method in class Statistical
GAMMADIST.
Statistical::GAMMAINV() — Method in class Statistical
GAMMAINV.
Statistical::GAMMALN() — Method in class Statistical
GAMMALN.
Statistical::GEOMEAN() — Method in class Statistical
GEOMEAN.
Statistical::GROWTH() — Method in class Statistical
GROWTH.
Cell::getColumn() — Method in class Cell
Get cell coordinate column.
Cell::getRow() — Method in class Cell
Get cell coordinate row.
Cell::getCoordinate() — Method in class Cell
Get cell coordinate.
Cell::getValue() — Method in class Cell
Get cell value.
Cell::getFormattedValue() — Method in class Cell
Get cell value with formatting.
Cell::getCalculatedValue() — Method in class Cell
Get calculated cell value.
Cell::getOldCalculatedValue() — Method in class Cell
Get old calculated value (cached) This returns the value last calculated by MS Excel or whichever spreadsheet program was used to create the original spreadsheet file.
Cell::getDataType() — Method in class Cell
Get cell data type.
Cell::getDataValidation() — Method in class Cell
Get Data validation rules.
Cell::getHyperlink() — Method in class Cell
Get Hyperlink.
Cell::getParent() — Method in class Cell
Get cell collection.
Cell::getWorksheet() — Method in class Cell
Get parent worksheet.
Cell::getMergeRange() — Method in class Cell
If this cell is in a merge range, then return the range.
Cell::getStyle() — Method in class Cell
Get cell style.
Cell::getValueBinder() — Method in class Cell
Get value binder to use.
Cell::getXfIndex() — Method in class Cell
Get index to cellXf.
Cell::getFormulaAttributes() — Method in class Cell
Get the formula attributes.
Coordinate::getRangeBoundaries() — Method in class Coordinate
Calculate range boundaries.
DataType::getErrorCodes() — Method in class DataType
Get list of error codes.
DataValidation::getFormula1() — Method in class DataValidation
Get Formula 1.
DataValidation::getFormula2() — Method in class DataValidation
Get Formula 2.
DataValidation::getType() — Method in class DataValidation
Get Type.
DataValidation::getErrorStyle() — Method in class DataValidation
Get Error style.
DataValidation::getOperator() — Method in class DataValidation
Get Operator.
DataValidation::getAllowBlank() — Method in class DataValidation
Get Allow Blank.
DataValidation::getShowDropDown() — Method in class DataValidation
Get Show DropDown.
DataValidation::getShowInputMessage() — Method in class DataValidation
Get Show InputMessage.
DataValidation::getShowErrorMessage() — Method in class DataValidation
Get Show ErrorMessage.
DataValidation::getErrorTitle() — Method in class DataValidation
Get Error title.
DataValidation::getError() — Method in class DataValidation
Get Error.
DataValidation::getPromptTitle() — Method in class DataValidation
Get Prompt title.
DataValidation::getPrompt() — Method in class DataValidation
Get Prompt.
DataValidation::getHashCode() — Method in class DataValidation
Get hash code.
Hyperlink::getUrl() — Method in class Hyperlink
Get URL.
Hyperlink::getTooltip() — Method in class Hyperlink
Get tooltip.
Hyperlink::getTypeHyperlink() — Method in class Hyperlink
Hyperlink::getHashCode() — Method in class Hyperlink
Get hash code.
Axis::getAxisNumberFormat() — Method in class Axis
Get Axis Number Format Data Type.
Axis::getAxisNumberSourceLinked() — Method in class Axis
Get Axis Number Source Linked.
Axis::getAxisOptionsProperty() — Method in class Axis
Get Axis Options Property.
Axis::getFillProperty() — Method in class Axis
Get Fill Property.
Axis::getLineProperty() — Method in class Axis
Get Line Property.
Axis::getLineStyleProperty() — Method in class Axis
Get Line Style Property.
Axis::getLineStyleArrowWidth() — Method in class Axis
Get Line Style Arrow Excel Width.
Axis::getLineStyleArrowLength() — Method in class Axis
Get Line Style Arrow Excel Length.
Axis::getShadowProperty() — Method in class Axis
Get Shadow Property.
Axis::getGlowProperty() — Method in class Axis
Get Glow Property.
Axis::getSoftEdgesSize() — Method in class Axis
Get Soft Edges Size.
Chart::getName() — Method in class Chart
Get Name.
Chart::getWorksheet() — Method in class Chart
Get Worksheet.
Chart::getTitle() — Method in class Chart
Get Title.
Chart::getLegend() — Method in class Chart
Get Legend.
Chart::getXAxisLabel() — Method in class Chart
Get X-Axis Label.
Chart::getYAxisLabel() — Method in class Chart
Get Y-Axis Label.
Chart::getPlotArea() — Method in class Chart
Get Plot Area.
Chart::getPlotVisibleOnly() — Method in class Chart
Get Plot Visible Only.
Chart::getDisplayBlanksAs() — Method in class Chart
Get Display Blanks as.
Chart::getChartAxisY() — Method in class Chart
Get yAxis.
Chart::getChartAxisX() — Method in class Chart
Get xAxis.
Chart::getMajorGridlines() — Method in class Chart
Get Major Gridlines.
Chart::getMinorGridlines() — Method in class Chart
Get Minor Gridlines.
Chart::getTopLeftPosition() — Method in class Chart
Get the top left position of the chart.
Chart::getTopLeftCell() — Method in class Chart
Get the cell address where the top left of the chart is fixed.
Chart::getTopLeftOffset() — Method in class Chart
Get the offset position within the Top Left cell for the chart.
Chart::getTopLeftXOffset() — Method in class Chart
Chart::getTopLeftYOffset() — Method in class Chart
Chart::getBottomRightPosition() — Method in class Chart
Get the bottom right position of the chart.
Chart::getBottomRightCell() — Method in class Chart
Get the cell address where the bottom right of the chart is fixed.
Chart::getBottomRightOffset() — Method in class Chart
Get the offset position within the Bottom Right cell for the chart.
Chart::getBottomRightXOffset() — Method in class Chart
Chart::getBottomRightYOffset() — Method in class Chart
DataSeries::getPlotType() — Method in class DataSeries
Get Plot Type.
DataSeries::getPlotGrouping() — Method in class DataSeries
Get Plot Grouping Type.
DataSeries::getPlotDirection() — Method in class DataSeries
Get Plot Direction.
DataSeries::getPlotOrder() — Method in class DataSeries
Get Plot Order.
DataSeries::getPlotLabels() — Method in class DataSeries
Get Plot Labels.
DataSeries::getPlotLabelByIndex() — Method in class DataSeries
Get Plot Label by Index.
DataSeries::getPlotCategories() — Method in class DataSeries
Get Plot Categories.
DataSeries::getPlotCategoryByIndex() — Method in class DataSeries
Get Plot Category by Index.
DataSeries::getPlotStyle() — Method in class DataSeries
Get Plot Style.
DataSeries::getPlotValues() — Method in class DataSeries
Get Plot Values.
DataSeries::getPlotValuesByIndex() — Method in class DataSeries
Get Plot Values by Index.
DataSeries::getPlotSeriesCount() — Method in class DataSeries
Get Number of Plot Series.
DataSeries::getSmoothLine() — Method in class DataSeries
Get Smooth Line.
DataSeriesValues::getDataType() — Method in class DataSeriesValues
Get Series Data Type.
DataSeriesValues::getDataSource() — Method in class DataSeriesValues
Get Series Data Source (formula).
DataSeriesValues::getPointMarker() — Method in class DataSeriesValues
Get Point Marker.
DataSeriesValues::getFormatCode() — Method in class DataSeriesValues
Get Series Format Code.
DataSeriesValues::getPointCount() — Method in class DataSeriesValues
Get Series Point Count.
DataSeriesValues::getFillColor() — Method in class DataSeriesValues
Get fill color.
DataSeriesValues::getLineWidth() — Method in class DataSeriesValues
Get line width for series.
DataSeriesValues::getDataValues() — Method in class DataSeriesValues
Get Series Data Values.
DataSeriesValues::getDataValue() — Method in class DataSeriesValues
Get the first Series Data value.
GridLinesClass in namespace PhpOffice\PhpSpreadsheet\Chart
Created by PhpStorm.
GridLines::getObjectState() — Method in class GridLines
Get Object State.
GridLines::getLineColorProperty() — Method in class GridLines
Get Line Color Property.
GridLines::getLineStyleProperty() — Method in class GridLines
Get Line Style Property.
GridLines::getGlowColor() — Method in class GridLines
Get Glow Color Property.
GridLines::getGlowSize() — Method in class GridLines
Get Glow Size.
GridLines::getLineStyleArrowParameters() — Method in class GridLines
Get Line Style Arrow Parameters.
GridLines::getShadowProperty() — Method in class GridLines
Get Shadow Property.
GridLines::getSoftEdgesSize() — Method in class GridLines
Get Soft Edges Size.
Layout::getLayoutTarget() — Method in class Layout
Get Layout Target.
Layout::getXMode() — Method in class Layout
Get X-Mode.
Layout::getYMode() — Method in class Layout
Get Y-Mode.
Layout::getXPosition() — Method in class Layout
Get X-Position.
Layout::getYPosition() — Method in class Layout
Get Y-Position.
Layout::getWidth() — Method in class Layout
Get Width.
Layout::getHeight() — Method in class Layout
Get Height.
Layout::getShowLegendKey() — Method in class Layout
Get show legend key.
Layout::getShowVal() — Method in class Layout
Get show value.
Layout::getShowCatName() — Method in class Layout
Get show category name.
Layout::getShowSerName() — Method in class Layout
Get show data series name.
Layout::getShowPercent() — Method in class Layout
Get show percentage.
Layout::getShowBubbleSize() — Method in class Layout
Get show bubble size.
Layout::getShowLeaderLines() — Method in class Layout
Get show leader lines.
Legend::getPosition() — Method in class Legend
Get legend position as an excel string value.
Legend::getPositionXL() — Method in class Legend
Get legend position as an Excel internal numeric value.
Legend::getOverlay() — Method in class Legend
Get allow overlay of other elements?
Legend::getLayout() — Method in class Legend
Get Layout.
PlotArea::getLayout() — Method in class PlotArea
Get Layout.
PlotArea::getPlotGroupCount() — Method in class PlotArea
Get Number of Plot Groups.
PlotArea::getPlotSeriesCount() — Method in class PlotArea
Get Number of Plot Series.
PlotArea::getPlotGroup() — Method in class PlotArea
Get Plot Series.
PlotArea::getPlotGroupByIndex() — Method in class PlotArea
Get Plot Series by Index.
Properties::getExcelPointsWidth() — Method in class Properties
Properties::getExcelPointsAngle() — Method in class Properties
Properties::getTrueAlpha() — Method in class Properties
Properties::getLineStyleArrowSize() — Method in class Properties
Properties::getShadowPresetsMap() — Method in class Properties
Properties::getArrayElementsValue() — Method in class Properties
Title::getCaption() — Method in class Title
Get caption.
Title::getLayout() — Method in class Title
Get Layout.
Cells::getParent() — Method in class Cells
Return the parent worksheet for this cell collection.
Cells::getCoordinates() — Method in class Cells
Get a list of all cell coordinates currently held in the collection.
Cells::getSortedCoordinates() — Method in class Cells
Get a sorted list of all cell coordinates currently held in the collection by row and column.
Cells::getHighestRowAndColumn() — Method in class Cells
Get highest worksheet column and highest row that have cell records.
Cells::getCurrentCoordinate() — Method in class Cells
Return the cell coordinate of the currently active cell object.
Cells::getCurrentColumn() — Method in class Cells
Return the column coordinate of the currently active cell object.
Cells::getCurrentRow() — Method in class Cells
Return the row coordinate of the currently active cell object.
Cells::getHighestColumn() — Method in class Cells
Get highest worksheet column.
Cells::getHighestRow() — Method in class Cells
Get highest worksheet row.
Cells::get() — Method in class Cells
Get cell at a specific coordinate.
CellsFactory::getInstance() — Method in class CellsFactory
Initialise the cache storage.
Memory::get() — Method in class Memory
Memory::getMultiple() — Method in class Memory
Comment::getAuthor() — Method in class Comment
Get Author.
Comment::getText() — Method in class Comment
Get Rich text comment.
Comment::getWidth() — Method in class Comment
Get comment width (CSS style, i.e. XXpx or YYpt).
Comment::getHeight() — Method in class Comment
Get comment height (CSS style, i.e. XXpx or YYpt).
Comment::getMarginLeft() — Method in class Comment
Get left margin (CSS style, i.e. XXpx or YYpt).
Comment::getMarginTop() — Method in class Comment
Get top margin (CSS style, i.e. XXpx or YYpt).
Comment::getVisible() — Method in class Comment
Is the comment visible by default?
Comment::getFillColor() — Method in class Comment
Get fill color.
Comment::getAlignment() — Method in class Comment
Get Alignment.
Comment::getHashCode() — Method in class Comment
Get hash code.
Properties::getCreator() — Method in class Properties
Get Creator.
Properties::getLastModifiedBy() — Method in class Properties
Get Last Modified By.
Properties::getCreated() — Method in class Properties
Get Created.
Properties::getModified() — Method in class Properties
Get Modified.
Properties::getTitle() — Method in class Properties
Get Title.
Properties::getDescription() — Method in class Properties
Get Description.
Properties::getSubject() — Method in class Properties
Get Subject.
Properties::getKeywords() — Method in class Properties
Get Keywords.
Properties::getCategory() — Method in class Properties
Get Category.
Properties::getCompany() — Method in class Properties
Get Company.
Properties::getManager() — Method in class Properties
Get Manager.
Properties::getCustomProperties() — Method in class Properties
Get a List of Custom Property Names.
Properties::getCustomPropertyValue() — Method in class Properties
Get a Custom Property Value.
Properties::getCustomPropertyType() — Method in class Properties
Get a Custom Property Type.
Security::getLockRevision() — Method in class Security
Get LockRevision.
Security::getLockStructure() — Method in class Security
Get LockStructure.
Security::getLockWindows() — Method in class Security
Get LockWindows.
Security::getRevisionsPassword() — Method in class Security
Get RevisionsPassword (hashed).
Security::getWorkbookPassword() — Method in class Security
Get WorkbookPassword (hashed).
HashTable::getIndexForHashCode() — Method in class HashTable
Get index for hash code.
HashTable::getByIndex() — Method in class HashTable
Get by index.
HashTable::getByHashCode() — Method in class HashTable
Get by hashcode.
Migrator::getMapping() — Method in class Migrator
Return the ordered mapping from old PHPExcel class names to new PhpSpreadsheet one.
Sample::getScriptFilename() — Method in class Sample
Return the filename currently being executed.
Sample::getPageTitle() — Method in class Sample
Return the page title.
Sample::getPageHeading() — Method in class Sample
Return the page heading.
Sample::getSamples() — Method in class Sample
Returns an array of all known samples.
Sample::getFilename() — Method in class Sample
Returns the filename that should be used for sample output.
Sample::getTemporaryFilename() — Method in class Sample
Return a random temporary file name.
IComparable::getHashCode() — Method in class IComparable
Get hash code.
NamedRange::getName() — Method in class NamedRange
Get name.
NamedRange::getWorksheet() — Method in class NamedRange
Get worksheet.
NamedRange::getRange() — Method in class NamedRange
Get range.
NamedRange::getLocalOnly() — Method in class NamedRange
Get localOnly.
NamedRange::getScope() — Method in class NamedRange
Get scope.
BaseReader::getReadDataOnly() — Method in class BaseReader
Read data only? If this is true, then the Reader will only read data values for cells, it will not read any formatting information.
BaseReader::getReadEmptyCells() — Method in class BaseReader
Read empty cells? If this is true (the default), then the Reader will read data values for all cells, irrespective of value.
BaseReader::getIncludeCharts() — Method in class BaseReader
Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook.
BaseReader::getLoadSheetsOnly() — Method in class BaseReader
Get which sheets to load Returns either an array of worksheet names (the list of worksheets that should be loaded), or a null indicating that all worksheets in the workbook should be loaded.
BaseReader::getReadFilter() — Method in class BaseReader
Read filter.
BaseReader::getSecuritySCanner() — Method in class BaseReader
Csv::getInputEncoding() — Method in class Csv
Get input encoding.
Csv::getDelimiter() — Method in class Csv
Get delimiter.
Csv::getEnclosure() — Method in class Csv
Get enclosure.
Csv::getSheetIndex() — Method in class Csv
Get sheet index.
Csv::getContiguous() — Method in class Csv
Get Contiguous.
Csv::getEscapeCharacter() — Method in class Csv
Get escape backslashes.
GnumericClass in namespace PhpOffice\PhpSpreadsheet\Reader
Html::getInputEncoding() — Method in class Html
Get input encoding.
Html::getTableStartColumn() — Method in class Html
Html::getSheetIndex() — Method in class Html
Get sheet index.
XmlScanner::getInstance() — Method in class XmlScanner
Slk::getInputEncoding() — Method in class Slk
Get input encoding.
Slk::getSheetIndex() — Method in class Slk
Get sheet index.
Xls::getUInt2d() — Method in class Xls
Read 16-bit unsigned integer.
Xls::getInt2d() — Method in class Xls
Read 16-bit signed integer.
Xls::getInt4d() — Method in class Xls
Read 32-bit signed integer.
MD5::getContext() — Method in class MD5
Get MD5 stream context.
Theme::getThemeName() — Method in class Theme
Get Theme Name.
Theme::getColourSchemeName() — Method in class Theme
Get colour Scheme Name.
Theme::getColourByIndex() — Method in class Theme
Get colour Map Value by Position.
ReferenceHelper::getInstance() — Method in class ReferenceHelper
Get an instance of this class.
ITextElement::getText() — Method in class ITextElement
Get text.
ITextElement::getFont() — Method in class ITextElement
Get font.
ITextElement::getHashCode() — Method in class ITextElement
Get hash code.
RichText::getPlainText() — Method in class RichText
Get plain text.
RichText::getRichTextElements() — Method in class RichText
Get Rich Text elements.
RichText::getHashCode() — Method in class RichText
Get hash code.
Run::getFont() — Method in class Run
Get font.
Run::getHashCode() — Method in class Run
Get hash code.
TextElement::getText() — Method in class TextElement
Get text.
TextElement::getFont() — Method in class TextElement
Get font.
TextElement::getHashCode() — Method in class TextElement
Get hash code.
Settings::getChartRenderer() — Method in class Settings
Return the Chart Rendering Library that PhpSpreadsheet is currently configured to use.
Settings::getLibXmlLoaderOptions() — Method in class Settings
Get default options for libxml loader.
Settings::getCache() — Method in class Settings
Gets the implementation of cache that should be used for cell collection.
Date::getExcelCalendar() — Method in class Date
Return the Excel calendar (Windows 1900 or Mac 1904).
Date::getDefaultTimezone() — Method in class Date
Return the Default timezone being used for dates.
Escher::getDggContainer() — Method in class Escher
Get Drawing Group Container.
Escher::getDgContainer() — Method in class Escher
Get Drawing Container.
DgContainer::getDgId() — Method in class DgContainer
DgContainer::getLastSpId() — Method in class DgContainer
DgContainer::getSpgrContainer() — Method in class DgContainer
SpgrContainer::getParent() — Method in class SpgrContainer
Get the parent Shape Group Container if any.
SpgrContainer::getChildren() — Method in class SpgrContainer
Get collection of Shape Containers.
SpgrContainer::getAllSpContainers() — Method in class SpgrContainer
Recursively get all spContainers within this spgrContainer.
SpContainer::getParent() — Method in class SpContainer
Get the parent Shape Group Container.
SpContainer::getSpgr() — Method in class SpContainer
Get whether this is a group shape.
SpContainer::getSpType() — Method in class SpContainer
Get the shape type.
SpContainer::getSpFlag() — Method in class SpContainer
Get the shape flag.
SpContainer::getSpId() — Method in class SpContainer
Get the shape index.
SpContainer::getOPT() — Method in class SpContainer
Get an option for the Shape Group Container.
SpContainer::getOPTCollection() — Method in class SpContainer
Get the collection of options.
SpContainer::getStartCoordinates() — Method in class SpContainer
Get cell coordinates of upper-left corner of shape.
SpContainer::getStartOffsetX() — Method in class SpContainer
Get offset in x-direction of upper-left corner of shape measured in 1/1024 of column width.
SpContainer::getStartOffsetY() — Method in class SpContainer
Get offset in y-direction of upper-left corner of shape measured in 1/256 of row height.
SpContainer::getEndCoordinates() — Method in class SpContainer
Get cell coordinates of bottom-right corner of shape.
SpContainer::getEndOffsetX() — Method in class SpContainer
Get offset in x-direction of bottom-right corner of shape measured in 1/1024 of column width.
SpContainer::getEndOffsetY() — Method in class SpContainer
Get offset in y-direction of bottom-right corner of shape measured in 1/256 of row height.
SpContainer::getNestingLevel() — Method in class SpContainer
Get the nesting level of this spContainer. This is the number of spgrContainers between this spContainer and the dgContainer. A value of 1 = immediately within first spgrContainer Higher nesting level occurs if and only if spContainer is part of a shape group.
DggContainer::getSpIdMax() — Method in class DggContainer
Get maximum shape index of all shapes in all drawings (plus one).
DggContainer::getCDgSaved() — Method in class DggContainer
Get total number of drawings saved.
DggContainer::getCSpSaved() — Method in class DggContainer
Get total number of shapes saved (including group shapes).
DggContainer::getBstoreContainer() — Method in class DggContainer
Get BLIP Store Container.
DggContainer::getOPT() — Method in class DggContainer
Get an option for the drawing group.
DggContainer::getIDCLs() — Method in class DggContainer
Get identifier clusters.
BstoreContainer::getBSECollection() — Method in class BstoreContainer
Get the collection of BLIP Store Entries.
BSE::getBlip() — Method in class BSE
Get the BLIP.
BSE::getBlipType() — Method in class BSE
Get the BLIP type.
Blip::getData() — Method in class Blip
Get the raw image data.
Blip::getParent() — Method in class Blip
Get parent BSE.
File::getUseUploadTempDirectory() — Method in class File
Get the flag indicating whether the File Upload Temp directory should be used for temporary files.
Font::getAutoSizeMethod() — Method in class Font
Get autoSize method.
Font::getTrueTypeFontPath() — Method in class Font
Get the path to the folder containing .ttf files.
Font::getTextWidthPixelsExact() — Method in class Font
Get GD text width in pixels for a string of text in a certain font at a certain rotation angle.
Font::getTextWidthPixelsApprox() — Method in class Font
Get approximate width in pixels for a string of text in a certain font at a certain rotation angle.
Font::getTrueTypeFontFileFromFont() — Method in class Font
Returns the font path given the font.
Font::getCharsetFromFontName() — Method in class Font
Returns the associated charset for the font name.
Font::getDefaultColumnWidthByFont() — Method in class Font
Get the effective column width for columns without a column dimension or column with width -1 For example, for Calibri 11 this is 9.140625 (64 px).
Font::getDefaultRowHeightByFont() — Method in class Font
Get the effective row height for rows without a row dimension or rows with height -1 For example, for Calibri 11 this is 15 points.
CholeskyDecomposition::getL() — Method in class CholeskyDecomposition
getL.
EigenvalueDecomposition::getV() — Method in class EigenvalueDecomposition
Return the eigenvector matrix.
EigenvalueDecomposition::getRealEigenvalues() — Method in class EigenvalueDecomposition
Return the real parts of the eigenvalues.
EigenvalueDecomposition::getImagEigenvalues() — Method in class EigenvalueDecomposition
Return the imaginary parts of the eigenvalues.
EigenvalueDecomposition::getD() — Method in class EigenvalueDecomposition
Return the block diagonal eigenvalue matrix.
LUDecomposition::getL() — Method in class LUDecomposition
Get lower triangular factor.
LUDecomposition::getU() — Method in class LUDecomposition
Get upper triangular factor.
LUDecomposition::getPivot() — Method in class LUDecomposition
Return pivot permutation vector.
LUDecomposition::getDoublePivot() — Method in class LUDecomposition
Alias for getPivot.
Matrix::getArray() — Method in class Matrix
getArray.
Matrix::getRowDimension() — Method in class Matrix
getRowDimension.
Matrix::getColumnDimension() — Method in class Matrix
getColumnDimension.
Matrix::get() — Method in class Matrix
get.
Matrix::getMatrix() — Method in class Matrix
getMatrix.
Matrix::getMatrixByRow() — Method in class Matrix
getMatrixByRow.
Matrix::getMatrixByCol() — Method in class Matrix
getMatrixByCol.
QRDecomposition::getH() — Method in class QRDecomposition
Return the Householder vectors.
QRDecomposition::getR() — Method in class QRDecomposition
Return the upper triangular factor.
QRDecomposition::getQ() — Method in class QRDecomposition
Generate and return the (economy-sized) orthogonal factor.
SingularValueDecomposition::getU() — Method in class SingularValueDecomposition
Return the left singular vectors.
SingularValueDecomposition::getV() — Method in class SingularValueDecomposition
Return the right singular vectors.
SingularValueDecomposition::getSingularValues() — Method in class SingularValueDecomposition
Return the one-dimensional array of singular values.
SingularValueDecomposition::getS() — Method in class SingularValueDecomposition
Return the diagonal matrix of singular values.
OLE::getStream() — Method in class OLE
Returns a stream for use with fread() etc. External callers should use \PhpOffice\PhpSpreadsheet\Shared\OLE\PPS\File::getStream().
OLE::getData() — Method in class OLE
Gets data from a PPS If there is no PPS for the index given, it will return an empty string.
OLE::getDataLength() — Method in class OLE
Gets the data length from a PPS If there is no PPS for the index given, it will return 0.
OLERead::getStream() — Method in class OLERead
Extract binary stream data.
PPS::getDataLen() — Method in class PPS
Returns the amount of data saved for this PPS.
StringHelper::getIsIconvEnabled() — Method in class StringHelper
Get whether iconv extension is available.
StringHelper::getDecimalSeparator() — Method in class StringHelper
Get the decimal separator. If it has not yet been set explicitly, try to obtain number formatting information from locale.
StringHelper::getThousandsSeparator() — Method in class StringHelper
Get the thousands separator. If it has not yet been set explicitly, try to obtain number formatting information from locale.
StringHelper::getCurrencyCode() — Method in class StringHelper
Get the currency code. If it has not yet been set explicitly, try to obtain the symbol information from locale.
TimeZone::getTimeZone() — Method in class TimeZone
Return the Default Timezone used for date/time conversions.
TimeZone::getTimeZoneAdjustment() — Method in class TimeZone
Return the Timezone offset used for date/time conversions to/from UST This requires both the timezone and the calculated date/time to allow for local DST.
$BestFit#goodnessOfFitProperty in class BestFit
BestFit::getError() — Method in class BestFit
BestFit::getBestFitType() — Method in class BestFit
BestFit::getValueOfYForX() — Method in class BestFit
Return the Y-Value for a specified value of X.
BestFit::getValueOfXForY() — Method in class BestFit
Return the X-Value for a specified value of Y.
BestFit::getXValues() — Method in class BestFit
Return the original set of X-Values.
BestFit::getEquation() — Method in class BestFit
Return the Equation of the best-fit line.
BestFit::getSlope() — Method in class BestFit
Return the Slope of the line.
BestFit::getSlopeSE() — Method in class BestFit
Return the standard error of the Slope.
BestFit::getIntersect() — Method in class BestFit
Return the Value of X where it intersects Y = 0.
BestFit::getIntersectSE() — Method in class BestFit
Return the standard error of the Intersect.
BestFit::getGoodnessOfFit() — Method in class BestFit
Return the goodness of fit for this regression.
BestFit::getGoodnessOfFitPercent() — Method in class BestFit
Return the goodness of fit for this regression.
BestFit::getStdevOfResiduals() — Method in class BestFit
Return the standard deviation of the residuals for this regression.
BestFit::getSSRegression() — Method in class BestFit
BestFit::getSSResiduals() — Method in class BestFit
BestFit::getDFResiduals() — Method in class BestFit
BestFit::getF() — Method in class BestFit
BestFit::getCovariance() — Method in class BestFit
BestFit::getCorrelation() — Method in class BestFit
BestFit::getYBestFitValues() — Method in class BestFit
ExponentialBestFit::getValueOfYForX() — Method in class ExponentialBestFit
Return the Y-Value for a specified value of X.
ExponentialBestFit::getValueOfXForY() — Method in class ExponentialBestFit
Return the X-Value for a specified value of Y.
ExponentialBestFit::getEquation() — Method in class ExponentialBestFit
Return the Equation of the best-fit line.
ExponentialBestFit::getSlope() — Method in class ExponentialBestFit
Return the Slope of the line.
ExponentialBestFit::getIntersect() — Method in class ExponentialBestFit
Return the Value of X where it intersects Y = 0.
LinearBestFit::getValueOfYForX() — Method in class LinearBestFit
Return the Y-Value for a specified value of X.
LinearBestFit::getValueOfXForY() — Method in class LinearBestFit
Return the X-Value for a specified value of Y.
LinearBestFit::getEquation() — Method in class LinearBestFit
Return the Equation of the best-fit line.
LogarithmicBestFit::getValueOfYForX() — Method in class LogarithmicBestFit
Return the Y-Value for a specified value of X.
LogarithmicBestFit::getValueOfXForY() — Method in class LogarithmicBestFit
Return the X-Value for a specified value of Y.
LogarithmicBestFit::getEquation() — Method in class LogarithmicBestFit
Return the Equation of the best-fit line.
PolynomialBestFit::getOrder() — Method in class PolynomialBestFit
Return the order of this polynomial.
PolynomialBestFit::getValueOfYForX() — Method in class PolynomialBestFit
Return the Y-Value for a specified value of X.
PolynomialBestFit::getValueOfXForY() — Method in class PolynomialBestFit
Return the X-Value for a specified value of Y.
PolynomialBestFit::getEquation() — Method in class PolynomialBestFit
Return the Equation of the best-fit line.
PolynomialBestFit::getSlope() — Method in class PolynomialBestFit
Return the Slope of the line.
PolynomialBestFit::getCoefficients() — Method in class PolynomialBestFit
PowerBestFit::getValueOfYForX() — Method in class PowerBestFit
Return the Y-Value for a specified value of X.
PowerBestFit::getValueOfXForY() — Method in class PowerBestFit
Return the X-Value for a specified value of Y.
PowerBestFit::getEquation() — Method in class PowerBestFit
Return the Equation of the best-fit line.
PowerBestFit::getIntersect() — Method in class PowerBestFit
Return the Value of X where it intersects Y = 0.
XMLWriter::getData() — Method in class XMLWriter
Get written data.
Xls::getDistanceX() — Method in class Xls
Get the horizontal distance in pixels between two anchors The distanceX is found as sum of all the spanning columns widths minus correction for the two offsets.
Xls::getDistanceY() — Method in class Xls
Get the vertical distance in pixels between two anchors The distanceY is found as sum of all the spanning rows minus two offsets.
Spreadsheet::getMacrosCode() — Method in class Spreadsheet
Return the macros code.
Spreadsheet::getMacrosCertificate() — Method in class Spreadsheet
Return the macros certificate.
Spreadsheet::getRibbonXMLData() — Method in class Spreadsheet
retrieve ribbon XML Data.
Spreadsheet::getUnparsedLoadedData() — Method in class Spreadsheet
List of unparsed loaded data for export to same format with better compatibility.
Spreadsheet::getRibbonBinObjects() — Method in class Spreadsheet
retrieve Binaries Ribbon Objects.
Spreadsheet::getSheetByCodeName() — Method in class Spreadsheet
Get sheet by code name. Warning : sheet don't have always a code name !
Spreadsheet::getCalculationEngine() — Method in class Spreadsheet
Return the calculation engine for this worksheet.
Spreadsheet::getProperties() — Method in class Spreadsheet
Get properties.
Spreadsheet::getSecurity() — Method in class Spreadsheet
Get security.
Spreadsheet::getActiveSheet() — Method in class Spreadsheet
Get active sheet.
Spreadsheet::getSheet() — Method in class Spreadsheet
Get sheet by index.
Spreadsheet::getAllSheets() — Method in class Spreadsheet
Get all sheets.
Spreadsheet::getSheetByName() — Method in class Spreadsheet
Get sheet by name.
Spreadsheet::getIndex() — Method in class Spreadsheet
Get index for sheet.
Spreadsheet::getSheetCount() — Method in class Spreadsheet
Get sheet count.
Spreadsheet::getActiveSheetIndex() — Method in class Spreadsheet
Get active sheet index.
Spreadsheet::getSheetNames() — Method in class Spreadsheet
Get sheet names.
Spreadsheet::getNamedRanges() — Method in class Spreadsheet
Get named ranges.
Spreadsheet::getNamedRange() — Method in class Spreadsheet
Get named range.
Spreadsheet::getWorksheetIterator() — Method in class Spreadsheet
Get worksheet iterator.
Spreadsheet::getCellXfCollection() — Method in class Spreadsheet
Get the workbook collection of cellXfs.
Spreadsheet::getCellXfByIndex() — Method in class Spreadsheet
Get cellXf by index.
Spreadsheet::getCellXfByHashCode() — Method in class Spreadsheet
Get cellXf by hash code.
Spreadsheet::getDefaultStyle() — Method in class Spreadsheet
Get default style.
Spreadsheet::getCellXfSupervisor() — Method in class Spreadsheet
Get the cellXf supervisor.
Spreadsheet::getCellStyleXfCollection() — Method in class Spreadsheet
Get the workbook collection of cellStyleXfs.
Spreadsheet::getCellStyleXfByIndex() — Method in class Spreadsheet
Get cellStyleXf by index.
Spreadsheet::getCellStyleXfByHashCode() — Method in class Spreadsheet
Get cellStyleXf by hash code.
Spreadsheet::garbageCollect() — Method in class Spreadsheet
Eliminate all unneeded cellXf and afterwards update the xfIndex for all cells and columns in the workbook.
Spreadsheet::getID() — Method in class Spreadsheet
Return the unique ID value assigned to this spreadsheet workbook.
Spreadsheet::getShowHorizontalScroll() — Method in class Spreadsheet
Get the visibility of the horizonal scroll bar in the application.
Spreadsheet::getShowVerticalScroll() — Method in class Spreadsheet
Get the visibility of the vertical scroll bar in the application.
Spreadsheet::getShowSheetTabs() — Method in class Spreadsheet
Get the visibility of the sheet tabs in the application.
Spreadsheet::getMinimized() — Method in class Spreadsheet
Return whether the workbook window is minimized.
Spreadsheet::getAutoFilterDateGrouping() — Method in class Spreadsheet
Return whether to group dates when presenting the user with filtering optiomd in the user interface.
Spreadsheet::getFirstSheetIndex() — Method in class Spreadsheet
Return the first sheet in the book view.
Spreadsheet::getVisibility() — Method in class Spreadsheet
Return the visibility status of the workbook.
Spreadsheet::getTabRatio() — Method in class Spreadsheet
Get the ratio between the workbook tabs bar and the horizontal scroll bar.
Alignment::getSharedComponent() — Method in class Alignment
Get the shared style component for the currently active cell in currently active sheet.
Alignment::getStyleArray() — Method in class Alignment
Build style array from subcomponents.
Alignment::getHorizontal() — Method in class Alignment
Get Horizontal.
Alignment::getVertical() — Method in class Alignment
Get Vertical.
Alignment::getTextRotation() — Method in class Alignment
Get TextRotation.
Alignment::getWrapText() — Method in class Alignment
Get Wrap Text.
Alignment::getShrinkToFit() — Method in class Alignment
Get Shrink to fit.
Alignment::getIndent() — Method in class Alignment
Get indent.
Alignment::getReadOrder() — Method in class Alignment
Get read order.
Alignment::getHashCode() — Method in class Alignment
Get hash code.
Border::getSharedComponent() — Method in class Border
Get the shared style component for the currently active cell in currently active sheet.
Border::getStyleArray() — Method in class Border
Build style array from subcomponents.
Border::getBorderStyle() — Method in class Border
Get Border style.
Border::getColor() — Method in class Border
Get Border Color.
Border::getHashCode() — Method in class Border
Get hash code.
Borders::getSharedComponent() — Method in class Borders
Get the shared style component for the currently active cell in currently active sheet.
Borders::getStyleArray() — Method in class Borders
Build style array from subcomponents.
Borders::getLeft() — Method in class Borders
Get Left.
Borders::getRight() — Method in class Borders
Get Right.
Borders::getTop() — Method in class Borders
Get Top.
Borders::getBottom() — Method in class Borders
Get Bottom.
Borders::getDiagonal() — Method in class Borders
Get Diagonal.
Borders::getAllBorders() — Method in class Borders
Get AllBorders (pseudo-border). Only applies to supervisor.
Borders::getOutline() — Method in class Borders
Get Outline (pseudo-border). Only applies to supervisor.
Borders::getInside() — Method in class Borders
Get Inside (pseudo-border). Only applies to supervisor.
Borders::getVertical() — Method in class Borders
Get Vertical (pseudo-border). Only applies to supervisor.
Borders::getHorizontal() — Method in class Borders
Get Horizontal (pseudo-border). Only applies to supervisor.
Borders::getDiagonalDirection() — Method in class Borders
Get DiagonalDirection.
Borders::getHashCode() — Method in class Borders
Get hash code.
Color::getSharedComponent() — Method in class Color
Get the shared style component for the currently active cell in currently active sheet.
Color::getStyleArray() — Method in class Color
Build style array from subcomponents.
Color::getARGB() — Method in class Color
Get ARGB.
Color::getRGB() — Method in class Color
Get RGB.
Color::getRed() — Method in class Color
Get the red colour component of an RGB value.
Color::getGreen() — Method in class Color
Get the green colour component of an RGB value.
Color::getBlue() — Method in class Color
Get the blue colour component of an RGB value.
Color::getHashCode() — Method in class Color
Get hash code.
Conditional::getConditionType() — Method in class Conditional
Get Condition type.
Conditional::getOperatorType() — Method in class Conditional
Get Operator type.
Conditional::getText() — Method in class Conditional
Get text.
Conditional::getStopIfTrue() — Method in class Conditional
Get StopIfTrue.
Conditional::getConditions() — Method in class Conditional
Get Conditions.
Conditional::getStyle() — Method in class Conditional
Get Style.
Conditional::getHashCode() — Method in class Conditional
Get hash code.
Fill::getSharedComponent() — Method in class Fill
Get the shared style component for the currently active cell in currently active sheet.
Fill::getStyleArray() — Method in class Fill
Build style array from subcomponents.
Fill::getFillType() — Method in class Fill
Get Fill Type.
Fill::getRotation() — Method in class Fill
Get Rotation.
Fill::getStartColor() — Method in class Fill
Get Start Color.
Fill::getEndColor() — Method in class Fill
Get End Color.
Fill::getHashCode() — Method in class Fill
Get hash code.
Font::getSharedComponent() — Method in class Font
Get the shared style component for the currently active cell in currently active sheet.
Font::getStyleArray() — Method in class Font
Build style array from subcomponents.
Font::getName() — Method in class Font
Get Name.
Font::getSize() — Method in class Font
Get Size.
Font::getBold() — Method in class Font
Get Bold.
Font::getItalic() — Method in class Font
Get Italic.
Font::getSuperscript() — Method in class Font
Get Superscript.
Font::getSubscript() — Method in class Font
Get Subscript.
Font::getUnderline() — Method in class Font
Get Underline.
Font::getStrikethrough() — Method in class Font
Get Strikethrough.
Font::getColor() — Method in class Font
Get Color.
Font::getHashCode() — Method in class Font
Get hash code.
NumberFormat::getSharedComponent() — Method in class NumberFormat
Get the shared style component for the currently active cell in currently active sheet.
NumberFormat::getStyleArray() — Method in class NumberFormat
Build style array from subcomponents.
NumberFormat::getFormatCode() — Method in class NumberFormat
Get Format Code.
NumberFormat::getBuiltInFormatCode() — Method in class NumberFormat
Get Built-In Format Code.
NumberFormat::getHashCode() — Method in class NumberFormat
Get hash code.
Protection::getSharedComponent() — Method in class Protection
Get the shared style component for the currently active cell in currently active sheet.
Protection::getStyleArray() — Method in class Protection
Build style array from subcomponents.
Protection::getLocked() — Method in class Protection
Get locked.
Protection::getHidden() — Method in class Protection
Get hidden.
Protection::getHashCode() — Method in class Protection
Get hash code.
Style::getSharedComponent() — Method in class Style
Get the shared style component for the currently active cell in currently active sheet.
Style::getParent() — Method in class Style
Get parent. Only used for style supervisor.
Style::getStyleArray() — Method in class Style
Build style array from subcomponents.
Style::getFill() — Method in class Style
Get Fill.
Style::getFont() — Method in class Style
Get Font.
Style::getBorders() — Method in class Style
Get Borders.
Style::getAlignment() — Method in class Style
Get Alignment.
Style::getNumberFormat() — Method in class Style
Get Number Format.
Style::getConditionalStyles() — Method in class Style
Get Conditional Styles. Only used on supervisor.
Style::getProtection() — Method in class Style
Get Protection.
Style::getQuotePrefix() — Method in class Style
Get quote prefix.
Style::getHashCode() — Method in class Style
Get hash code.
Style::getIndex() — Method in class Style
Get own index in style collection.
Supervisor::getIsSupervisor() — Method in class Supervisor
Is this a supervisor or a cell style component?
Supervisor::getActiveSheet() — Method in class Supervisor
Get the currently active sheet. Only used for supervisor.
Supervisor::getSelectedCells() — Method in class Supervisor
Get the currently active cell coordinate in currently active sheet.
Supervisor::getActiveCell() — Method in class Supervisor
Get the currently active cell coordinate in currently active sheet.
AutoFilter::getParent() — Method in class AutoFilter
Get AutoFilter Parent Worksheet.
AutoFilter::getRange() — Method in class AutoFilter
Get AutoFilter Range.
AutoFilter::getColumns() — Method in class AutoFilter
Get all AutoFilter Columns.
AutoFilter::getColumnOffset() — Method in class AutoFilter
Get a specified AutoFilter Column Offset within the defined AutoFilter range.
AutoFilter::getColumn() — Method in class AutoFilter
Get a specified AutoFilter Column.
AutoFilter::getColumnByOffset() — Method in class AutoFilter
Get a specified AutoFilter Column by it's offset.
Column::getColumnIndex() — Method in class Column
Get AutoFilter Column Index.
Column::getParent() — Method in class Column
Get this Column's AutoFilter Parent.
Column::getFilterType() — Method in class Column
Get AutoFilter Type.
Column::getJoin() — Method in class Column
Get AutoFilter Multiple Rules And/Or Join.
Column::getAttributes() — Method in class Column
Get AutoFilter Column Attributes.
Column::getAttribute() — Method in class Column
Get specific AutoFilter Column Attribute.
Column::getRules() — Method in class Column
Get all AutoFilter Column Rules.
Column::getRule() — Method in class Column
Get a specified AutoFilter Column Rule.
Rule::getRuleType() — Method in class Rule
Get AutoFilter Rule Type.
Rule::getValue() — Method in class Rule
Get AutoFilter Rule Value.
Rule::getOperator() — Method in class Rule
Get AutoFilter Rule Operator.
Rule::getGrouping() — Method in class Rule
Get AutoFilter Rule Grouping.
Rule::getParent() — Method in class Rule
Get this Rule's AutoFilter Column Parent.
BaseDrawing::getImageIndex() — Method in class BaseDrawing
Get image index.
BaseDrawing::getName() — Method in class BaseDrawing
Get Name.
BaseDrawing::getDescription() — Method in class BaseDrawing
Get Description.
BaseDrawing::getWorksheet() — Method in class BaseDrawing
Get Worksheet.
BaseDrawing::getCoordinates() — Method in class BaseDrawing
Get Coordinates.
BaseDrawing::getOffsetX() — Method in class BaseDrawing
Get OffsetX.
BaseDrawing::getOffsetY() — Method in class BaseDrawing
Get OffsetY.
BaseDrawing::getWidth() — Method in class BaseDrawing
Get Width.
BaseDrawing::getHeight() — Method in class BaseDrawing
Get Height.
BaseDrawing::getResizeProportional() — Method in class BaseDrawing
Get ResizeProportional.
BaseDrawing::getRotation() — Method in class BaseDrawing
Get Rotation.
BaseDrawing::getShadow() — Method in class BaseDrawing
Get Shadow.
BaseDrawing::getHashCode() — Method in class BaseDrawing
Get hash code.
BaseDrawing::getHyperlink() — Method in class BaseDrawing
CellIterator::getIterateOnlyExistingCells() — Method in class CellIterator
Get loop only existing cells.
Column::getColumnIndex() — Method in class Column
Get column index.
Column::getCellIterator() — Method in class Column
Get cell iterator.
ColumnDimension::getColumnIndex() — Method in class ColumnDimension
Get ColumnIndex.
ColumnDimension::getWidth() — Method in class ColumnDimension
Get Width.
ColumnDimension::getAutoSize() — Method in class ColumnDimension
Get Auto Size.
Dimension::getVisible() — Method in class Dimension
Get Visible.
Dimension::getOutlineLevel() — Method in class Dimension
Get Outline Level.
Dimension::getCollapsed() — Method in class Dimension
Get Collapsed.
Dimension::getXfIndex() — Method in class Dimension
Get index to cellXf.
Drawing::getFilename() — Method in class Drawing
Get Filename.
Drawing::getIndexedFilename() — Method in class Drawing
Get indexed filename (using image index).
Drawing::getExtension() — Method in class Drawing
Get Extension.
Drawing::getPath() — Method in class Drawing
Get Path.
Drawing::getHashCode() — Method in class Drawing
Get hash code.
Shadow::getVisible() — Method in class Shadow
Get Visible.
Shadow::getBlurRadius() — Method in class Shadow
Get Blur radius.
Shadow::getDistance() — Method in class Shadow
Get Shadow distance.
Shadow::getDirection() — Method in class Shadow
Get Shadow direction (in degrees).
Shadow::getAlignment() — Method in class Shadow
Get Shadow alignment.
Shadow::getColor() — Method in class Shadow
Get Color.
Shadow::getAlpha() — Method in class Shadow
Get Alpha.
Shadow::getHashCode() — Method in class Shadow
Get hash code.
HeaderFooter::getOddHeader() — Method in class HeaderFooter
Get OddHeader.
HeaderFooter::getOddFooter() — Method in class HeaderFooter
Get OddFooter.
HeaderFooter::getEvenHeader() — Method in class HeaderFooter
Get EvenHeader.
HeaderFooter::getEvenFooter() — Method in class HeaderFooter
Get EvenFooter.
HeaderFooter::getFirstHeader() — Method in class HeaderFooter
Get FirstHeader.
HeaderFooter::getFirstFooter() — Method in class HeaderFooter
Get FirstFooter.
HeaderFooter::getDifferentOddEven() — Method in class HeaderFooter
Get DifferentOddEven.
HeaderFooter::getDifferentFirst() — Method in class HeaderFooter
Get DifferentFirst.
HeaderFooter::getScaleWithDocument() — Method in class HeaderFooter
Get ScaleWithDocument.
HeaderFooter::getAlignWithMargins() — Method in class HeaderFooter
Get AlignWithMargins.
HeaderFooter::getImages() — Method in class HeaderFooter
Get header/footer images.
HeaderFooterDrawing::getHashCode() — Method in class HeaderFooterDrawing
Get hash code.
MemoryDrawing::getImageResource() — Method in class MemoryDrawing
Get image resource.
MemoryDrawing::getRenderingFunction() — Method in class MemoryDrawing
Get rendering function.
MemoryDrawing::getMimeType() — Method in class MemoryDrawing
Get mime type.
MemoryDrawing::getIndexedFilename() — Method in class MemoryDrawing
Get indexed filename (using image index).
MemoryDrawing::getHashCode() — Method in class MemoryDrawing
Get hash code.
PageMargins::getLeft() — Method in class PageMargins
Get Left.
PageMargins::getRight() — Method in class PageMargins
Get Right.
PageMargins::getTop() — Method in class PageMargins
Get Top.
PageMargins::getBottom() — Method in class PageMargins
Get Bottom.
PageMargins::getHeader() — Method in class PageMargins
Get Header.
PageMargins::getFooter() — Method in class PageMargins
Get Footer.
PageSetup::getPaperSize() — Method in class PageSetup
Get Paper Size.
PageSetup::getOrientation() — Method in class PageSetup
Get Orientation.
PageSetup::getScale() — Method in class PageSetup
Get Scale.
PageSetup::getFitToPage() — Method in class PageSetup
Get Fit To Page.
PageSetup::getFitToHeight() — Method in class PageSetup
Get Fit To Height.
PageSetup::getFitToWidth() — Method in class PageSetup
Get Fit To Width.
PageSetup::getColumnsToRepeatAtLeft() — Method in class PageSetup
Get Columns to repeat at left.
PageSetup::getRowsToRepeatAtTop() — Method in class PageSetup
Get Rows to repeat at top.
PageSetup::getHorizontalCentered() — Method in class PageSetup
Get center page horizontally.
PageSetup::getVerticalCentered() — Method in class PageSetup
Get center page vertically.
PageSetup::getPrintArea() — Method in class PageSetup
Get print area.
PageSetup::getFirstPageNumber() — Method in class PageSetup
Get first page number.
Protection::getSheet() — Method in class Protection
Get Sheet.
Protection::getObjects() — Method in class Protection
Get Objects.
Protection::getScenarios() — Method in class Protection
Get Scenarios.
Protection::getFormatCells() — Method in class Protection
Get FormatCells.
Protection::getFormatColumns() — Method in class Protection
Get FormatColumns.
Protection::getFormatRows() — Method in class Protection
Get FormatRows.
Protection::getInsertColumns() — Method in class Protection
Get InsertColumns.
Protection::getInsertRows() — Method in class Protection
Get InsertRows.
Protection::getInsertHyperlinks() — Method in class Protection
Get InsertHyperlinks.
Protection::getDeleteColumns() — Method in class Protection
Get DeleteColumns.
Protection::getDeleteRows() — Method in class Protection
Get DeleteRows.
Protection::getSelectLockedCells() — Method in class Protection
Get SelectLockedCells.
Protection::getSort() — Method in class Protection
Get Sort.
Protection::getAutoFilter() — Method in class Protection
Get AutoFilter.
Protection::getPivotTables() — Method in class Protection
Get PivotTables.
Protection::getSelectUnlockedCells() — Method in class Protection
Get SelectUnlockedCells.
Protection::getPassword() — Method in class Protection
Get Password (hashed).
Row::getRowIndex() — Method in class Row
Get row index.
Row::getCellIterator() — Method in class Row
Get cell iterator.
Row::getWorksheet() — Method in class Row
Returns bound worksheet.
RowDimension::getRowIndex() — Method in class RowDimension
Get Row Index.
RowDimension::getRowHeight() — Method in class RowDimension
Get Row Height.
RowDimension::getZeroHeight() — Method in class RowDimension
Get ZeroHeight.
SheetView::getZoomScale() — Method in class SheetView
Get ZoomScale.
SheetView::getZoomScaleNormal() — Method in class SheetView
Get ZoomScaleNormal.
SheetView::getView() — Method in class SheetView
Get View.
Worksheet::getCellCollection() — Method in class Worksheet
Return the cell collection.
Worksheet::getInvalidCharacters() — Method in class Worksheet
Get array of invalid characters for sheet title.
Worksheet::getCoordinates() — Method in class Worksheet
Get a sorted list of all cell coordinates currently held in the collection by row and column.
Worksheet::getRowDimensions() — Method in class Worksheet
Get collection of row dimensions.
Worksheet::getDefaultRowDimension() — Method in class Worksheet
Get default row dimension.
Worksheet::getColumnDimensions() — Method in class Worksheet
Get collection of column dimensions.
Worksheet::getDefaultColumnDimension() — Method in class Worksheet
Get default column dimension.
Worksheet::getDrawingCollection() — Method in class Worksheet
Get collection of drawings.
Worksheet::getChartCollection() — Method in class Worksheet
Get collection of charts.
Worksheet::getChartCount() — Method in class Worksheet
Return the count of charts on this worksheet.
Worksheet::getChartByIndex() — Method in class Worksheet
Get a chart by its index position.
Worksheet::getChartNames() — Method in class Worksheet
Return an array of the names of charts on this worksheet.
Worksheet::getChartByName() — Method in class Worksheet
Get a chart by name.
Worksheet::getParent() — Method in class Worksheet
Get parent.
Worksheet::getTitle() — Method in class Worksheet
Get title.
Worksheet::getSheetState() — Method in class Worksheet
Get sheet state.
Worksheet::getPageSetup() — Method in class Worksheet
Get page setup.
Worksheet::getPageMargins() — Method in class Worksheet
Get page margins.
Worksheet::getHeaderFooter() — Method in class Worksheet
Get page header/footer.
Worksheet::getSheetView() — Method in class Worksheet
Get sheet view.
Worksheet::getProtection() — Method in class Worksheet
Get Protection.
Worksheet::getHighestColumn() — Method in class Worksheet
Get highest worksheet column.
Worksheet::getHighestDataColumn() — Method in class Worksheet
Get highest worksheet column that contains data.
Worksheet::getHighestRow() — Method in class Worksheet
Get highest worksheet row.
Worksheet::getHighestDataRow() — Method in class Worksheet
Get highest worksheet row that contains data.
Worksheet::getHighestRowAndColumn() — Method in class Worksheet
Get highest worksheet column and highest row that have cell records.
Worksheet::getCell() — Method in class Worksheet
Get cell at a specific coordinate.
Worksheet::getCellByColumnAndRow() — Method in class Worksheet
Get cell at a specific coordinate by using numeric cell coordinates.
Worksheet::getRowDimension() — Method in class Worksheet
Get row dimension at a specific row.
Worksheet::getColumnDimension() — Method in class Worksheet
Get column dimension at a specific column.
Worksheet::getColumnDimensionByColumn() — Method in class Worksheet
Get column dimension at a specific column by using numeric cell coordinates.
Worksheet::getStyles() — Method in class Worksheet
Get styles.
Worksheet::getStyle() — Method in class Worksheet
Get style for cell.
Worksheet::getConditionalStyles() — Method in class Worksheet
Get conditional styles for a cell.
Worksheet::getConditionalStylesCollection() — Method in class Worksheet
Get collection of conditional styles.
Worksheet::getStyleByColumnAndRow() — Method in class Worksheet
Get style for cell by using numeric cell coordinates.
Worksheet::getBreaks() — Method in class Worksheet
Get breaks.
Worksheet::getMergeCells() — Method in class Worksheet
Get merge cells array.
Worksheet::getProtectedCells() — Method in class Worksheet
Get protected cells.
Worksheet::getAutoFilter() — Method in class Worksheet
Get Autofilter.
Worksheet::getFreezePane() — Method in class Worksheet
Get Freeze Pane.
Worksheet::getTopLeftCell() — Method in class Worksheet
Get the default position of the right bottom pane.
Worksheet::getShowGridlines() — Method in class Worksheet
Show gridlines?
Worksheet::getPrintGridlines() — Method in class Worksheet
Print gridlines?
Worksheet::getShowRowColHeaders() — Method in class Worksheet
Show row and column headers?
Worksheet::getShowSummaryBelow() — Method in class Worksheet
Show summary below? (Row/Column outlining).
Worksheet::getShowSummaryRight() — Method in class Worksheet
Show summary right? (Row/Column outlining).
Worksheet::getComments() — Method in class Worksheet
Get comments.
Worksheet::getComment() — Method in class Worksheet
Get comment for cell.
Worksheet::getCommentByColumnAndRow() — Method in class Worksheet
Get comment for cell by using numeric cell coordinates.
Worksheet::getActiveCell() — Method in class Worksheet
Get active cell.
Worksheet::getSelectedCells() — Method in class Worksheet
Get selected cells.
Worksheet::getRightToLeft() — Method in class Worksheet
Get right-to-left.
Worksheet::getRowIterator() — Method in class Worksheet
Get row iterator.
Worksheet::getColumnIterator() — Method in class Worksheet
Get column iterator.
Worksheet::garbageCollect() — Method in class Worksheet
Run PhpSpreadsheet garbage collector.
Worksheet::getHashCode() — Method in class Worksheet
Get hash code.
Worksheet::getHyperlink() — Method in class Worksheet
Get hyperlink.
Worksheet::getHyperlinkCollection() — Method in class Worksheet
Get collection of hyperlinks.
Worksheet::getDataValidation() — Method in class Worksheet
Get data validation.
Worksheet::getDataValidationCollection() — Method in class Worksheet
Get collection of data validations.
Worksheet::getTabColor() — Method in class Worksheet
Get tab color.
Worksheet::getCodeName() — Method in class Worksheet
Return the code name of the sheet.
BaseWriter::getIncludeCharts() — Method in class BaseWriter
Write charts in workbook? If this is true, then the Writer will write definitions for any charts that exist in the PhpSpreadsheet object.
BaseWriter::getPreCalculateFormulas() — Method in class BaseWriter
Get Pre-Calculate Formulas flag If this is true (the default), then the writer will recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file If false, then formulae are not calculated on save. This is faster for saving in PhpSpreadsheet, but slower when opening the resulting file in MS Excel, because Excel has to recalculate the formulae itself.
BaseWriter::getUseDiskCaching() — Method in class BaseWriter
Get use disk caching where possible?
BaseWriter::getDiskCachingDirectory() — Method in class BaseWriter
Get disk caching directory.
Csv::getDelimiter() — Method in class Csv
Get delimiter.
Csv::getEnclosure() — Method in class Csv
Get enclosure.
Csv::getLineEnding() — Method in class Csv
Get line ending.
Csv::getUseBOM() — Method in class Csv
Get whether BOM should be used.
Csv::getIncludeSeparatorLine() — Method in class Csv
Get whether a separator line should be included.
Csv::getExcelCompatibility() — Method in class Csv
Get whether the file should be saved with full Excel Compatibility.
Csv::getSheetIndex() — Method in class Csv
Get sheet index.
Html::getSheetIndex() — Method in class Html
Get sheet index.
Html::getGenerateSheetNavigationBlock() — Method in class Html
Get sheet index.
Html::generateHTMLHeader() — Method in class Html
Generate HTML header.
Html::generateSheetData() — Method in class Html
Generate sheet data.
Html::generateNavigation() — Method in class Html
Generate sheet tabs.
Html::generateStyles() — Method in class Html
Generate CSS styles.
Html::generateHTMLFooter() — Method in class Html
Generate HTML footer.
Html::getImagesRoot() — Method in class Html
Get images root.
Html::getEmbedImages() — Method in class Html
Get embed images.
Html::getUseInlineCss() — Method in class Html
Get use inline CSS?
Ods::getWriterPart() — Method in class Ods
Get writer part.
Ods::getSpreadsheet() — Method in class Ods
Get Spreadsheet object.
WriterPart::getParentWriter() — Method in class WriterPart
Get Ods writer.
Pdf::getFont() — Method in class Pdf
Get Font.
Pdf::getPaperSize() — Method in class Pdf
Get Paper Size.
Pdf::getOrientation() — Method in class Pdf
Get Orientation.
Pdf::getTempDir() — Method in class Pdf
Get temporary storage directory.
BIFFwriter::getByteOrder() — Method in class BIFFwriter
Determine the byte order and store it as class data to avoid recalculating it for each call to new().
Escher::getSpOffsets() — Method in class Escher
Gets the shape offsets.
Escher::getSpTypes() — Method in class Escher
Gets the shape types.
Workbook::getEscher() — Method in class Workbook
Get Escher object.
Worksheet::getData() — Method in class Worksheet
Retrieves data from memory in one chunk, or from disk in $buffer sized chunks.
Worksheet::getEscher() — Method in class Worksheet
Get Escher object.
Xlsx::getWriterPart() — Method in class Xlsx
Get writer part.
Xlsx::getSpreadsheet() — Method in class Xlsx
Get Spreadsheet object.
Xlsx::getStringTable() — Method in class Xlsx
Get string table.
Xlsx::getStyleHashTable() — Method in class Xlsx
Get Style HashTable.
Xlsx::getStylesConditionalHashTable() — Method in class Xlsx
Get Conditional HashTable.
Xlsx::getFillHashTable() — Method in class Xlsx
Get Fill HashTable.
Xlsx::getFontHashTable() — Method in class Xlsx
Get \PhpOffice\PhpSpreadsheet\Style\Font HashTable.
Xlsx::getBordersHashTable() — Method in class Xlsx
Get Borders HashTable.
Xlsx::getNumFmtHashTable() — Method in class Xlsx
Get NumberFormat HashTable.
Xlsx::getDrawingHashTable() — Method in class Xlsx
Get \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet\BaseDrawing HashTable.
Xlsx::getOffice2003Compatibility() — Method in class Xlsx
Get Office2003 compatibility.
WriterPart::getParentWriter() — Method in class WriterPart
Get parent Xlsx object.

H

DateTime::HOUROFDAY() — Method in class DateTime
HOUROFDAY.
Engineering::HEXTOBIN() — Method in class Engineering
HEXTOBIN.
Engineering::HEXTODEC() — Method in class Engineering
HEXTODEC.
Engineering::HEXTOOCT() — Method in class Engineering
HEXTOOCT.
LookupRef::HYPERLINK() — Method in class LookupRef
HYPERLINK.
LookupRef::HLOOKUP() — Method in class LookupRef
HLOOKUP The HLOOKUP function searches for value in the top-most row of lookup_array and returns the value in the same column based on the index_number.
Statistical::HARMEAN() — Method in class Statistical
HARMEAN.
Statistical::HYPGEOMDIST() — Method in class Statistical
HYPGEOMDIST.
Cell::hasDataValidation() — Method in class Cell
Does this cell contain Data validation rules?
Cell::hasValidValue() — Method in class Cell
Does this cell contain valid value?
Cell::hasHyperlink() — Method in class Cell
Does this cell contain a Hyperlink?
HyperlinkClass in namespace PhpOffice\PhpSpreadsheet\Cell
Cells::has() — Method in class Cells
Whether the collection holds a cell for the given coordinate.
Memory::has() — Method in class Memory
HashTableClass in namespace PhpOffice\PhpSpreadsheet
HtmlClass in namespace PhpOffice\PhpSpreadsheet\Helper
Html::handleCallback() — Method in class Html
HtmlClass in namespace PhpOffice\PhpSpreadsheet\Reader
PhpSpreadsheet root directory
Xml::hex2str() — Method in class Xml
PasswordHasher::hashPassword() — Method in class PasswordHasher
Create a password hash from a given string.
Spreadsheet::hasMacros() — Method in class Spreadsheet
The workbook has macros ?
Spreadsheet::hasMacrosCertificate() — Method in class Spreadsheet
Is the project signed ?
Spreadsheet::hasRibbon() — Method in class Spreadsheet
This workbook have a custom UI ?
Spreadsheet::hasRibbonBinObjects() — Method in class Spreadsheet
This workbook have additionnal object for the ribbon ?
$Alignment#horizontalProperty in class Alignment
Horizontal alignment.
$Borders#horizontalProperty in class Borders
Horizontal pseudo-border. Only applies to supervisor.
$Protection#hiddenProperty in class Protection
Hidden.
$BaseDrawing#heightProperty in class BaseDrawing
Height.
HeaderFooterClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
Header/Footer Formatting Syntax taken from Office Open XML Part 4 - Markup Language Reference, page 1970:.
HeaderFooterDrawingClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
Worksheet::hyperlinkExists() — Method in class Worksheet
Hyperlink at a specific coordinate exists?
Worksheet::hasCodeName() — Method in class Worksheet
Sheet has a code name ?
HtmlClass in namespace PhpOffice\PhpSpreadsheet\Writer

I

Calculation::isImplemented() — Method in class Calculation
Is a specific function implemented?
DateTime::isLeapYear() — Method in class DateTime
Identify if a year is a leap year or not.
DateTime::ISOWEEKNUM() — Method in class DateTime
ISOWEEKNUM.
Engineering::IMAGINARY() — Method in class Engineering
IMAGINARY.
Engineering::IMREAL() — Method in class Engineering
IMREAL.
Engineering::IMABS() — Method in class Engineering
IMABS.
Engineering::IMARGUMENT() — Method in class Engineering
IMARGUMENT.
Engineering::IMCONJUGATE() — Method in class Engineering
IMCONJUGATE.
Engineering::IMCOS() — Method in class Engineering
IMCOS.
Engineering::IMCOSH() — Method in class Engineering
IMCOSH.
Engineering::IMCOT() — Method in class Engineering
IMCOT.
Engineering::IMCSC() — Method in class Engineering
IMCSC.
Engineering::IMCSCH() — Method in class Engineering
IMCSCH.
Engineering::IMSIN() — Method in class Engineering
IMSIN.
Engineering::IMSINH() — Method in class Engineering
IMSINH.
Engineering::IMSEC() — Method in class Engineering
IMSEC.
Engineering::IMSECH() — Method in class Engineering
IMSECH.
Engineering::IMTAN() — Method in class Engineering
IMTAN.
Engineering::IMSQRT() — Method in class Engineering
IMSQRT.
Engineering::IMLN() — Method in class Engineering
IMLN.
Engineering::IMLOG10() — Method in class Engineering
IMLOG10.
Engineering::IMLOG2() — Method in class Engineering
IMLOG2.
Engineering::IMEXP() — Method in class Engineering
IMEXP.
Engineering::IMPOWER() — Method in class Engineering
IMPOWER.
Engineering::IMDIV() — Method in class Engineering
IMDIV.
Engineering::IMSUB() — Method in class Engineering
IMSUB.
Engineering::IMSUM() — Method in class Engineering
IMSUM.
Engineering::IMPRODUCT() — Method in class Engineering
IMPRODUCT.
Financial::INTRATE() — Method in class Financial
INTRATE.
Financial::IPMT() — Method in class Financial
IPMT.
Financial::IRR() — Method in class Financial
IRR.
Financial::ISPMT() — Method in class Financial
ISPMT.
Functions::isMatrixValue() — Method in class Functions
Functions::isValue() — Method in class Functions
Functions::isCellValue() — Method in class Functions
Functions::ifCondition() — Method in class Functions
Functions::isBlank() — Method in class Functions
IS_BLANK.
Functions::isErr() — Method in class Functions
IS_ERR.
Functions::isError() — Method in class Functions
IS_ERROR.
Functions::isNa() — Method in class Functions
IS_NA.
Functions::isEven() — Method in class Functions
IS_EVEN.
Functions::isOdd() — Method in class Functions
IS_ODD.
Functions::isNumber() — Method in class Functions
IS_NUMBER.
Functions::isLogical() — Method in class Functions
IS_LOGICAL.
Functions::isText() — Method in class Functions
IS_TEXT.
Functions::isNonText() — Method in class Functions
IS_NONTEXT.
Functions::isFormula() — Method in class Functions
ISFORMULA.
Logical::IFERROR() — Method in class Logical
IFERROR.
LookupRef::INDIRECT() — Method in class LookupRef
INDIRECT.
LookupRef::INDEX() — Method in class LookupRef
INDEX.
MathTrig::INT() — Method in class MathTrig
INT.
Statistical::INTERCEPT() — Method in class Statistical
INTERCEPT.
Cell::isFormula() — Method in class Cell
Identify if the cell contains a formula.
Cell::isInMergeRange() — Method in class Cell
Is this cell in a merge range.
Cell::isMergeRangeValueCell() — Method in class Cell
Is this cell the master (top left cell) in a merge range (that holds the actual data value).
Cell::isInRange() — Method in class Cell
Is cell in a specific range?
DataValidator::isValid() — Method in class DataValidator
Does this cell contain valid value?
Hyperlink::isInternal() — Method in class Hyperlink
Is this hyperlink internal? (to another worksheet).
IValueBinderClass in namespace PhpOffice\PhpSpreadsheet\Cell
DataSeriesValues::isMultiLevelSeries() — Method in class DataSeriesValues
Identify if the Data Series is a multi-level or a simple series.
IRendererClass in namespace PhpOffice\PhpSpreadsheet\Chart\Renderer
Properties::isCustomPropertySet() — Method in class Properties
Check if a Custom Property is defined.
Security::isSecurityEnabled() — Method in class Security
Is some sort of document security enabled?
$HashTable#itemsProperty in class HashTable
HashTable elements.
$Html#italicProperty in class Html
Html::initialise() — Method in class Html
Sample::isCli() — Method in class Sample
Returns whether we run on CLI or browser.
Sample::isIndex() — Method in class Sample
Whether we are executing the index page.
IComparableClass in namespace PhpOffice\PhpSpreadsheet
IOFactoryClass in namespace PhpOffice\PhpSpreadsheet
Factory to create readers and writers easily.
IOFactory::identify() — Method in class IOFactory
Identify file type using automatic Reader\IReader resolution.
$BaseReader#includeChartsProperty in class BaseReader
Read charts that are defined in the workbook? Identifies whether the Reader should read the definitions for any charts that exist in the workbook;.
Csv::inferSeparator() — Method in class Csv
Infer the separator if it isn't explicitly set in the file or specified by the user.
$Html#inputEncodingProperty in class Html
Input encoding.
IReadFilterClass in namespace PhpOffice\PhpSpreadsheet\Reader
IReaderClass in namespace PhpOffice\PhpSpreadsheet\Reader
$RC4#iProperty in class RC4
ReferenceHelper::insertNewBefore() — Method in class ReferenceHelper
Insert a new column or row, updating all possible related data.
ITextElementClass in namespace PhpOffice\PhpSpreadsheet\RichText
Date::isDateTime() — Method in class Date
Is a given cell a date/time?
Date::isDateTimeFormat() — Method in class Date
Is a given number format a date/time?
Date::isDateTimeFormatCode() — Method in class Date
Is a given number format code a date/time?
Drawing::imagecreatefrombmp() — Method in class Drawing
Create a new image from file. By alexander at alexauto dot nl.
Font::inchSizeToPixels() — Method in class Font
Calculate an (approximate) pixel size, based on inch size.
CholeskyDecomposition::isSPD() — Method in class CholeskyDecomposition
Is the matrix symmetric and positive definite?
LUDecomposition::isNonsingular() — Method in class LUDecomposition
Is the matrix nonsingular?
Matrix::identity() — Method in class Matrix
identity.
Matrix::inverse() — Method in class Matrix
Matrix inverse or pseudoinverse.
QRDecomposition::isFullRank() — Method in class QRDecomposition
Is the matrix full rank?
OLE::isFile() — Method in class OLE
Checks whether a PPS is a File PPS or not.
OLE::isRoot() — Method in class OLE
Checks whether a PPS is a Root PPS or not.
File::init() — Method in class File
Initialization method. Has to be called right after OLE_PPS_File().
StringHelper::isUTF8() — Method in class StringHelper
Check if a string contains UTF8 data.
$BestFit#intersectProperty in class BestFit
$BestFit#intersectSEProperty in class BestFit
$Alignment#indentProperty in class Alignment
Indent - only possible with horizontal alignment left and right.
$Borders#insideProperty in class Borders
Inside pseudo-border. Only applies to supervisor.
$Color#indexedColorsProperty in class Color
Indexed colors array.
Color::indexedColor() — Method in class Color
Get indexed color.
$Font#italicProperty in class Font
Italic.
$Style#indexProperty in class Style
Index of style in collection. Only used for real style.
$Supervisor#isSupervisorProperty in class Supervisor
Supervisor?
IteratorClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
PageSetup::isColumnsToRepeatAtLeftSet() — Method in class PageSetup
Is Columns to repeat at left set?
PageSetup::isRowsToRepeatAtTopSet() — Method in class PageSetup
Is Rows to repeat at top set?
PageSetup::isPrintAreaSet() — Method in class PageSetup
Is print area set?
Protection::isProtectionEnabled() — Method in class Protection
Is some sort of protection enabled?
Worksheet::insertNewRowBefore() — Method in class Worksheet
Insert a new row, updating all possible related data.
Worksheet::insertNewColumnBefore() — Method in class Worksheet
Insert a new column, updating all possible related data.
Worksheet::insertNewColumnBeforeByIndex() — Method in class Worksheet
Insert a new column, updating all possible related data.
Worksheet::isTabColorSet() — Method in class Worksheet
Tab color set?
$BaseWriter#includeChartsProperty in class BaseWriter
Write charts that are defined in the workbook? Identifies whether the Writer should write definitions for any charts that exist in the PhpSpreadsheet object;.
$Html#isPdfProperty in class Html
Is the current writer creating PDF?
IWriterClass in namespace PhpOffice\PhpSpreadsheet\Writer
Worksheet::insertBitmap() — Method in class Worksheet
Insert a 24bit bitmap image in a worksheet.

J

JpGraphClass in namespace PhpOffice\PhpSpreadsheet\Chart\Renderer
$RC4#jProperty in class RC4

K

Statistical::KURT() — Method in class Statistical
KURT.
$HashTable#keyMapProperty in class HashTable
HashTable key map.
ColumnCellIterator::key() — Method in class ColumnCellIterator
Return the current iterator key.
ColumnIterator::key() — Method in class ColumnIterator
Return the current iterator key.
Iterator::key() — Method in class Iterator
Current key.
RowCellIterator::key() — Method in class RowCellIterator
Return the current iterator key.
RowIterator::key() — Method in class RowIterator
Return the current iterator key.

L

$Calculation#localeBooleanProperty in class Calculation
Locale-specific translations for Excel constants (True, False and Null).
Calculation::localeFunc() — Method in class Calculation
LoggerClass in namespace PhpOffice\PhpSpreadsheet\Calculation\Engine
LogicalClass in namespace PhpOffice\PhpSpreadsheet\Calculation
Logical::logicalAnd() — Method in class Logical
LOGICAL_AND.
Logical::logicalOr() — Method in class Logical
LOGICAL_OR.
Logical::logicalXor() — Method in class Logical
LOGICAL_XOR.
LookupRefClass in namespace PhpOffice\PhpSpreadsheet\Calculation
LookupRef::LOOKUP() — Method in class LookupRef
LOOKUP The LOOKUP function searches for value either from a one-row or one-column range or from an array.
MathTrig::LCM() — Method in class MathTrig
LCM.
MathTrig::logBase() — Method in class MathTrig
LOG_BASE.
Statistical::LARGE() — Method in class Statistical
LARGE.
Statistical::LINEST() — Method in class Statistical
LINEST.
Statistical::LOGEST() — Method in class Statistical
LOGEST.
Statistical::LOGINV() — Method in class Statistical
LOGINV.
Statistical::LOGNORMDIST() — Method in class Statistical
LOGNORMDIST.
TextData::LEFT() — Method in class TextData
LEFT.
TextData::LOWERCASE() — Method in class TextData
LOWERCASE.
Stack::last() — Method in class Stack
Return an entry from the stack without removing it.
LayoutClass in namespace PhpOffice\PhpSpreadsheet\Chart
LegendClass in namespace PhpOffice\PhpSpreadsheet\Chart
Sample::log() — Method in class Sample
Sample::logEndingNotes() — Method in class Sample
Log ending notes.
Sample::logWrite() — Method in class Sample
Log a line about the write operation.
Sample::logRead() — Method in class Sample
Log a line about the read operation.
IOFactory::load() — Method in class IOFactory
Loads Spreadsheet from file using automatic Reader\IReader resolution.
$BaseReader#loadSheetsOnlyProperty in class BaseReader
Restrict which sheets should be loaded? This property holds an array of worksheet names to be loaded. If null, then all worksheets will be loaded.
Csv::listWorksheetInfo() — Method in class Csv
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
Csv::load() — Method in class Csv
Loads Spreadsheet from file.
Csv::loadIntoExisting() — Method in class Csv
Loads PhpSpreadsheet from file into PhpSpreadsheet instance.
Gnumeric::listWorksheetNames() — Method in class Gnumeric
Reads names of the worksheets from a file, without parsing the whole file to a Spreadsheet object.
Gnumeric::listWorksheetInfo() — Method in class Gnumeric
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
Gnumeric::load() — Method in class Gnumeric
Loads Spreadsheet from file.
Gnumeric::loadIntoExisting() — Method in class Gnumeric
Loads from file into Spreadsheet instance.
Html::load() — Method in class Html
Loads Spreadsheet from file.
Html::loadIntoExisting() — Method in class Html
Loads PhpSpreadsheet from file into PhpSpreadsheet instance.
IReader::load() — Method in class IReader
Loads PhpSpreadsheet from file.
Ods::listWorksheetNames() — Method in class Ods
Reads names of the worksheets from a file, without parsing the whole file to a PhpSpreadsheet object.
Ods::listWorksheetInfo() — Method in class Ods
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
Ods::load() — Method in class Ods
Loads PhpSpreadsheet from file.
Ods::loadIntoExisting() — Method in class Ods
Loads PhpSpreadsheet from file into PhpSpreadsheet instance.
Slk::listWorksheetInfo() — Method in class Slk
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
Slk::load() — Method in class Slk
Loads PhpSpreadsheet from file.
Slk::loadIntoExisting() — Method in class Slk
Loads PhpSpreadsheet from file into PhpSpreadsheet instance.
Xls::listWorksheetNames() — Method in class Xls
Reads names of the worksheets from a file, without parsing the whole file to a PhpSpreadsheet object.
Xls::listWorksheetInfo() — Method in class Xls
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
Xls::load() — Method in class Xls
Loads PhpSpreadsheet from file.
BIFF5::lookup() — Method in class BIFF5
Map color array from BIFF5 built-in color index.
BIFF8::lookup() — Method in class BIFF8
Map color array from BIFF8 built-in color index.
BuiltIn::lookup() — Method in class BuiltIn
Map built-in color to RGB value.
ErrorCode::lookup() — Method in class ErrorCode
Map error code, e.g. '#N/A'.
Escher::load() — Method in class Escher
Load Escher stream data. May be a partial Escher stream.
Border::lookup() — Method in class Border
Map border style OpenOffice documentation: 2.5.11.
FillPattern::lookup() — Method in class FillPattern
Get fill pattern from index OpenOffice documentation: 2.5.12.
Xlsx::listWorksheetNames() — Method in class Xlsx
Reads names of the worksheets from a file, without parsing the whole file to a Spreadsheet object.
Xlsx::listWorksheetInfo() — Method in class Xlsx
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
Xlsx::load() — Method in class Xlsx
Loads Spreadsheet from file.
Xml::listWorksheetNames() — Method in class Xml
Reads names of the worksheets from a file, without parsing the whole file to a Spreadsheet object.
Xml::listWorksheetInfo() — Method in class Xml
Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).
Xml::load() — Method in class Xml
Loads Spreadsheet from file.
Xml::loadIntoExisting() — Method in class Xml
Loads from file into Spreadsheet instance.
LUDecompositionClass in namespace PhpOffice\PhpSpreadsheet\Shared\JAMA
For an m-by-n matrix A with m >= n, the LU decomposition is an m-by-n unit lower triangular matrix L, an n-by-n upper triangular matrix U, and a permutation vector piv of length m so that A(piv,:) = L*U.
OLE::localDateToOLE() — Method in class OLE
Utility function Returns a string for the OLE container with the date given.
BestFit::leastSquareFit() — Method in class BestFit
LinearBestFitClass in namespace PhpOffice\PhpSpreadsheet\Shared\Trend
LogarithmicBestFitClass in namespace PhpOffice\PhpSpreadsheet\Shared\Trend
$Borders#leftProperty in class Borders
Left.
$Protection#lockedProperty in class Protection
Locked.
$Parser#lookAheadProperty in class Parser
The character ahead of the current char.

M

DateTime::MONTHOFYEAR() — Method in class DateTime
MONTHOFYEAR.
DateTime::MINUTE() — Method in class DateTime
MINUTE.
Financial::MIRR() — Method in class Financial
MIRR.
LookupRef::MATCH() — Method in class LookupRef
MATCH.
MathTrigClass in namespace PhpOffice\PhpSpreadsheet\Calculation
MathTrig::MDETERM() — Method in class MathTrig
MDETERM.
MathTrig::MINVERSE() — Method in class MathTrig
MINVERSE.
MathTrig::MMULT() — Method in class MathTrig
MMULT.
MathTrig::MOD() — Method in class MathTrig
MOD.
MathTrig::MROUND() — Method in class MathTrig
MROUND.
MathTrig::MULTINOMIAL() — Method in class MathTrig
MULTINOMIAL.
Statistical::MAX() — Method in class Statistical
MAX.
Statistical::MAXA() — Method in class Statistical
MAXA.
Statistical::MAXIF() — Method in class Statistical
MAXIF.
Statistical::MEDIAN() — Method in class Statistical
MEDIAN.
Statistical::MIN() — Method in class Statistical
MIN.
Statistical::MINA() — Method in class Statistical
MINA.
Statistical::MINIF() — Method in class Statistical
MINIF.
Statistical::MODE() — Method in class Statistical
MODE.
TextData::MID() — Method in class TextData
MID.
Coordinate::mergeRangesInCollection() — Method in class Coordinate
Convert an associative array of single cell coordinates to values to an associative array of cell ranges to values. Only adjacent cell coordinates with the same value will be merged. If the value is an object, it must implement the method getHashCode().
DataSeriesValues::multiLevelCount() — Method in class DataSeriesValues
Return the level count of a multi-level Data Series.
MemoryClass in namespace PhpOffice\PhpSpreadsheet\Collection
This is the default implementation for in-memory cell collection.
MigratorClass in namespace PhpOffice\PhpSpreadsheet\Helper
Migrator::migrate() — Method in class Migrator
Color::map() — Method in class Color
Read color.
$BIFF5#mapProperty in class BIFF5
$BIFF8#mapProperty in class BIFF8
$BuiltIn#mapProperty in class BuiltIn
$ErrorCode#mapProperty in class ErrorCode
MD5Class in namespace PhpOffice\PhpSpreadsheet\Reader\Xls
$Border#mapProperty in class Border
$FillPattern#mapProperty in class FillPattern
$Date#monthNamesProperty in class Date
Names of the months of the year, indexed by shortname Planned usage for locale settings.
Date::monthStringToNumber() — Method in class Date
Converts a month name (either a long or a short name) to a month number.
MatrixClass in namespace PhpOffice\PhpSpreadsheet\Shared\JAMA
Matrix class.
Matrix::minus() — Method in class Matrix
minus.
Matrix::minusEquals() — Method in class Matrix
minusEquals.
StringHelper::mbIsUpper() — Method in class StringHelper
StringHelper::mbStrSplit() — Method in class StringHelper
MemoryDrawingClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
Worksheet::mergeCells() — Method in class Worksheet
Set merge on a cell range.
Worksheet::mergeCellsByColumnAndRow() — Method in class Worksheet
Set merge on a cell range by using numeric cell coordinates.
MetaClass in namespace PhpOffice\PhpSpreadsheet\Writer\Ods
MetaInfClass in namespace PhpOffice\PhpSpreadsheet\Writer\Ods
MimetypeClass in namespace PhpOffice\PhpSpreadsheet\Writer\Ods
MpdfClass in namespace PhpOffice\PhpSpreadsheet\Writer\Pdf

N

DateTime::NETWORKDAYS() — Method in class DateTime
NETWORKDAYS.
Financial::NOMINAL() — Method in class Financial
NOMINAL.
Financial::NPER() — Method in class Financial
NPER.
Financial::NPV() — Method in class Financial
NPV.
Functions::NA() — Method in class Functions
NA.
Functions::NAN() — Method in class Functions
NaN.
Functions::NAME() — Method in class Functions
NAME.
Functions::null() — Method in class Functions
NULL.
Functions::n() — Method in class Functions
N.
Logical::NOT() — Method in class Logical
NOT.
Statistical::NEGBINOMDIST() — Method in class Statistical
NEGBINOMDIST.
Statistical::NORMDIST() — Method in class Statistical
NORMDIST.
Statistical::NORMINV() — Method in class Statistical
NORMINV.
Statistical::NORMSDIST() — Method in class Statistical
NORMSDIST.
Statistical::NORMSINV() — Method in class Statistical
NORMSINV.
TextData::NUMBERVALUE() — Method in class TextData
NUMBERVALUE.
NamedRangeClass in namespace PhpOffice\PhpSpreadsheet
$Html#nestedColumnProperty in class Html
CodePage::numberToName() — Method in class CodePage
Convert Microsoft Code Page Identifier to Code Page Name which iconv and mbstring understands.
$Date#numberSuffixesProperty in class Date
SingularValueDecomposition::norm2() — Method in class SingularValueDecomposition
Two norm.
$PPS#NoProperty in class PPS
The PPS index.
$PPS#NameProperty in class PPS
The PPS name (in Unicode).
$PPS#NextPpsProperty in class PPS
The index of the next PPS.
$Font#nameProperty in class Font
Font Name.
NumberFormatClass in namespace PhpOffice\PhpSpreadsheet\Style
$Style#numberFormatProperty in class Style
Number Format.
$BaseDrawing#nameProperty in class BaseDrawing
Name.
ColumnCellIterator::next() — Method in class ColumnCellIterator
Set the iterator to its next value.
ColumnIterator::next() — Method in class ColumnIterator
Set the iterator to its next value.
Iterator::next() — Method in class Iterator
Next value.
RowCellIterator::next() — Method in class RowCellIterator
Set the iterator to its next value.
RowIterator::next() — Method in class RowIterator
Set the iterator to its next value.
Worksheet::namedRangeToArray() — Method in class Worksheet
Create array from a range of cells.

O

CyclicReferenceStack::onStack() — Method in class CyclicReferenceStack
Test to see if a specified entry exists on the stack.
Engineering::OCTTOBIN() — Method in class Engineering
OCTTOBIN.
Engineering::OCTTODEC() — Method in class Engineering
OCTTODEC.
Engineering::OCTTOHEX() — Method in class Engineering
OCTTOHEX.
LookupRef::OFFSET() — Method in class LookupRef
OFFSET.
MathTrig::ODD() — Method in class MathTrig
ODD.
BaseReader::openFile() — Method in class BaseReader
Open file for reading.
OdsClass in namespace PhpOffice\PhpSpreadsheet\Reader
OLEClass in namespace PhpOffice\PhpSpreadsheet\Shared
OLE package base class.
OLE::OLE2LocalDate() — Method in class OLE
Returns a timestamp from an OLE container's date.
OLEReadClass in namespace PhpOffice\PhpSpreadsheet\Shared
$ChainedBlockStream#oleProperty in class ChainedBlockStream
The OLE container of the file that is being read.
$PPS#oleProperty in class PPS
Pointer to OLE container.
$PolynomialBestFit#orderProperty in class PolynomialBestFit
Polynomial order.
Xls::oneAnchor2twoAnchor() — Method in class Xls
Convert 1-cell anchor coordinates to 2-cell anchor coordinates This function is ported from PEAR Spreadsheet_Writer_Excel with small modifications.
$Borders#outlineProperty in class Borders
Outline pseudo-border. Only applies to supervisor.
$BaseDrawing#offsetXProperty in class BaseDrawing
Offset X.
$BaseDrawing#offsetYProperty in class BaseDrawing
Offset Y.
$CellIterator#onlyExistingCellsProperty in class CellIterator
Iterate only existing cells.
OdsClass in namespace PhpOffice\PhpSpreadsheet\Writer
$Pdf#orientationProperty in class Pdf
Orientation (Over-ride).

P

Calculation::parseFormula() — Method in class Calculation
Validate and parse a formula string.
CyclicReferenceStack::push() — Method in class CyclicReferenceStack
Push a new entry onto the stack.
CyclicReferenceStack::pop() — Method in class CyclicReferenceStack
Pop the last entry from the stack.
Engineering::parseComplex() — Method in class Engineering
parseComplex.
Financial::PDURATION() — Method in class Financial
PDURATION.
Financial::PMT() — Method in class Financial
PMT.
Financial::PPMT() — Method in class Financial
PPMT.
Financial::PRICE() — Method in class Financial
Financial::PRICEDISC() — Method in class Financial
PRICEDISC.
Financial::PRICEMAT() — Method in class Financial
PRICEMAT.
Financial::PV() — Method in class Financial
PV.
MathTrig::POWER() — Method in class MathTrig
POWER.
MathTrig::PRODUCT() — Method in class MathTrig
PRODUCT.
Statistical::PERCENTILE() — Method in class Statistical
PERCENTILE.
Statistical::PERCENTRANK() — Method in class Statistical
PERCENTRANK.
Statistical::PERMUT() — Method in class Statistical
PERMUT.
Statistical::POISSON() — Method in class Statistical
POISSON.
TextData::PROPERCASE() — Method in class TextData
PROPERCASE.
Stack::push() — Method in class Stack
Push a new entry onto the stack.
Stack::pop() — Method in class Stack
Pop the last entry from the stack.
PlotAreaClass in namespace PhpOffice\PhpSpreadsheet\Chart
PropertiesClass in namespace PhpOffice\PhpSpreadsheet\Chart
Created by PhpStorm.
PropertiesClass in namespace PhpOffice\PhpSpreadsheet\Document
Html::parseTextNode() — Method in class Html
Html::parseElementNode() — Method in class Html
Html::parseElements() — Method in class Html
Html::processDomElement() — Method in class Html
Xml::pixel2WidthUnits() — Method in class Xml
pixel units to excel width units(units of 1/256th of a character width).
Xml::parseRichText() — Method in class Xml
Date::PHPToExcel() — Method in class Date
Convert a date from PHP to an MS Excel serialized date/time value.
Drawing::pixelsToEMU() — Method in class Drawing
Convert pixels to EMU.
Drawing::pixelsToCellDimension() — Method in class Drawing
Convert pixels to column width. Exact algorithm not known.
Drawing::pixelsToPoints() — Method in class Drawing
Convert pixels to points.
Drawing::pointsToPixels() — Method in class Drawing
Convert points to pixels.
Matrix::plus() — Method in class Matrix
plus.
Matrix::plusEquals() — Method in class Matrix
plusEquals.
Matrix::power() — Method in class Matrix
power.
OLE::ppsTotal() — Method in class OLE
Gives the total number of PPS's found in the OLE container.
$ChainedBlockStream#paramsProperty in class ChainedBlockStream
Parameters specified by fopen().
$ChainedBlockStream#posProperty in class ChainedBlockStream
The file pointer.
PPSClass in namespace PhpOffice\PhpSpreadsheet\Shared\OLE
Class for creating PPS's for OLE containers.
$PPS#PrevPpsProperty in class PPS
The index of the previous PPS.
PasswordHasherClass in namespace PhpOffice\PhpSpreadsheet\Shared
PolynomialBestFitClass in namespace PhpOffice\PhpSpreadsheet\Shared\Trend
PowerBestFitClass in namespace PhpOffice\PhpSpreadsheet\Shared\Trend
ProtectionClass in namespace PhpOffice\PhpSpreadsheet\Style
$Style#protectionProperty in class Style
Protection.
$Supervisor#parentProperty in class Supervisor
Parent. Only used for supervisor.
$Supervisor#parentPropertyNameProperty in class Supervisor
Parent property name.
ColumnCellIterator::prev() — Method in class ColumnCellIterator
Set the iterator to its previous value.
ColumnIterator::prev() — Method in class ColumnIterator
Set the iterator to its previous value.
PageMarginsClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
PageSetupClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
Paper size taken from Office Open XML Part 4 - Markup Language Reference, page 1988:.
ProtectionClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
RowCellIterator::prev() — Method in class RowCellIterator
Set the iterator to its previous value.
RowIterator::prev() — Method in class RowIterator
Set the iterator to its previous value.
Worksheet::protectCells() — Method in class Worksheet
Set protection on a cell range.
Worksheet::protectCellsByColumnAndRow() — Method in class Worksheet
Set protection on a cell range by using numeric cell coordinates.
$BaseWriter#preCalculateFormulasProperty in class BaseWriter
Pre-calculate formulas Forces PhpSpreadsheet to recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file.
PdfClass in namespace PhpOffice\PhpSpreadsheet\Writer
$Pdf#paperSizeProperty in class Pdf
Paper size (Over-ride).
$Pdf#paperSizesProperty in class Pdf
Paper Sizes xRef List.
Pdf::prepareForSave() — Method in class Pdf
Save Spreadsheet to PDF file, pre-save.
ParserClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xls
Parser::parse() — Method in class Parser
The parsing method. It parses a formula.
$Worksheet#phpSheetProperty in class Worksheet
Sheet object.
Worksheet::printRowColHeaders() — Method in class Worksheet
Set the option to print the row and column headers on the printed page.
Worksheet::positionImage() — Method in class Worksheet
Calculate the vertices that define the position of the image as required by the OBJ record.
Worksheet::processBitmapGd() — Method in class Worksheet
Convert a GD-image into the internal format.
Worksheet::processBitmap() — Method in class Worksheet
Convert a 24 bit bitmap into the modified internal format used by Windows.

Q

MathTrig::QUOTIENT() — Method in class MathTrig
QUOTIENT.
Statistical::QUARTILE() — Method in class Statistical
QUARTILE.
QRDecompositionClass in namespace PhpOffice\PhpSpreadsheet\Shared\JAMA
For an m-by-n matrix A with m >= n, the QR decomposition is an m-by-n orthogonal matrix Q and an n-by-n upper triangular matrix R so that A = Q*R.
$Style#quotePrefixProperty in class Style
Use Quote Prefix when displaying in cell editor. Only used for real style.

R

Calculation::renameCalculationCacheForWorksheet() — Method in class Calculation
Rename calculation cache for a specified worksheet.
Calculation::raiseFormulaError() — Method in class Calculation
Financial::RATE() — Method in class Financial
RATE.
Financial::RECEIVED() — Method in class Financial
RECEIVED.
Financial::RRI() — Method in class Financial
RRI.
$Functions#returnDateTypeProperty in class Functions
Data Type to use when returning date values.
Functions::REF() — Method in class Functions
REF.
LookupRef::ROW() — Method in class LookupRef
ROW.
LookupRef::ROWS() — Method in class LookupRef
ROWS.
MathTrig::RAND() — Method in class MathTrig
RAND.
MathTrig::ROMAN() — Method in class MathTrig
MathTrig::ROUNDUP() — Method in class MathTrig
ROUNDUP.
MathTrig::ROUNDDOWN() — Method in class MathTrig
ROUNDDOWN.
Statistical::RANK() — Method in class Statistical
RANK.
Statistical::RSQ() — Method in class Statistical
RSQ.
TextData::RIGHT() — Method in class TextData
RIGHT.
TextData::REPLACE() — Method in class TextData
REPLACE.
TextData::RETURNSTRING() — Method in class TextData
RETURNSTRING.
Cell::rebindParent() — Method in class Cell
Re-bind parent.
Coordinate::rangeBoundaries() — Method in class Coordinate
Calculate range boundaries.
Coordinate::rangeDimension() — Method in class Coordinate
Calculate range dimension.
Chart::refresh() — Method in class Chart
Chart::render() — Method in class Chart
Render the chart to given file (or stream).
DataSeries::refresh() — Method in class DataSeries
DataSeriesValues::refresh() — Method in class DataSeriesValues
PlotArea::refresh() — Method in class PlotArea
IRenderer::render() — Method in class IRenderer
Render the chart to given file (or stream).
JpGraph::render() — Method in class JpGraph
Render the chart to given file (or stream).
Cells::removeRow() — Method in class Cells
Remove a row, deleting all cells in that row.
Cells::removeColumn() — Method in class Cells
Remove a column, deleting all cells in that column.
HashTable::remove() — Method in class HashTable
Remove HashTable item.
$Html#richTextObjectProperty in class Html
Html::rgbToColour() — Method in class Html
Migrator::replace() — Method in class Migrator
Migrate the given code from PHPExcel to PhpSpreadsheet.
IOFactory::registerWriter() — Method in class IOFactory
Register a writer with its type and class name.
IOFactory::registerReader() — Method in class IOFactory
Register a reader with its type and class name.
NamedRange::resolveRange() — Method in class NamedRange
Resolve a named range to a regular cell range.
$BaseReader#readDataOnlyProperty in class BaseReader
Read data only? Identifies whether the Reader should only read data values for cells, and ignore any formatting information; or whether it should read both data and formatting.
$BaseReader#readEmptyCellsProperty in class BaseReader
Read empty cells? Identifies whether the Reader should read data values for cells all cells, or should ignore cells containing null value or empty string.
$BaseReader#readFilterProperty in class BaseReader
IReadFilter instance.
DefaultReadFilter::readCell() — Method in class DefaultReadFilter
Should this cell be read?
$Html#rowspanProperty in class Html
Html::releaseTableStartColumn() — Method in class Html
IReadFilter::readCell() — Method in class IReadFilter
Should this cell be read?
MD5::reset() — Method in class MD5
Reset the MD5 stream context.
RC4Class in namespace PhpOffice\PhpSpreadsheet\Reader\Xls
RC4::RC4() — Method in class RC4
Symmetric decryption/encryption function.
Chart::readChart() — Method in class Chart
ReferenceHelperClass in namespace PhpOffice\PhpSpreadsheet
RichTextClass in namespace PhpOffice\PhpSpreadsheet\RichText
RunClass in namespace PhpOffice\PhpSpreadsheet\RichText
File::realpath() — Method in class File
Returns canonicalized absolute pathname, also for ZIP archives.
SingularValueDecomposition::rank() — Method in class SingularValueDecomposition
Effective numerical matrix rank.
$OLE#rootProperty in class OLE
Root directory of OLE container.
OLE::read() — Method in class OLE
Reads an OLE container from the contents of the file given.
OLERead::read() — Method in class OLERead
Read the file.
RootClass in namespace PhpOffice\PhpSpreadsheet\Shared\OLE\PPS
Class for creating Root PPS's for OLE containers.
Spreadsheet::removeSheetByIndex() — Method in class Spreadsheet
Remove sheet by index.
Spreadsheet::removeNamedRange() — Method in class Spreadsheet
Remove named range.
Spreadsheet::removeCellXfByIndex() — Method in class Spreadsheet
Remove cellXf by index. It is ensured that all cells get their xf index updated.
Spreadsheet::removeCellStyleXfByIndex() — Method in class Spreadsheet
Remove cellStyleXf by index.
$Alignment#readOrderProperty in class Alignment
Read order.
$Borders#rightProperty in class Borders
Right.
$Fill#rotationProperty in class Fill
Rotation.
RuleClass in namespace PhpOffice\PhpSpreadsheet\Worksheet\AutoFilter\Column
$BaseDrawing#resizeProportionalProperty in class BaseDrawing
Proportional resize.
$BaseDrawing#rotationProperty in class BaseDrawing
Rotation.
ColumnCellIterator::resetStart() — Method in class ColumnCellIterator
(Re)Set the start row and the current row pointer.
ColumnCellIterator::resetEnd() — Method in class ColumnCellIterator
(Re)Set the end row.
ColumnCellIterator::rewind() — Method in class ColumnCellIterator
Rewind the iterator to the starting row.
ColumnIterator::resetStart() — Method in class ColumnIterator
(Re)Set the start column and the current column pointer.
ColumnIterator::resetEnd() — Method in class ColumnIterator
(Re)Set the end column.
ColumnIterator::rewind() — Method in class ColumnIterator
Rewind the iterator to the starting column.
HeaderFooter::removeImage() — Method in class HeaderFooter
Remove header/footer image.
Iterator::rewind() — Method in class Iterator
Rewind iterator.
PageSetup::resetFirstPageNumber() — Method in class PageSetup
Reset first page number.
RowClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
RowCellIteratorClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
RowCellIterator::resetStart() — Method in class RowCellIterator
(Re)Set the start column and the current column pointer.
RowCellIterator::resetEnd() — Method in class RowCellIterator
(Re)Set the end column.
RowCellIterator::rewind() — Method in class RowCellIterator
Rewind the iterator to the starting column.
RowDimensionClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
RowIteratorClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
RowIterator::resetStart() — Method in class RowIterator
(Re)Set the start row and the current row pointer.
RowIterator::resetEnd() — Method in class RowIterator
(Re)Set the end row.
RowIterator::rewind() — Method in class RowIterator
Rewind the iterator to the starting row.
Worksheet::refreshColumnDimensions() — Method in class Worksheet
Refresh column dimensions.
Worksheet::refreshRowDimensions() — Method in class Worksheet
Refresh row dimensions.
Worksheet::rebindParent() — Method in class Worksheet
Re-bind parent.
Worksheet::removeConditionalStyles() — Method in class Worksheet
Removes conditional styles for a cell.
Worksheet::removeAutoFilter() — Method in class Worksheet
Remove autofilter.
Worksheet::removeRow() — Method in class Worksheet
Delete a row, updating all possible related data.
Worksheet::removeColumn() — Method in class Worksheet
Remove a column, updating all possible related data.
Worksheet::removeColumnByIndex() — Method in class Worksheet
Remove a column, updating all possible related data.
Worksheet::rangeToArray() — Method in class Worksheet
Create array from a range of cells.
Worksheet::resetTabColor() — Method in class Worksheet
Reset tab color.
Pdf::restoreStateAfterSave() — Method in class Pdf
Save PhpSpreadsheet to PDF file, post-save.
$Parser#referencesProperty in class Parser
Array of sheet references in the form of REF structures.
RelsClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx
RelsRibbonClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx
RelsVBAClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx

S

$Calculation#suppressFormulaErrorsProperty in class Calculation
Flag to determine how formula errors should be handled If true, then a user error will be triggered If false, then an exception will be thrown.
Calculation::setArrayReturnType() — Method in class Calculation
Set the Array Return Type (Array or Value of first element in the array).
Calculation::setCalculationCacheEnabled() — Method in class Calculation
Enable/disable calculation cache.
Calculation::setLocale() — Method in class Calculation
Set the locale code.
Calculation::saveValueToCache() — Method in class Calculation
DateTime::SECOND() — Method in class DateTime
SECOND.
CyclicReferenceStack::showStack() — Method in class CyclicReferenceStack
Return an array of all entries on the stack.
Logger::setWriteDebugLog() — Method in class Logger
Enable/Disable Calculation engine logging.
Logger::setEchoDebugLog() — Method in class Logger
Enable/Disable echoing of debug log information.
Financial::SLN() — Method in class Financial
SLN.
Financial::SYD() — Method in class Financial
SYD.
FormulaToken::setValue() — Method in class FormulaToken
Set Value.
FormulaToken::setTokenType() — Method in class FormulaToken
Set Token Type (represented by TOKEN_TYPE_*).
FormulaToken::setTokenSubType() — Method in class FormulaToken
Set Token SubType (represented by TOKEN_SUBTYPE_*).
Functions::setCompatibilityMode() — Method in class Functions
Set the Compatibility Mode.
Functions::setReturnDateType() — Method in class Functions
Set the Return Date Format used by functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object).
Logical::statementIf() — Method in class Logical
STATEMENT_IF.
MathTrig::SERIESSUM() — Method in class MathTrig
SERIESSUM.
MathTrig::SIGN() — Method in class MathTrig
SIGN.
MathTrig::SQRTPI() — Method in class MathTrig
SQRTPI.
MathTrig::SUBTOTAL() — Method in class MathTrig
SUBTOTAL.
MathTrig::SUM() — Method in class MathTrig
SUM.
MathTrig::SUMIF() — Method in class MathTrig
SUMIF.
MathTrig::SUMIFS() — Method in class MathTrig
SUMIFS.
MathTrig::SUMPRODUCT() — Method in class MathTrig
SUMPRODUCT.
MathTrig::SUMSQ() — Method in class MathTrig
SUMSQ.
MathTrig::SUMX2MY2() — Method in class MathTrig
SUMX2MY2.
MathTrig::SUMX2PY2() — Method in class MathTrig
SUMX2PY2.
MathTrig::SUMXMY2() — Method in class MathTrig
SUMXMY2.
MathTrig::SEC() — Method in class MathTrig
SEC.
MathTrig::SECH() — Method in class MathTrig
SECH.
StatisticalClass in namespace PhpOffice\PhpSpreadsheet\Calculation
Statistical::SKEW() — Method in class Statistical
SKEW.
Statistical::SLOPE() — Method in class Statistical
SLOPE.
Statistical::SMALL() — Method in class Statistical
SMALL.
Statistical::STANDARDIZE() — Method in class Statistical
STANDARDIZE.
Statistical::STDEV() — Method in class Statistical
STDEV.
Statistical::STDEVA() — Method in class Statistical
STDEVA.
Statistical::STDEVP() — Method in class Statistical
STDEVP.
Statistical::STDEVPA() — Method in class Statistical
STDEVPA.
Statistical::STEYX() — Method in class Statistical
STEYX.
TextData::SEARCHSENSITIVE() — Method in class TextData
SEARCHSENSITIVE.
TextData::SEARCHINSENSITIVE() — Method in class TextData
SEARCHINSENSITIVE.
TextData::STRINGLENGTH() — Method in class TextData
STRINGLENGTH.
TextData::SUBSTITUTE() — Method in class TextData
SUBSTITUTE.
StackClass in namespace PhpOffice\PhpSpreadsheet\Calculation\Token
Cell::setValue() — Method in class Cell
Set cell value.
Cell::setValueExplicit() — Method in class Cell
Set the value for a cell, with the explicit data type passed to the method (bypassing any use of the value binder).
Cell::setCalculatedValue() — Method in class Cell
Set old calculated value (cached).
Cell::setDataType() — Method in class Cell
Set cell data type.
Cell::setDataValidation() — Method in class Cell
Set Data validation rules.
Cell::setHyperlink() — Method in class Cell
Set Hyperlink.
Cell::setValueBinder() — Method in class Cell
Set value binder to use.
Cell::setXfIndex() — Method in class Cell
Set index to cellXf.
Cell::setFormulaAttributes() — Method in class Cell
Set the formula attributes.
Coordinate::splitRange() — Method in class Coordinate
Split range into coordinate strings.
Coordinate::stringFromColumnIndex() — Method in class Coordinate
String from column index.
DataValidation::setFormula1() — Method in class DataValidation
Set Formula 1.
DataValidation::setFormula2() — Method in class DataValidation
Set Formula 2.
DataValidation::setType() — Method in class DataValidation
Set Type.
DataValidation::setErrorStyle() — Method in class DataValidation
Set Error style.
DataValidation::setOperator() — Method in class DataValidation
Set Operator.
DataValidation::setAllowBlank() — Method in class DataValidation
Set Allow Blank.
DataValidation::setShowDropDown() — Method in class DataValidation
Set Show DropDown.
DataValidation::setShowInputMessage() — Method in class DataValidation
Set Show InputMessage.
DataValidation::setShowErrorMessage() — Method in class DataValidation
Set Show ErrorMessage.
DataValidation::setErrorTitle() — Method in class DataValidation
Set Error title.
DataValidation::setError() — Method in class DataValidation
Set Error.
DataValidation::setPromptTitle() — Method in class DataValidation
Set Prompt title.
DataValidation::setPrompt() — Method in class DataValidation
Set Prompt.
Hyperlink::setUrl() — Method in class Hyperlink
Set URL.
Hyperlink::setTooltip() — Method in class Hyperlink
Set tooltip.
Axis::setAxisNumberProperties() — Method in class Axis
Get Series Data Type.
Axis::setAxisOptionsProperties() — Method in class Axis
Set Axis Options Properties.
Axis::setAxisOrientation() — Method in class Axis
Set Axis Orientation Property.
Axis::setFillParameters() — Method in class Axis
Set Fill Property.
Axis::setLineParameters() — Method in class Axis
Set Line Property.
Axis::setLineStyleProperties() — Method in class Axis
Set Line Style Properties.
Axis::setShadowProperties() — Method in class Axis
Set Shadow Properties.
Axis::setGlowProperties() — Method in class Axis
Set Glow Properties.
Axis::setSoftEdges() — Method in class Axis
Set Soft Edges Size.
Chart::setWorksheet() — Method in class Chart
Set Worksheet.
Chart::setTitle() — Method in class Chart
Set Title.
Chart::setLegend() — Method in class Chart
Set Legend.
Chart::setXAxisLabel() — Method in class Chart
Set X-Axis Label.
Chart::setYAxisLabel() — Method in class Chart
Set Y-Axis Label.
Chart::setPlotVisibleOnly() — Method in class Chart
Set Plot Visible Only.
Chart::setDisplayBlanksAs() — Method in class Chart
Set Display Blanks as.
Chart::setTopLeftPosition() — Method in class Chart
Set the Top Left position for the chart.
Chart::setTopLeftCell() — Method in class Chart
Set the Top Left cell position for the chart.
Chart::setTopLeftOffset() — Method in class Chart
Set the offset position within the Top Left cell for the chart.
Chart::setTopLeftXOffset() — Method in class Chart
Chart::setTopLeftYOffset() — Method in class Chart
Chart::setBottomRightPosition() — Method in class Chart
Set the Bottom Right position of the chart.
Chart::setBottomRightCell() — Method in class Chart
Chart::setBottomRightOffset() — Method in class Chart
Set the offset position within the Bottom Right cell for the chart.
Chart::setBottomRightXOffset() — Method in class Chart
Chart::setBottomRightYOffset() — Method in class Chart
DataSeries::setPlotType() — Method in class DataSeries
Set Plot Type.
DataSeries::setPlotGrouping() — Method in class DataSeries
Set Plot Grouping Type.
DataSeries::setPlotDirection() — Method in class DataSeries
Set Plot Direction.
DataSeries::setPlotStyle() — Method in class DataSeries
Set Plot Style.
DataSeries::setSmoothLine() — Method in class DataSeries
Set Smooth Line.
DataSeriesValues::setDataType() — Method in class DataSeriesValues
Set Series Data Type.
DataSeriesValues::setDataSource() — Method in class DataSeriesValues
Set Series Data Source (formula).
DataSeriesValues::setPointMarker() — Method in class DataSeriesValues
Set Point Marker.
DataSeriesValues::setFormatCode() — Method in class DataSeriesValues
Set Series Format Code.
DataSeriesValues::setFillColor() — Method in class DataSeriesValues
Set fill color for series.
DataSeriesValues::setLineWidth() — Method in class DataSeriesValues
Set line width for the series.
DataSeriesValues::setDataValues() — Method in class DataSeriesValues
Set Series Data Values.
GridLines::setLineColorProperties() — Method in class GridLines
Set Line Color Properties.
GridLines::setLineStyleProperties() — Method in class GridLines
Set Line Color Properties.
GridLines::setGlowProperties() — Method in class GridLines
Set Glow Properties.
GridLines::setShadowProperties() — Method in class GridLines
Set Shadow Properties.
GridLines::setSoftEdgesSize() — Method in class GridLines
Set Soft Edges Size.
Layout::setLayoutTarget() — Method in class Layout
Set Layout Target.
Layout::setXMode() — Method in class Layout
Set X-Mode.
Layout::setYMode() — Method in class Layout
Set Y-Mode.
Layout::setXPosition() — Method in class Layout
Set X-Position.
Layout::setYPosition() — Method in class Layout
Set Y-Position.
Layout::setWidth() — Method in class Layout
Set Width.
Layout::setHeight() — Method in class Layout
Set Height.
Layout::setShowLegendKey() — Method in class Layout
Set show legend key Specifies that legend keys should be shown in data labels.
Layout::setShowVal() — Method in class Layout
Set show val Specifies that the value should be shown in data labels.
Layout::setShowCatName() — Method in class Layout
Set show cat name Specifies that the category name should be shown in data labels.
Layout::setShowSerName() — Method in class Layout
Set show ser name Specifies that the series name should be shown in data labels.
Layout::setShowPercent() — Method in class Layout
Set show percentage Specifies that the percentage should be shown in data labels.
Layout::setShowBubbleSize() — Method in class Layout
Set show bubble size Specifies that the bubble size should be shown in data labels.
Layout::setShowLeaderLines() — Method in class Layout
Set show leader lines Specifies that leader lines should be shown in data labels.
Legend::setPosition() — Method in class Legend
Get legend position using an excel string value.
Legend::setPositionXL() — Method in class Legend
Set legend position using an Excel internal numeric value.
Legend::setOverlay() — Method in class Legend
Set allow overlay of other elements?
PlotArea::setPlotSeries() — Method in class PlotArea
Set Plot Series.
Properties::setColorProperties() — Method in class Properties
Title::setCaption() — Method in class Title
Set caption.
Memory::set() — Method in class Memory
Memory::setMultiple() — Method in class Memory
Comment::setAuthor() — Method in class Comment
Set Author.
Comment::setText() — Method in class Comment
Set Rich text comment.
Comment::setWidth() — Method in class Comment
Set comment width (CSS style, i.e. XXpx or YYpt).
Comment::setHeight() — Method in class Comment
Set comment height (CSS style, i.e. XXpx or YYpt).
Comment::setMarginLeft() — Method in class Comment
Set left margin (CSS style, i.e. XXpx or YYpt).
Comment::setMarginTop() — Method in class Comment
Set top margin (CSS style, i.e. XXpx or YYpt).
Comment::setVisible() — Method in class Comment
Set comment default visibility.
Comment::setAlignment() — Method in class Comment
Set Alignment.
Properties::setCreator() — Method in class Properties
Set Creator.
Properties::setLastModifiedBy() — Method in class Properties
Set Last Modified By.
Properties::setCreated() — Method in class Properties
Set Created.
Properties::setModified() — Method in class Properties
Set Modified.
Properties::setTitle() — Method in class Properties
Set Title.
Properties::setDescription() — Method in class Properties
Set Description.
Properties::setSubject() — Method in class Properties
Set Subject.
Properties::setKeywords() — Method in class Properties
Set Keywords.
Properties::setCategory() — Method in class Properties
Set Category.
Properties::setCompany() — Method in class Properties
Set Company.
Properties::setManager() — Method in class Properties
Set Manager.
Properties::setCustomProperty() — Method in class Properties
Set a Custom Property.
SecurityClass in namespace PhpOffice\PhpSpreadsheet\Document
Security::setLockRevision() — Method in class Security
Set LockRevision.
Security::setLockStructure() — Method in class Security
Set LockStructure.
Security::setLockWindows() — Method in class Security
Set LockWindows.
Security::setRevisionsPassword() — Method in class Security
Set RevisionsPassword.
Security::setWorkbookPassword() — Method in class Security
Set WorkbookPassword.
$Html#sizeProperty in class Html
$Html#superscriptProperty in class Html
$Html#subscriptProperty in class Html
$Html#strikethroughProperty in class Html
$Html#startTagCallbacksProperty in class Html
$Html#stackProperty in class Html
$Html#stringDataProperty in class Html
Html::startFontTag() — Method in class Html
Html::startBoldTag() — Method in class Html
Html::startItalicTag() — Method in class Html
Html::startUnderlineTag() — Method in class Html
Html::startSubscriptTag() — Method in class Html
Html::startSuperscriptTag() — Method in class Html
Html::startStrikethruTag() — Method in class Html
SampleClass in namespace PhpOffice\PhpSpreadsheet\Helper
Helper class to be used in sample code.
NamedRange::setName() — Method in class NamedRange
Set name.
NamedRange::setWorksheet() — Method in class NamedRange
Set worksheet.
NamedRange::setRange() — Method in class NamedRange
Set range.
NamedRange::setLocalOnly() — Method in class NamedRange
Set localOnly.
NamedRange::setScope() — Method in class NamedRange
Set scope.
$BaseReader#securityScannerProperty in class BaseReader
BaseReader::setReadDataOnly() — Method in class BaseReader
Set read data only Set to true, to advise the Reader only to read data values for cells, and to ignore any formatting information.
BaseReader::setReadEmptyCells() — Method in class BaseReader
Set read empty cells Set to true (the default) to advise the Reader read data values for all cells, irrespective of value.
BaseReader::setIncludeCharts() — Method in class BaseReader
Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook.
BaseReader::setLoadSheetsOnly() — Method in class BaseReader
Set which sheets to load.
BaseReader::setLoadAllSheets() — Method in class BaseReader
Set all sheets to load Tells the Reader to load all worksheets from the workbook.
BaseReader::setReadFilter() — Method in class BaseReader
Set read filter.
Csv::setInputEncoding() — Method in class Csv
Set input encoding.
Csv::skipBOM() — Method in class Csv
Move filepointer past any BOM marker.
Csv::setDelimiter() — Method in class Csv
Set delimiter.
Csv::setEnclosure() — Method in class Csv
Set enclosure.
Csv::setSheetIndex() — Method in class Csv
Set sheet index.
Csv::setContiguous() — Method in class Csv
Set Contiguous.
Csv::setEscapeCharacter() — Method in class Csv
Set escape backslashes.
$Html#sheetIndexProperty in class Html
Sheet index to read.
Html::setInputEncoding() — Method in class Html
Set input encoding.
Html::setTableStartColumn() — Method in class Html
Html::setSheetIndex() — Method in class Html
Set sheet index.
Ods::scanElementForText() — Method in class Ods
Recursively scan element.
XmlScanner::setAdditionalCallback() — Method in class XmlScanner
XmlScanner::scan() — Method in class XmlScanner
Scan the XML for use of <!ENTITY to prevent XXE/XEE attacks.
XmlScanner::scanFile() — Method in class XmlScanner
Scan theXML for use of <!ENTITY to prevent XXE/XEE attacks.
SlkClass in namespace PhpOffice\PhpSpreadsheet\Reader
Slk::setInputEncoding() — Method in class Slk
Set input encoding.
Slk::setSheetIndex() — Method in class Slk
Set sheet index.
$RC4#sProperty in class RC4
$Xml#stylesProperty in class Xml
Formats.
ITextElement::setText() — Method in class ITextElement
Set text.
RichText::setRichTextElements() — Method in class RichText
Set Rich Text elements.
Run::setFont() — Method in class Run
Set font.
TextElement::setText() — Method in class TextElement
Set text.
SettingsClass in namespace PhpOffice\PhpSpreadsheet
Settings::setLocale() — Method in class Settings
Set the locale code to use for formula translations and any special formatting.
Settings::setChartRenderer() — Method in class Settings
Identify to PhpSpreadsheet the external library to use for rendering charts.
Settings::setLibXmlLoaderOptions() — Method in class Settings
Set default options for libxml loader.
Settings::setCache() — Method in class Settings
Sets the implementation of cache that should be used for cell collection.
Date::setExcelCalendar() — Method in class Date
Set the Excel calendar (Windows 1900 or Mac 1904).
Date::setDefaultTimezone() — Method in class Date
Set the Default timezone to use for dates.
Date::stringToExcel() — Method in class Date
Convert a date/time string to Excel time.
Escher::setDggContainer() — Method in class Escher
Set Drawing Group Container.
Escher::setDgContainer() — Method in class Escher
Set Drawing Container.
DgContainer::setDgId() — Method in class DgContainer
DgContainer::setLastSpId() — Method in class DgContainer
DgContainer::setSpgrContainer() — Method in class DgContainer
SpgrContainerClass in namespace PhpOffice\PhpSpreadsheet\Shared\Escher\DgContainer
SpgrContainer::setParent() — Method in class SpgrContainer
Set parent Shape Group Container.
SpContainerClass in namespace PhpOffice\PhpSpreadsheet\Shared\Escher\DgContainer\SpgrContainer
SpContainer::setParent() — Method in class SpContainer
Set parent Shape Group Container.
SpContainer::setSpgr() — Method in class SpContainer
Set whether this is a group shape.
SpContainer::setSpType() — Method in class SpContainer
Set the shape type.
SpContainer::setSpFlag() — Method in class SpContainer
Set the shape flag.
SpContainer::setSpId() — Method in class SpContainer
Set the shape index.
SpContainer::setOPT() — Method in class SpContainer
Set an option for the Shape Group Container.
SpContainer::setStartCoordinates() — Method in class SpContainer
Set cell coordinates of upper-left corner of shape.
SpContainer::setStartOffsetX() — Method in class SpContainer
Set offset in x-direction of upper-left corner of shape measured in 1/1024 of column width.
SpContainer::setStartOffsetY() — Method in class SpContainer
Set offset in y-direction of upper-left corner of shape measured in 1/256 of row height.
SpContainer::setEndCoordinates() — Method in class SpContainer
Set cell coordinates of bottom-right corner of shape.
SpContainer::setEndOffsetX() — Method in class SpContainer
Set offset in x-direction of bottom-right corner of shape measured in 1/1024 of column width.
SpContainer::setEndOffsetY() — Method in class SpContainer
Set offset in y-direction of bottom-right corner of shape measured in 1/256 of row height.
DggContainer::setSpIdMax() — Method in class DggContainer
Set maximum shape index of all shapes in all drawings (plus one).
DggContainer::setCDgSaved() — Method in class DggContainer
Set total number of drawings saved.
DggContainer::setCSpSaved() — Method in class DggContainer
Set total number of shapes saved (including group shapes).
DggContainer::setBstoreContainer() — Method in class DggContainer
Set BLIP Store Container.
DggContainer::setOPT() — Method in class DggContainer
Set an option for the drawing group.
DggContainer::setIDCLs() — Method in class DggContainer
Set identifier clusters. [ => , .
BSE::setParent() — Method in class BSE
Set parent BLIP Store Entry Container.
BSE::setBlip() — Method in class BSE
Set the BLIP.
BSE::setBlipType() — Method in class BSE
Set the BLIP type.
Blip::setData() — Method in class Blip
Set the raw image data.
Blip::setParent() — Method in class Blip
Set parent BSE.
File::setUseUploadTempDirectory() — Method in class File
Set the flag indicating whether the File Upload Temp directory should be used for temporary files.
File::sysGetTempDir() — Method in class File
Get the systems temporary directory.
Font::setAutoSizeMethod() — Method in class Font
Set autoSize method.
Font::setTrueTypeFontPath() — Method in class Font
Set the path to the folder containing .ttf files. There should be a trailing slash.
CholeskyDecomposition::solve() — Method in class CholeskyDecomposition
Solve A*X = B.
LUDecomposition::solve() — Method in class LUDecomposition
Solve A*X = B.
Matrix::set() — Method in class Matrix
set.
Matrix::solve() — Method in class Matrix
Solve A*X = B.
QRDecomposition::solve() — Method in class QRDecomposition
Least squares solution of A*X = B.
SingularValueDecompositionClass in namespace PhpOffice\PhpSpreadsheet\Shared\JAMA
For an m-by-n matrix A with m >= n, the singular value decomposition is an m-by-n orthogonal matrix U, an n-by-n diagonal matrix S, and an n-by-n orthogonal matrix V so that A = USV'.
$OLE#sbatProperty in class OLE
Short Block Allocation Table.
$OLE#smallBlockSizeProperty in class OLE
Size of small blocks. This is usually 64.
$OLERead#summaryInformationProperty in class OLERead
ChainedBlockStream::stream_open() — Method in class ChainedBlockStream
Implements support for fopen().
ChainedBlockStream::stream_close() — Method in class ChainedBlockStream
Implements support for fclose().
ChainedBlockStream::stream_read() — Method in class ChainedBlockStream
Implements support for fread(), fgets() etc.
ChainedBlockStream::stream_eof() — Method in class ChainedBlockStream
Implements support for feof().
ChainedBlockStream::stream_tell() — Method in class ChainedBlockStream
Returns the position of the file pointer, i.e. its offset into the file stream. Implements support for ftell().
ChainedBlockStream::stream_seek() — Method in class ChainedBlockStream
Implements support for fseek().
ChainedBlockStream::stream_stat() — Method in class ChainedBlockStream
Implements support for fstat(). Currently the only supported field is "size".
$PPS#startBlockProperty in class PPS
Starting block (small or big) for this PPS's data inside the container.
$PPS#SizeProperty in class PPS
The size of the PPS's data (in bytes).
Root::save() — Method in class Root
Method for saving the whole OLE container (including files).
StringHelperClass in namespace PhpOffice\PhpSpreadsheet\Shared
StringHelper::sanitizeUTF8() — Method in class StringHelper
Try to sanitize UTF8, stripping invalid byte sequences. Not perfect. Does not surrogate characters.
StringHelper::substring() — Method in class StringHelper
Get a substring of a UTF-8 encoded string.
StringHelper::strToUpper() — Method in class StringHelper
Convert a UTF-8 encoded string to upper case.
StringHelper::strToLower() — Method in class StringHelper
Convert a UTF-8 encoded string to lower case.
StringHelper::strToTitle() — Method in class StringHelper
Convert a UTF-8 encoded string to title/proper case (uppercase every first character in each word, lower case all other characters).
StringHelper::strCaseReverse() — Method in class StringHelper
Reverse the case of a string, so that all uppercase characters become lowercase and all lowercase characters become uppercase.
StringHelper::setDecimalSeparator() — Method in class StringHelper
Set the decimal separator. Only used by NumberFormat::toFormattedString() to format output by \PhpOffice\PhpSpreadsheet\Writer\Html and \PhpOffice\PhpSpreadsheet\Writer\Pdf.
StringHelper::setThousandsSeparator() — Method in class StringHelper
Set the thousands separator. Only used by NumberFormat::toFormattedString() to format output by \PhpOffice\PhpSpreadsheet\Writer\Html and \PhpOffice\PhpSpreadsheet\Writer\Pdf.
StringHelper::setCurrencyCode() — Method in class StringHelper
Set the currency code. Only used by NumberFormat::toFormattedString() to format output by \PhpOffice\PhpSpreadsheet\Writer\Html and \PhpOffice\PhpSpreadsheet\Writer\Pdf.
StringHelper::SYLKtoUTF8() — Method in class StringHelper
Convert SYLK encoded string to UTF-8.
TimeZone::setTimeZone() — Method in class TimeZone
Set the Default Timezone used for date/time conversions.
$BestFit#stdevOfResidualsProperty in class BestFit
$BestFit#SSRegressionProperty in class BestFit
$BestFit#SSResidualsProperty in class BestFit
$BestFit#slopeProperty in class BestFit
$BestFit#slopeSEProperty in class BestFit
Xls::sizeCol() — Method in class Xls
Get the width of a column in pixels. We use the relationship y = ceil(7x) where x is the width in intrinsic Excel units (measuring width in number of normal characters) This holds for Arial 10.
Xls::sizeRow() — Method in class Xls
Convert the height of a cell from user's units to pixels. By interpolation the relationship is: y = 4/3x. If the height hasn't been set by the user we use the default value. If the row is hidden we use a value of zero.
SpreadsheetClass in namespace PhpOffice\PhpSpreadsheet
Spreadsheet::setHasMacros() — Method in class Spreadsheet
Define if a workbook has macros.
Spreadsheet::setMacrosCode() — Method in class Spreadsheet
Set the macros code.
Spreadsheet::setMacrosCertificate() — Method in class Spreadsheet
Set the macros certificate.
Spreadsheet::setRibbonXMLData() — Method in class Spreadsheet
set ribbon XML data.
Spreadsheet::setRibbonBinObjects() — Method in class Spreadsheet
store binaries ribbon objects (pictures).
Spreadsheet::setUnparsedLoadedData() — Method in class Spreadsheet
List of unparsed loaded data for export to same format with better compatibility.
Spreadsheet::sheetCodeNameExists() — Method in class Spreadsheet
Check if a sheet with a specified code name already exists.
Spreadsheet::setProperties() — Method in class Spreadsheet
Set properties.
Spreadsheet::setSecurity() — Method in class Spreadsheet
Set security.
Spreadsheet::sheetNameExists() — Method in class Spreadsheet
Check if a sheet with a specified name already exists.
Spreadsheet::setIndexByName() — Method in class Spreadsheet
Set index for sheet by sheet name.
Spreadsheet::setActiveSheetIndex() — Method in class Spreadsheet
Set active sheet index.
Spreadsheet::setActiveSheetIndexByName() — Method in class Spreadsheet
Set active sheet index by name.
Spreadsheet::setShowHorizontalScroll() — Method in class Spreadsheet
Set the visibility of the horizonal scroll bar in the application.
Spreadsheet::setShowVerticalScroll() — Method in class Spreadsheet
Set the visibility of the vertical scroll bar in the application.
Spreadsheet::setShowSheetTabs() — Method in class Spreadsheet
Set the visibility of the sheet tabs in the application.
Spreadsheet::setMinimized() — Method in class Spreadsheet
Set whether the workbook window is minimized.
Spreadsheet::setAutoFilterDateGrouping() — Method in class Spreadsheet
Set whether to group dates when presenting the user with filtering optiomd in the user interface.
Spreadsheet::setFirstSheetIndex() — Method in class Spreadsheet
Set the first sheet in the book view.
Spreadsheet::setVisibility() — Method in class Spreadsheet
Set the visibility status of the workbook.
Spreadsheet::setTabRatio() — Method in class Spreadsheet
Set the ratio between the workbook tabs bar and the horizontal scroll bar TabRatio is assumed to be out of 1000 of the horizontal window width.
$Alignment#shrinkToFitProperty in class Alignment
Shrink to fit.
Alignment::setHorizontal() — Method in class Alignment
Set Horizontal.
Alignment::setVertical() — Method in class Alignment
Set Vertical.
Alignment::setTextRotation() — Method in class Alignment
Set TextRotation.
Alignment::setWrapText() — Method in class Alignment
Set Wrap Text.
Alignment::setShrinkToFit() — Method in class Alignment
Set Shrink to fit.
Alignment::setIndent() — Method in class Alignment
Set indent.
Alignment::setReadOrder() — Method in class Alignment
Set read order.
Border::setBorderStyle() — Method in class Border
Set Border style.
Border::setColor() — Method in class Border
Set Border Color.
Borders::setDiagonalDirection() — Method in class Borders
Set DiagonalDirection.
Color::setARGB() — Method in class Color
Set ARGB.
Color::setRGB() — Method in class Color
Set RGB.
Conditional::setConditionType() — Method in class Conditional
Set Condition type.
Conditional::setOperatorType() — Method in class Conditional
Set Operator type.
Conditional::setText() — Method in class Conditional
Set text.
Conditional::setStopIfTrue() — Method in class Conditional
Set StopIfTrue.
Conditional::setConditions() — Method in class Conditional
Set Conditions.
Conditional::setStyle() — Method in class Conditional
Set Style.
$Fill#startcolorIndexProperty in class Fill
$Fill#startColorProperty in class Fill
Start color.
Fill::setFillType() — Method in class Fill
Set Fill Type.
Fill::setRotation() — Method in class Fill
Set Rotation.
Fill::setStartColor() — Method in class Fill
Set Start Color.
Fill::setEndColor() — Method in class Fill
Set End Color.
$Font#sizeProperty in class Font
Font Size.
$Font#superscriptProperty in class Font
Superscript.
$Font#subscriptProperty in class Font
Subscript.
$Font#strikethroughProperty in class Font
Strikethrough.
Font::setName() — Method in class Font
Set Name.
Font::setSize() — Method in class Font
Set Size.
Font::setBold() — Method in class Font
Set Bold.
Font::setItalic() — Method in class Font
Set Italic.
Font::setSuperscript() — Method in class Font
Set Superscript.
Font::setSubscript() — Method in class Font
Set Subscript.
Font::setUnderline() — Method in class Font
Set Underline.
Font::setStrikethrough() — Method in class Font
Set Strikethrough.
Font::setColor() — Method in class Font
Set Color.
NumberFormat::setFormatCode() — Method in class NumberFormat
Set Format Code.
NumberFormat::setBuiltInFormatCode() — Method in class NumberFormat
Set Built-In Format Code.
Protection::setLocked() — Method in class Protection
Set locked.
Protection::setHidden() — Method in class Protection
Set hidden.
StyleClass in namespace PhpOffice\PhpSpreadsheet\Style
Style::setFont() — Method in class Style
Set font.
Style::setConditionalStyles() — Method in class Style
Set Conditional Styles. Only used on supervisor.
Style::setQuotePrefix() — Method in class Style
Set quote prefix.
Style::setIndex() — Method in class Style
Set own index in style collection.
SupervisorClass in namespace PhpOffice\PhpSpreadsheet\Style
AutoFilter::setParent() — Method in class AutoFilter
Set AutoFilter Parent Worksheet.
AutoFilter::setRange() — Method in class AutoFilter
Set AutoFilter Range.
AutoFilter::setColumn() — Method in class AutoFilter
Set AutoFilter.
AutoFilter::shiftColumn() — Method in class AutoFilter
Shift an AutoFilter Column Rule to a different column.
AutoFilter::showHideRows() — Method in class AutoFilter
Apply the AutoFilter rules to the AutoFilter Range.
Column::setColumnIndex() — Method in class Column
Set AutoFilter Column Index.
Column::setParent() — Method in class Column
Set this Column's AutoFilter Parent.
Column::setFilterType() — Method in class Column
Set AutoFilter Type.
Column::setJoin() — Method in class Column
Set AutoFilter Multiple Rules And/Or.
Column::setAttributes() — Method in class Column
Set AutoFilter Attributes.
Column::setAttribute() — Method in class Column
Set An AutoFilter Attribute.
Rule::setRuleType() — Method in class Rule
Set AutoFilter Rule Type.
Rule::setValue() — Method in class Rule
Set AutoFilter Rule Value.
Rule::setOperator() — Method in class Rule
Set AutoFilter Rule Operator.
Rule::setGrouping() — Method in class Rule
Set AutoFilter Rule Grouping.
Rule::setRule() — Method in class Rule
Set AutoFilter Rule.
Rule::setParent() — Method in class Rule
Set this Rule's AutoFilter Column Parent.
$BaseDrawing#shadowProperty in class BaseDrawing
Shadow.
BaseDrawing::setName() — Method in class BaseDrawing
Set Name.
BaseDrawing::setDescription() — Method in class BaseDrawing
Set Description.
BaseDrawing::setWorksheet() — Method in class BaseDrawing
Set Worksheet.
BaseDrawing::setCoordinates() — Method in class BaseDrawing
Set Coordinates.
BaseDrawing::setOffsetX() — Method in class BaseDrawing
Set OffsetX.
BaseDrawing::setOffsetY() — Method in class BaseDrawing
Set OffsetY.
BaseDrawing::setWidth() — Method in class BaseDrawing
Set Width.
BaseDrawing::setHeight() — Method in class BaseDrawing
Set Height.
BaseDrawing::setWidthAndHeight() — Method in class BaseDrawing
Set width and height with proportional resize.
BaseDrawing::setResizeProportional() — Method in class BaseDrawing
Set ResizeProportional.
BaseDrawing::setRotation() — Method in class BaseDrawing
Set Rotation.
BaseDrawing::setShadow() — Method in class BaseDrawing
Set Shadow.
BaseDrawing::setHyperlink() — Method in class BaseDrawing
CellIterator::setIterateOnlyExistingCells() — Method in class CellIterator
Set the iterator to loop only existing cells.
ColumnCellIterator::seek() — Method in class ColumnCellIterator
Set the row pointer to the selected row.
ColumnDimension::setColumnIndex() — Method in class ColumnDimension
Set ColumnIndex.
ColumnDimension::setWidth() — Method in class ColumnDimension
Set Width.
ColumnDimension::setAutoSize() — Method in class ColumnDimension
Set Auto Size.
ColumnIterator::seek() — Method in class ColumnIterator
Set the column pointer to the selected column.
Dimension::setVisible() — Method in class Dimension
Set Visible.
Dimension::setOutlineLevel() — Method in class Dimension
Set Outline Level.
Dimension::setCollapsed() — Method in class Dimension
Set Collapsed.
Dimension::setXfIndex() — Method in class Dimension
Set index to cellXf.
Drawing::setPath() — Method in class Drawing
Set Path.
ShadowClass in namespace PhpOffice\PhpSpreadsheet\Worksheet\Drawing
Shadow::setVisible() — Method in class Shadow
Set Visible.
Shadow::setBlurRadius() — Method in class Shadow
Set Blur radius.
Shadow::setDistance() — Method in class Shadow
Set Shadow distance.
Shadow::setDirection() — Method in class Shadow
Set Shadow direction (in degrees).
Shadow::setAlignment() — Method in class Shadow
Set Shadow alignment.
Shadow::setColor() — Method in class Shadow
Set Color.
Shadow::setAlpha() — Method in class Shadow
Set Alpha.
HeaderFooter::setOddHeader() — Method in class HeaderFooter
Set OddHeader.
HeaderFooter::setOddFooter() — Method in class HeaderFooter
Set OddFooter.
HeaderFooter::setEvenHeader() — Method in class HeaderFooter
Set EvenHeader.
HeaderFooter::setEvenFooter() — Method in class HeaderFooter
Set EvenFooter.
HeaderFooter::setFirstHeader() — Method in class HeaderFooter
Set FirstHeader.
HeaderFooter::setFirstFooter() — Method in class HeaderFooter
Set FirstFooter.
HeaderFooter::setDifferentOddEven() — Method in class HeaderFooter
Set DifferentOddEven.
HeaderFooter::setDifferentFirst() — Method in class HeaderFooter
Set DifferentFirst.
HeaderFooter::setScaleWithDocument() — Method in class HeaderFooter
Set ScaleWithDocument.
HeaderFooter::setAlignWithMargins() — Method in class HeaderFooter
Set AlignWithMargins.
HeaderFooter::setImages() — Method in class HeaderFooter
Set header/footer images.
MemoryDrawing::setImageResource() — Method in class MemoryDrawing
Set image resource.
MemoryDrawing::setRenderingFunction() — Method in class MemoryDrawing
Set rendering function.
MemoryDrawing::setMimeType() — Method in class MemoryDrawing
Set mime type.
PageMargins::setLeft() — Method in class PageMargins
Set Left.
PageMargins::setRight() — Method in class PageMargins
Set Right.
PageMargins::setTop() — Method in class PageMargins
Set Top.
PageMargins::setBottom() — Method in class PageMargins
Set Bottom.
PageMargins::setHeader() — Method in class PageMargins
Set Header.
PageMargins::setFooter() — Method in class PageMargins
Set Footer.
PageSetup::setPaperSize() — Method in class PageSetup
Set Paper Size.
PageSetup::setOrientation() — Method in class PageSetup
Set Orientation.
PageSetup::setScale() — Method in class PageSetup
Set Scale.
PageSetup::setFitToPage() — Method in class PageSetup
Set Fit To Page.
PageSetup::setFitToHeight() — Method in class PageSetup
Set Fit To Height.
PageSetup::setFitToWidth() — Method in class PageSetup
Set Fit To Width.
PageSetup::setColumnsToRepeatAtLeft() — Method in class PageSetup
Set Columns to repeat at left.
PageSetup::setColumnsToRepeatAtLeftByStartAndEnd() — Method in class PageSetup
Set Columns to repeat at left by start and end.
PageSetup::setRowsToRepeatAtTop() — Method in class PageSetup
Set Rows to repeat at top.
PageSetup::setRowsToRepeatAtTopByStartAndEnd() — Method in class PageSetup
Set Rows to repeat at top by start and end.
PageSetup::setHorizontalCentered() — Method in class PageSetup
Set center page horizontally.
PageSetup::setVerticalCentered() — Method in class PageSetup
Set center page vertically.
PageSetup::setPrintArea() — Method in class PageSetup
Set print area. e.g. 'A1:D10' or 'A1:D10,G5:M20'.
PageSetup::setPrintAreaByColumnAndRow() — Method in class PageSetup
Set print area.
PageSetup::setFirstPageNumber() — Method in class PageSetup
Set first page number.
Protection::setSheet() — Method in class Protection
Set Sheet.
Protection::setObjects() — Method in class Protection
Set Objects.
Protection::setScenarios() — Method in class Protection
Set Scenarios.
Protection::setFormatCells() — Method in class Protection
Set FormatCells.
Protection::setFormatColumns() — Method in class Protection
Set FormatColumns.
Protection::setFormatRows() — Method in class Protection
Set FormatRows.
Protection::setInsertColumns() — Method in class Protection
Set InsertColumns.
Protection::setInsertRows() — Method in class Protection
Set InsertRows.
Protection::setInsertHyperlinks() — Method in class Protection
Set InsertHyperlinks.
Protection::setDeleteColumns() — Method in class Protection
Set DeleteColumns.
Protection::setDeleteRows() — Method in class Protection
Set DeleteRows.
Protection::setSelectLockedCells() — Method in class Protection
Set SelectLockedCells.
Protection::setSort() — Method in class Protection
Set Sort.
Protection::setAutoFilter() — Method in class Protection
Set AutoFilter.
Protection::setPivotTables() — Method in class Protection
Set PivotTables.
Protection::setSelectUnlockedCells() — Method in class Protection
Set SelectUnlockedCells.
Protection::setPassword() — Method in class Protection
Set Password.
RowCellIterator::seek() — Method in class RowCellIterator
Set the column pointer to the selected column.
RowDimension::setRowIndex() — Method in class RowDimension
Set Row Index.
RowDimension::setRowHeight() — Method in class RowDimension
Set Row Height.
RowDimension::setZeroHeight() — Method in class RowDimension
Set ZeroHeight.
RowIterator::seek() — Method in class RowIterator
Set the row pointer to the selected row.
SheetViewClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
SheetView::setZoomScale() — Method in class SheetView
Set ZoomScale.
SheetView::setZoomScaleNormal() — Method in class SheetView
Set ZoomScale.
SheetView::setView() — Method in class SheetView
Set View.
Worksheet::setTitle() — Method in class Worksheet
Set title.
Worksheet::setSheetState() — Method in class Worksheet
Set sheet state.
Worksheet::setPageSetup() — Method in class Worksheet
Set page setup.
Worksheet::setPageMargins() — Method in class Worksheet
Set page margins.
Worksheet::setHeaderFooter() — Method in class Worksheet
Set page header/footer.
Worksheet::setSheetView() — Method in class Worksheet
Set sheet view.
Worksheet::setProtection() — Method in class Worksheet
Set Protection.
Worksheet::setCellValue() — Method in class Worksheet
Set a cell value.
Worksheet::setCellValueByColumnAndRow() — Method in class Worksheet
Set a cell value by using numeric cell coordinates.
Worksheet::setCellValueExplicit() — Method in class Worksheet
Set a cell value.
Worksheet::setCellValueExplicitByColumnAndRow() — Method in class Worksheet
Set a cell value by using numeric cell coordinates.
Worksheet::setConditionalStyles() — Method in class Worksheet
Set conditional styles.
Worksheet::setBreak() — Method in class Worksheet
Set break on a cell.
Worksheet::setBreakByColumnAndRow() — Method in class Worksheet
Set break on a cell by using numeric cell coordinates.
Worksheet::setMergeCells() — Method in class Worksheet
Set merge cells array for the entire sheet. Use instead mergeCells() to merge a single cell range.
Worksheet::setAutoFilter() — Method in class Worksheet
Set AutoFilter.
Worksheet::setAutoFilterByColumnAndRow() — Method in class Worksheet
Set Autofilter Range by using numeric cell coordinates.
Worksheet::setShowGridlines() — Method in class Worksheet
Set show gridlines.
Worksheet::setPrintGridlines() — Method in class Worksheet
Set print gridlines.
Worksheet::setShowRowColHeaders() — Method in class Worksheet
Set show row and column headers.
Worksheet::setShowSummaryBelow() — Method in class Worksheet
Set show summary below.
Worksheet::setShowSummaryRight() — Method in class Worksheet
Set show summary right.
Worksheet::setComments() — Method in class Worksheet
Set comments array for the entire sheet.
Worksheet::setSelectedCell() — Method in class Worksheet
Selected cell.
Worksheet::setSelectedCells() — Method in class Worksheet
Select a range of cells.
Worksheet::setSelectedCellByColumnAndRow() — Method in class Worksheet
Selected cell by using numeric cell coordinates.
Worksheet::setRightToLeft() — Method in class Worksheet
Set right-to-left.
Worksheet::setHyperlink() — Method in class Worksheet
Set hyperlink.
Worksheet::setDataValidation() — Method in class Worksheet
Set data validation.
Worksheet::shrinkRangeToFit() — Method in class Worksheet
Accepts a range, returning it as a range that falls within the current highest row and column of the worksheet.
Worksheet::setCodeName() — Method in class Worksheet
Define the code name of the sheet.
BaseWriter::setIncludeCharts() — Method in class BaseWriter
Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object.
BaseWriter::setPreCalculateFormulas() — Method in class BaseWriter
Set Pre-Calculate Formulas Set to true (the default) to advise the Writer to calculate all formulae on save Set to false to prevent precalculation of formulae on save.
BaseWriter::setUseDiskCaching() — Method in class BaseWriter
Set use disk caching where possible?
Csv::save() — Method in class Csv
Save PhpSpreadsheet to file.
Csv::setDelimiter() — Method in class Csv
Set delimiter.
Csv::setEnclosure() — Method in class Csv
Set enclosure.
Csv::setLineEnding() — Method in class Csv
Set line ending.
Csv::setUseBOM() — Method in class Csv
Set whether BOM should be used.
Csv::setIncludeSeparatorLine() — Method in class Csv
Set whether a separator line should be included as the first line of the file.
Csv::setExcelCompatibility() — Method in class Csv
Set whether the file should be saved with full Excel Compatibility.
Csv::setSheetIndex() — Method in class Csv
Set sheet index.
$Html#spreadsheetProperty in class Html
Spreadsheet object.
Html::save() — Method in class Html
Save Spreadsheet to file.
Html::setSheetIndex() — Method in class Html
Set sheet index.
Html::setGenerateSheetNavigationBlock() — Method in class Html
Set sheet index.
Html::setImagesRoot() — Method in class Html
Set images root.
Html::setEmbedImages() — Method in class Html
Set embed images.
Html::setUseInlineCss() — Method in class Html
Set use inline CSS?
IWriter::save() — Method in class IWriter
Save PhpSpreadsheet to file.
Ods::save() — Method in class Ods
Save PhpSpreadsheet to file.
Ods::setSpreadsheet() — Method in class Ods
Set Spreadsheet object.
SettingsClass in namespace PhpOffice\PhpSpreadsheet\Writer\Ods
StylesClass in namespace PhpOffice\PhpSpreadsheet\Writer\Ods
Pdf::setFont() — Method in class Pdf
Set font. Examples: 'arialunicid0-chinese-simplified' 'arialunicid0-chinese-traditional' 'arialunicid0-korean' 'arialunicid0-japanese'.
Pdf::setPaperSize() — Method in class Pdf
Set Paper Size.
Pdf::setOrientation() — Method in class Pdf
Set Orientation.
Pdf::setTempDir() — Method in class Pdf
Set temporary storage directory.
Dompdf::save() — Method in class Dompdf
Save Spreadsheet to file.
Mpdf::save() — Method in class Mpdf
Save Spreadsheet to file.
Tcpdf::save() — Method in class Tcpdf
Save Spreadsheet to file.
Xls::save() — Method in class Xls
Save Spreadsheet to file.
BIFFwriter::storeBof() — Method in class BIFFwriter
Writes Excel BOF record to indicate the beginning of a stream or sub-stream in the BIFF file.
BIFFwriter::storeEof() — Method in class BIFFwriter
Writes Excel EOF record to indicate the end of a BIFF stream.
Font::setColorIndex() — Method in class Font
Set the color index.
Parser::setExtSheet() — Method in class Parser
This method is used to update the array of sheet names. It is called by the addWorksheet() method of the \PhpOffice\PhpSpreadsheet\Writer\Xls\Workbook class.
Workbook::setEscher() — Method in class Workbook
Set Escher object.
Worksheet::setOutline() — Method in class Worksheet
This method sets the properties for outlining and grouping. The defaults correspond to Excel's defaults.
Worksheet::setEscher() — Method in class Worksheet
Set Escher object.
Xf::setIsStyleXf() — Method in class Xf
Is this a style XF ?
Xf::setBottomColor() — Method in class Xf
Sets the cell's bottom border color.
Xf::setTopColor() — Method in class Xf
Sets the cell's top border color.
Xf::setLeftColor() — Method in class Xf
Sets the cell's left border color.
Xf::setRightColor() — Method in class Xf
Sets the cell's right border color.
Xf::setDiagColor() — Method in class Xf
Sets the cell's diagonal border color.
Xf::setFgColor() — Method in class Xf
Sets the cell's foreground color.
Xf::setBgColor() — Method in class Xf
Sets the cell's background color.
Xf::setNumberFormatIndex() — Method in class Xf
Sets the index to the number format record It can be date, time, currency, etc.
Xf::setFontIndex() — Method in class Xf
Set the font index.
Xlsx::save() — Method in class Xlsx
Save PhpSpreadsheet to file.
Xlsx::setSpreadsheet() — Method in class Xlsx
Set Spreadsheet object.
Xlsx::setOffice2003Compatibility() — Method in class Xlsx
Set Office2003 compatibility.
StringTableClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx
StyleClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx

T

Calculation::translateSeparator() — Method in class Calculation
DateTime::TIME() — Method in class DateTime
TIME.
DateTime::TIMEVALUE() — Method in class DateTime
TIMEVALUE.
Financial::TBILLEQ() — Method in class Financial
TBILLEQ.
Financial::TBILLPRICE() — Method in class Financial
TBILLPRICE.
Financial::TBILLYIELD() — Method in class Financial
TBILLYIELD.
Functions::TYPE() — Method in class Functions
TYPE.
Logical::true() — Method in class Logical
TRUE.
LookupRef::TRANSPOSE() — Method in class LookupRef
TRANSPOSE.
MathTrig::TRUNC() — Method in class MathTrig
TRUNC.
Statistical::TDIST() — Method in class Statistical
TDIST.
Statistical::TINV() — Method in class Statistical
TINV.
Statistical::TREND() — Method in class Statistical
TREND.
Statistical::TRIMMEAN() — Method in class Statistical
TRIMMEAN.
TextDataClass in namespace PhpOffice\PhpSpreadsheet\Calculation
TextData::TRIMNONPRINTABLE() — Method in class TextData
TRIMNONPRINTABLE.
TextData::TRIMSPACES() — Method in class TextData
TRIMSPACES.
TextData::TEXTFORMAT() — Method in class TextData
TEXTFORMAT.
TextData::TEXTJOIN() — Method in class TextData
TEXTJOIN.
TitleClass in namespace PhpOffice\PhpSpreadsheet\Chart
HashTable::toArray() — Method in class HashTable
HashTable to array.
Html::toRichTextObject() — Method in class Html
Parse HTML formatting and return the resulting RichText.
$Html#tableLevelProperty in class Html
ThemeClass in namespace PhpOffice\PhpSpreadsheet\Reader\Xlsx
Xml::trySimpleXMLLoadString() — Method in class Xml
Check if the file is a valid SimpleXML.
TextElementClass in namespace PhpOffice\PhpSpreadsheet\RichText
Date::timestampToExcel() — Method in class Date
Convert a Unix timestamp to an MS Excel serialized date/time value.
Matrix::transpose() — Method in class Matrix
transpose.
Matrix::trace() — Method in class Matrix
trace.
Matrix::times() — Method in class Matrix
times.
$PPS#TypeProperty in class PPS
The PPS type. Dir, Root or File.
$PPS#Time1stProperty in class PPS
A timestamp.
$PPS#Time2ndProperty in class PPS
A timestamp.
$Root#tempDirectoryProperty in class Root
Directory for temporary files.
StringHelper::testStringAsNumeric() — Method in class StringHelper
Retrieve any leading numeric part of a string, or return the full string if no leading numeric (handles basic integer or float, but not exponent or non decimal).
TimeZoneClass in namespace PhpOffice\PhpSpreadsheet\Shared
$TimeZone#timezoneProperty in class TimeZone
Default Timezone used for date/time conversions.
TrendClass in namespace PhpOffice\PhpSpreadsheet\Shared\Trend
$Alignment#textRotationProperty in class Alignment
Text rotation.
$Borders#topProperty in class Borders
Top.
NumberFormat::toFormattedString() — Method in class NumberFormat
Convert a value in a pre-defined format to a PHP string.
AutoFilter::testColumnInRange() — Method in class AutoFilter
Validate that the specified column is in the AutoFilter range.
Worksheet::toArray() — Method in class Worksheet
Create array from worksheet.
ThumbnailsClass in namespace PhpOffice\PhpSpreadsheet\Writer\Ods
$Pdf#tempDirProperty in class Pdf
Temporary storage directory.
TcpdfClass in namespace PhpOffice\PhpSpreadsheet\Writer\Pdf
Parser::toReversePolish() — Method in class Parser
Builds a string containing the tree in reverse polish notation (What you would use in a HP calculator stack).
ThemeClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx

U

Calculation::unwrapResult() — Method in class Calculation
Remove quotes used as a wrapper to identify string values.
TextData::UPPERCASE() — Method in class TextData
UPPERCASE.
Cell::updateInCollection() — Method in class Cell
Update the cell into the cell collection.
Cells::update() — Method in class Cells
Add or update a cell in the collection.
Cells::unsetWorksheetCells() — Method in class Cells
Clear the cell collection and disconnect from our parent.
$Html#underlineProperty in class Html
ReferenceHelper::updateFormulaReferences() — Method in class ReferenceHelper
Update references within formulas.
ReferenceHelper::updateCellReference() — Method in class ReferenceHelper
Update cell reference.
ReferenceHelper::updateNamedFormulas() — Method in class ReferenceHelper
Update named formulas (i.e. containing worksheet references / named ranges).
$File#useUploadTempDirectoryProperty in class File
Use Temp or File Upload Temp for temporary files.
Matrix::uminus() — Method in class Matrix
uminus.
StringHelper::UTF8toBIFF8UnicodeShort() — Method in class StringHelper
Converts a UTF-8 string into BIFF8 Unicode string data (8-bit string length) Writes the string using uncompressed notation, no rich text, no Asian phonetics If mbstring extension is not available, ASCII is assumed, and compressed notation is used although this will give wrong results for non-ASCII strings see OpenOffice.org's Documentation of the Microsoft Excel File Format, sect. 2.5.3.
StringHelper::UTF8toBIFF8UnicodeLong() — Method in class StringHelper
Converts a UTF-8 string into BIFF8 Unicode string data (16-bit string length) Writes the string using uncompressed notation, no rich text, no Asian phonetics If mbstring extension is not available, ASCII is assumed, and compressed notation is used although this will give wrong results for non-ASCII strings see OpenOffice.org's Documentation of the Microsoft Excel File Format, sect. 2.5.3.
$Font#underlineProperty in class Font
Underline.
Worksheet::unmergeCells() — Method in class Worksheet
Remove merge on a cell range.
Worksheet::unmergeCellsByColumnAndRow() — Method in class Worksheet
Remove merge on a cell range by using numeric cell coordinates.
Worksheet::unprotectCells() — Method in class Worksheet
Remove protection on a cell range.
Worksheet::unprotectCellsByColumnAndRow() — Method in class Worksheet
Remove protection on a cell range by using numeric cell coordinates.
Worksheet::unfreezePane() — Method in class Worksheet
Unfreeze Pane.

V

Functions::VALUE() — Method in class Functions
VALUE.
LookupRef::VLOOKUP() — Method in class LookupRef
VLOOKUP The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number.
Statistical::VARFunc() — Method in class Statistical
VARFunc.
Statistical::VARA() — Method in class Statistical
VARA.
Statistical::VARP() — Method in class Statistical
VARP.
Statistical::VARPA() — Method in class Statistical
VARPA.
TextData::VALUE() — Method in class TextData
VALUE.
Date::validateTimeZone() — Method in class Date
Validate a timezone.
$BestFit#valueCountProperty in class BestFit
Number of entries in the sets of x- and y-value arrays.
$Alignment#verticalProperty in class Alignment
Vertical alignment.
$Borders#verticalProperty in class Borders
Vertical pseudo-border. Only applies to supervisor.
ColumnCellIterator::valid() — Method in class ColumnCellIterator
Indicate if more rows exist in the worksheet range of rows that we're iterating.
ColumnIterator::valid() — Method in class ColumnIterator
Indicate if more columns exist in the worksheet range of columns that we're iterating.
Iterator::valid() — Method in class Iterator
Are there more Worksheet instances available?
RowCellIterator::valid() — Method in class RowCellIterator
Indicate if more columns exist in the worksheet range of columns that we're iterating.
RowIterator::valid() — Method in class RowIterator
Indicate if more rows exist in the worksheet range of rows that we're iterating.

W

Calculation::wrapResult() — Method in class Calculation
Wrap string values in quotes.
DateTime::WORKDAY() — Method in class DateTime
WORKDAY.
DateTime::WEEKDAY() — Method in class DateTime
WEEKDAY.
DateTime::WEEKNUM() — Method in class DateTime
WEEKNUM.
Logger::writeDebugLog() — Method in class Logger
Write an entry to the calculation engine debug log.
Statistical::WEIBULL() — Method in class Statistical
WEIBULL.
Sample::write() — Method in class Sample
Write documents.
Xml::widthUnits2Pixel() — Method in class Xml
excel width units(units of 1/256th of a character width) to pixel units.
$OLERead#wrkbookProperty in class OLERead
XMLWriter::writeRawData() — Method in class XMLWriter
Wrapper method for writeRaw.
$Alignment#wrapTextProperty in class Alignment
Wrap text.
$BaseDrawing#worksheetProperty in class BaseDrawing
Worksheet.
$BaseDrawing#widthProperty in class BaseDrawing
Width.
$CellIterator#worksheetProperty in class CellIterator
Worksheet to iterate.
WorksheetClass in namespace PhpOffice\PhpSpreadsheet\Worksheet
Html::writeAllSheets() — Method in class Html
Write all sheets (resets sheetIndex to NULL).
Comment::write() — Method in class Comment
Content::write() — Method in class Content
Write content.xml to XML format.
Meta::write() — Method in class Meta
Write meta.xml to XML format.
MetaInf::writeManifest() — Method in class MetaInf
Write META-INF/manifest.xml to XML format.
Mimetype::write() — Method in class Mimetype
Write mimetype to plain text format.
Settings::write() — Method in class Settings
Write settings.xml to XML format.
Styles::write() — Method in class Styles
Write styles.xml to XML format.
Thumbnails::writeThumbnail() — Method in class Thumbnails
Write Thumbnails/thumbnail.png to PNG format.
WriterPartClass in namespace PhpOffice\PhpSpreadsheet\Writer\Ods
BIFFwriter::writeData() — Method in class BIFFwriter
General storage function like append, but returns string instead of modifying $this->_data.
BIFFwriter::writeEof() — Method in class BIFFwriter
Writes Excel EOF record to indicate the end of a BIFF stream.
Font::writeFont() — Method in class Font
Get font record data.
WorkbookClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xls
Workbook::writeWorkbook() — Method in class Workbook
Assemble worksheets into a workbook and send the BIFF data to an OLE storage.
WorksheetClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xls
Worksheet::writeBlank() — Method in class Worksheet
Write a blank cell to the specified row and column (zero indexed).
Worksheet::writeUrlRange() — Method in class Worksheet
This is the more general form of writeUrl(). It allows a hyperlink to be written to a range of cells. This function also decides the type of hyperlink to be written. These are either, Web (http, ftp, mailto), Internal (Sheet1!A1) or external ('c:\temp\foo.xls#Sheet1!A1').
Worksheet::writeUrlWeb() — Method in class Worksheet
Used to write http, ftp and mailto hyperlinks.
Worksheet::writeUrlInternal() — Method in class Worksheet
Used to write internal reference hyperlinks such as "Sheet1!A1".
Worksheet::writeUrlExternal() — Method in class Worksheet
Write links to external directory names such as 'c:\foo.xls', c:\foo.xls#Sheet1!A1', '.
Xf::writeXf() — Method in class Xf
Generate an Excel BIFF XF record (style or cell).
Chart::writeChart() — Method in class Chart
Write charts to XML format.
Comments::writeComments() — Method in class Comments
Write comments to XML format.
Comments::writeVMLComments() — Method in class Comments
Write VML comments to XML format.
ContentTypes::writeContentTypes() — Method in class ContentTypes
Write content types to XML format.
DocProps::writeDocPropsApp() — Method in class DocProps
Write docProps/app.xml to XML format.
DocProps::writeDocPropsCore() — Method in class DocProps
Write docProps/core.xml to XML format.
DocProps::writeDocPropsCustom() — Method in class DocProps
Write docProps/custom.xml to XML format.
Drawing::writeDrawings() — Method in class Drawing
Write drawings to XML format.
Drawing::writeChart() — Method in class Drawing
Write drawings to XML format.
Drawing::writeDrawing() — Method in class Drawing
Write drawings to XML format.
Drawing::writeVMLHeaderFooterImages() — Method in class Drawing
Write VML header/footer images to XML format.
Rels::writeRelationships() — Method in class Rels
Write relationships to XML format.
Rels::writeWorkbookRelationships() — Method in class Rels
Write workbook relationships to XML format.
Rels::writeWorksheetRelationships() — Method in class Rels
Write worksheet relationships to XML format.
Rels::writeDrawingRelationships() — Method in class Rels
Write drawing relationships to XML format.
Rels::writeHeaderFooterDrawingRelationships() — Method in class Rels
Write header/footer drawing relationships to XML format.
RelsRibbon::writeRibbonRelationships() — Method in class RelsRibbon
Write relationships for additional objects of custom UI (ribbon).
RelsVBA::writeVBARelationships() — Method in class RelsVBA
Write relationships for a signed VBA Project.
StringTable::writeStringTable() — Method in class StringTable
Write string table to XML format.
StringTable::writeRichText() — Method in class StringTable
Write Rich Text.
StringTable::writeRichTextForCharts() — Method in class StringTable
Write Rich Text.
Style::writeStyles() — Method in class Style
Write styles to XML format.
Theme::writeTheme() — Method in class Theme
Write theme to XML format.
WorkbookClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx
Workbook::writeWorkbook() — Method in class Workbook
Write workbook to XML format.
WorksheetClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx
Worksheet::writeWorksheet() — Method in class Worksheet
Write worksheet to XML format.
WriterPartClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xlsx

X

Financial::XIRR() — Method in class Financial
Financial::XNPV() — Method in class Financial
XNPV.
XmlScannerClass in namespace PhpOffice\PhpSpreadsheet\Reader\Security
XlsClass in namespace PhpOffice\PhpSpreadsheet\Reader
XlsxClass in namespace PhpOffice\PhpSpreadsheet\Reader
XmlClass in namespace PhpOffice\PhpSpreadsheet\Reader
Reader for SpreadsheetML, the XML schema for Microsoft Office Excel 2003.
$BestFit#xValuesProperty in class BestFit
X-value dataseries of values.
$BestFit#xOffsetProperty in class BestFit
XMLWriterClass in namespace PhpOffice\PhpSpreadsheet\Shared
XlsClass in namespace PhpOffice\PhpSpreadsheet\Shared
XlsClass in namespace PhpOffice\PhpSpreadsheet\Writer
XfClass in namespace PhpOffice\PhpSpreadsheet\Writer\Xls
XlsxClass in namespace PhpOffice\PhpSpreadsheet\Writer

Y

DateTime::YEARFRAC() — Method in class DateTime
YEARFRAC.
DateTime::YEAR() — Method in class DateTime
YEAR.
Financial::YIELDDISC() — Method in class Financial
YIELDDISC.
Financial::YIELDMAT() — Method in class Financial
YIELDMAT.
$BestFit#yValuesProperty in class BestFit
Y-value dataseries of values.
$BestFit#yBestFitValuesProperty in class BestFit
Y-value series of best-fit values.
$BestFit#yOffsetProperty in class BestFit

Z

Statistical::ZTEST() — Method in class Statistical
ZTEST.

_

Calculation::__construct() — Method in class Calculation
Calculation::__clone() — Method in class Calculation
__clone implementation. Cloning should not be allowed in a Singleton!
Calculation::_translateFormulaToLocale() — Method in class Calculation
Calculation::_translateFormulaToEnglish() — Method in class Calculation
Calculation::_calculateFormulaValue() — Method in class Calculation
Parse a cell formula and calculate its value.
Logger::__construct() — Method in class Logger
Instantiate a Calculation engine logger.
ExceptionHandler::__construct() — Method in class ExceptionHandler
Register errorhandler.
ExceptionHandler::__destruct() — Method in class ExceptionHandler
Unregister errorhandler.
FormulaParser::__construct() — Method in class FormulaParser
Create a new FormulaParser.
FormulaToken::__construct() — Method in class FormulaToken
Create a new FormulaToken.
Cell::__construct() — Method in class Cell
Create a new Cell.
Cell::__clone() — Method in class Cell
Implement PHP __clone to create a deep clone, not just a shallow copy.
Cell::__toString() — Method in class Cell
Convert to string.
DataValidation::__construct() — Method in class DataValidation
Create a new DataValidation.
DataValidation::__clone() — Method in class DataValidation
Implement PHP __clone to create a deep clone, not just a shallow copy.
Hyperlink::__construct() — Method in class Hyperlink
Create a new Hyperlink.
Chart::__construct() — Method in class Chart
Create a new Chart.
DataSeries::__construct() — Method in class DataSeries
Create a new DataSeries.
DataSeriesValues::__construct() — Method in class DataSeriesValues
Create a new DataSeriesValues object.
Layout::__construct() — Method in class Layout
Create a new Layout.
Legend::__construct() — Method in class Legend
Create a new Legend.
PlotArea::__construct() — Method in class PlotArea
Create a new PlotArea.
IRenderer::__construct() — Method in class IRenderer
IRenderer constructor.
JpGraph::__construct() — Method in class JpGraph
Create a new jpgraph.
Title::__construct() — Method in class Title
Create a new Title.
Cells::__construct() — Method in class Cells
Initialise this new cell collection.
Cells::__destruct() — Method in class Cells
Destroy this cell collection.
Comment::__construct() — Method in class Comment
Create a new Comment.
Comment::__clone() — Method in class Comment
Implement PHP __clone to create a deep clone, not just a shallow copy.
Comment::__toString() — Method in class Comment
Convert to string.
Properties::__construct() — Method in class Properties
Create a new Document Properties instance.
Properties::__clone() — Method in class Properties
Implement PHP __clone to create a deep clone, not just a shallow copy.
Security::__construct() — Method in class Security
Create a new Document Security instance.
Security::__clone() — Method in class Security
Implement PHP __clone to create a deep clone, not just a shallow copy.
HashTable::__construct() — Method in class HashTable
Create a new \PhpOffice\PhpSpreadsheet\HashTable.
HashTable::__clone() — Method in class HashTable
Implement PHP __clone to create a deep clone, not just a shallow copy.
Migrator::__construct() — Method in class Migrator
NamedRange::__construct() — Method in class NamedRange
Create a new NamedRange.
NamedRange::__clone() — Method in class NamedRange
Implement PHP __clone to create a deep clone, not just a shallow copy.
Csv::__construct() — Method in class Csv
Create a new CSV Reader instance.
Gnumeric::__construct() — Method in class Gnumeric
Create a new Gnumeric.
Html::__construct() — Method in class Html
Create a new HTML Reader instance.
IReader::__construct() — Method in class IReader
IReader constructor.
Ods::__construct() — Method in class Ods
Create a new Ods Reader instance.
XmlScanner::__destruct() — Method in class XmlScanner
Slk::__construct() — Method in class Slk
Create a new SYLK Reader instance.
Xls::__construct() — Method in class Xls
Create a new Xls Reader instance.
Escher::__construct() — Method in class Escher
Create a new Escher instance.
MD5::__construct() — Method in class MD5
MD5 stream constructor.
RC4::__construct() — Method in class RC4
RC4 stream decryption/encryption constrcutor.
Xlsx::__construct() — Method in class Xlsx
Create a new Xlsx Reader instance.
Theme::__construct() — Method in class Theme
Create a new Theme.
Theme::__clone() — Method in class Theme
Implement PHP __clone to create a deep clone, not just a shallow copy.
Xml::__construct() — Method in class Xml
Create a new Excel2003XML Reader instance.
ReferenceHelper::__construct() — Method in class ReferenceHelper
Create a new ReferenceHelper.
ReferenceHelper::__clone() — Method in class ReferenceHelper
__clone implementation. Cloning should not be allowed in a Singleton!
RichText::__construct() — Method in class RichText
Create a new RichText instance.
RichText::__toString() — Method in class RichText
Convert to string.
RichText::__clone() — Method in class RichText
Implement PHP __clone to create a deep clone, not just a shallow copy.
Run::__construct() — Method in class Run
Create a new Run instance.
TextElement::__construct() — Method in class TextElement
Create a new TextElement instance.
TextElement::__clone() — Method in class TextElement
Implement PHP __clone to create a deep clone, not just a shallow copy.
CholeskyDecomposition::__construct() — Method in class CholeskyDecomposition
CholeskyDecomposition.
EigenvalueDecomposition::__construct() — Method in class EigenvalueDecomposition
Constructor: Check for symmetry, then construct the eigenvalue decomposition.
LUDecomposition::__construct() — Method in class LUDecomposition
LU Decomposition constructor.
Matrix::__construct() — Method in class Matrix
Polymorphic constructor.
QRDecomposition::__construct() — Method in class QRDecomposition
QR Decomposition computed by Householder reflections.
SingularValueDecomposition::__construct() — Method in class SingularValueDecomposition
Construct the singular value decomposition.
$OLE#_file_handleProperty in class OLE
The file handle for reading an OLE container.
$OLE#_listProperty in class OLE
Array of PPS's found on the OLE container.
OLE::_getBlockOffset() — Method in class OLE
OLE::_readPpsWks() — Method in class OLE
Gets information about all PPS's on the OLE container from the PPS WK's creates an OLE_PPS object for each one.
OLE::_ppsTreeComplete() — Method in class OLE
It checks whether the PPS tree is complete (all PPS's read) starting with the given PPS (not necessarily root).
$PPS#_dataProperty in class PPS
The PPS's data (only used if it's not using a temporary file).
PPS::__construct() — Method in class PPS
The constructor.
PPS::_getPpsWk() — Method in class PPS
Returns a string with the PPS's WK (What is a WK?).
PPS::_savePpsSetPnt() — Method in class PPS
Updates index and pointers to previous, next and children PPS's for this PPS. I don't think it'll work with Dir PPS's.
File::__construct() — Method in class File
The constructor.
Root::__construct() — Method in class Root
Root::_calcSize() — Method in class Root
Calculate some numbers.
Root::_saveHeader() — Method in class Root
Save OLE header.
Root::_saveBigData() — Method in class Root
Saving big data (PPS's with data bigger than \PhpOffice\PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL).
Root::_makeSmallData() — Method in class Root
get small data (PPS's with data smaller than \PhpOffice\PhpSpreadsheet\Shared\OLE::OLE_DATA_SIZE_SMALL).
Root::_savePps() — Method in class Root
Saves all the PPS's WKs.
Root::_saveBbd() — Method in class Root
Saving Big Block Depot.
BestFit::__construct() — Method in class BestFit
Define the regression.
ExponentialBestFit::__construct() — Method in class ExponentialBestFit
Define the regression and calculate the goodness of fit for a set of X and Y data values.
LinearBestFit::__construct() — Method in class LinearBestFit
Define the regression and calculate the goodness of fit for a set of X and Y data values.
LogarithmicBestFit::__construct() — Method in class LogarithmicBestFit
Define the regression and calculate the goodness of fit for a set of X and Y data values.
PolynomialBestFit::__construct() — Method in class PolynomialBestFit
Define the regression and calculate the goodness of fit for a set of X and Y data values.
PowerBestFit::__construct() — Method in class PowerBestFit
Define the regression and calculate the goodness of fit for a set of X and Y data values.
XMLWriter::__construct() — Method in class XMLWriter
Create a new XMLWriter instance.
XMLWriter::__destruct() — Method in class XMLWriter
Destructor.
Spreadsheet::__construct() — Method in class Spreadsheet
Create a new PhpSpreadsheet with one Worksheet.
Spreadsheet::__destruct() — Method in class Spreadsheet
Code to execute when this worksheet is unset().
Spreadsheet::__clone() — Method in class Spreadsheet
Implement PHP __clone to create a deep clone, not just a shallow copy.
Alignment::__construct() — Method in class Alignment
Create a new Alignment.
Border::__construct() — Method in class Border
Create a new Border.
Borders::__construct() — Method in class Borders
Create a new Borders.
Color::__construct() — Method in class Color
Create a new Color.
Conditional::__construct() — Method in class Conditional
Create a new Conditional.
Conditional::__clone() — Method in class Conditional
Implement PHP __clone to create a deep clone, not just a shallow copy.
Fill::__construct() — Method in class Fill
Create a new Fill.
Font::__construct() — Method in class Font
Create a new Font.
NumberFormat::__construct() — Method in class NumberFormat
Create a new NumberFormat.
Protection::__construct() — Method in class Protection
Create a new Protection.
Style::__construct() — Method in class Style
Create a new Style.
Supervisor::__construct() — Method in class Supervisor
Create a new Supervisor.
Supervisor::__clone() — Method in class Supervisor
Implement PHP __clone to create a deep clone, not just a shallow copy.
AutoFilter::__construct() — Method in class AutoFilter
Create a new AutoFilter.
AutoFilter::__clone() — Method in class AutoFilter
Implement PHP __clone to create a deep clone, not just a shallow copy.
AutoFilter::__toString() — Method in class AutoFilter
toString method replicates previous behavior by returning the range if object is referenced as a property of its parent.
Column::__construct() — Method in class Column
Create a new Column.
Column::__clone() — Method in class Column
Implement PHP __clone to create a deep clone, not just a shallow copy.
Rule::__construct() — Method in class Rule
Create a new Rule.
Rule::__clone() — Method in class Rule
Implement PHP __clone to create a deep clone, not just a shallow copy.
BaseDrawing::__construct() — Method in class BaseDrawing
Create a new BaseDrawing.
BaseDrawing::__clone() — Method in class BaseDrawing
Implement PHP __clone to create a deep clone, not just a shallow copy.
CellIterator::__destruct() — Method in class CellIterator
Destructor.
Column::__construct() — Method in class Column
Create a new column.
Column::__destruct() — Method in class Column
Destructor.
ColumnCellIterator::__construct() — Method in class ColumnCellIterator
Create a new row iterator.
ColumnDimension::__construct() — Method in class ColumnDimension
Create a new ColumnDimension.
ColumnIterator::__construct() — Method in class ColumnIterator
Create a new column iterator.
ColumnIterator::__destruct() — Method in class