Package PHPExcel_Writer_Excel5 Element Index

_

$_activesheet: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_activesheet
The active worksheet of the workbook (0 indexed)
$_active_pane: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_active_pane
The active pane for the worksheet
$_bg_color: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_bg_color
The cell's background color.
$_biffsize: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_biffsize
The BIFF file size for the workbook.
$_BIFF_version: in file BIFFwriter.php, variable PHPExcel_Writer_Excel5_BIFFwriter::$_BIFF_version
The BIFF/Excel version (5).
$_BIFF_version: in file Parser.php, variable PHPExcel_Writer_Excel5_Parser::$_BIFF_version
The BIFF version for the workbook
$_bold: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_bold
Bold style
$_bottom: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_bottom
Style of the bottom border of the cell
$_bottom_color: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_bottom_color
Color of the bottom border of the cell.
$_byte_order: in file BIFFwriter.php, variable PHPExcel_Writer_Excel5_BIFFwriter::$_byte_order
The byte order of this architecture.
$_byte_order: in file Parser.php, variable PHPExcel_Writer_Excel5_Parser::$_byte_order
The byte order.
$_codepage: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_codepage
The codepage indicates the text encoding used for strings
$_colinfo: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_colinfo
Array containing format information for columns
$_color: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_color
Index to the cell's color
$_colors: in file Excel5.php, variable PHPExcel_Writer_Excel5::$_colors
Color cache
$_country_code: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_country_code
The country code used for localization
$_current_char: in file Parser.php, variable PHPExcel_Writer_Excel5_Parser::$_current_char
The index of the character we are currently looking at
$_current_token: in file Parser.php, variable PHPExcel_Writer_Excel5_Parser::$_current_token
The token we are working on.
$_data: in file BIFFwriter.php, variable PHPExcel_Writer_Excel5_BIFFwriter::$_data
The string containing the data of the BIFF stream
$_datasize: in file BIFFwriter.php, variable PHPExcel_Writer_Excel5_BIFFwriter::$_datasize
The size of the data in bytes.
$_dim_colmax: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_dim_colmax
Last column for the DIMENSIONS record
$_dim_colmin: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_dim_colmin
First column for the DIMENSIONS record
$_dim_rowmax: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_dim_rowmax
Last row for the DIMENSIONS record
$_dim_rowmin: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_dim_rowmin
First row for the DIMENSIONS record
$_ext_sheets: in file Parser.php, variable PHPExcel_Writer_Excel5_Parser::$_ext_sheets
Array of external sheets
$_fg_color: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_fg_color
The cell's foreground color.
$_fileclosed: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_fileclosed
Flag for preventing close from being called twice.
$_filehandle: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_filehandle
Filehandle to the temporary file for storing data
$_filename: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_filename
Filename for the Workbook
$_firstColumnIndex: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_firstColumnIndex
Index of first used column (at least 0)
$_firstRowIndex: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_firstRowIndex
Index of first used row (at least 0)
$_firstsheet: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_firstsheet
1st displayed worksheet in the workbook (0 indexed)
$_font_charset: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_font_charset
Byte specifiying the font charset.
$_font_family: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_font_family
Byte specifiying the font family.
$_font_name: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_font_name
The font name (ASCII).
$_font_outline: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_font_outline
Bit specifiying if the font has outline.
$_font_script: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_font_script
2 bytes specifiying the script type for the font.
$_font_shadow: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_font_shadow
Bit specifiying if the font has shadow.
$_font_strikeout: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_font_strikeout
Bit specifiying if the font has strikeout.
$_formats: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_formats
Array containing references to all of this workbook's formats
$_formula: in file Parser.php, variable PHPExcel_Writer_Excel5_Parser::$_formula
The formula to parse
$_hidden: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_hidden
Bit specifying if formulas are hidden.
$_indent: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_indent
Indent level
$_italic: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_italic
Bit specifiying if the font is italic.
$_lastColumnIndex: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_lastColumnIndex
Index of last used column (no used columns means -1)
$_lastRowIndex: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_lastRowIndex
Index of last used row.
$_left: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_left
Style of the left border of the cell
$_left_color: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_left_color
Color of the left border of the cell.
$_limit: in file BIFFwriter.php, variable PHPExcel_Writer_Excel5_BIFFwriter::$_limit
The maximun length for a BIFF record.
$_locked: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_locked
Bit specifying if the cell is locked.
$_lookahead: in file Parser.php, variable PHPExcel_Writer_Excel5_Parser::$_lookahead
The character ahead of the current char
$_num_format: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_num_format
An index (2 bytes) to a FORMAT record (number format).
$_outline_below: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_outline_below
Whether to have outline summary below.
$_outline_on: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_outline_on
Whether to use outline.
$_outline_right: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_outline_right
Whether to have outline summary at the right.
$_outline_row_level: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_outline_row_level
Outline row level.
$_outline_style: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_outline_style
Auto outline styles.
$_palette: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_palette
Array containing the colour palette
$_parser: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_parser
Reference to the parser used for parsing formulas
$_parser: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_parser
Formula parser
$_parse_tree: in file Parser.php, variable PHPExcel_Writer_Excel5_Parser::$_parse_tree
The parse tree to be generated
$_pattern: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_pattern
The cell's background fill pattern.
$_phpExcel: in file Excel5.php, variable PHPExcel_Writer_Excel5::$_phpExcel
PHPExcel object
$_phpExcel: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_phpExcel
Workbook
$_phpSheet: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_phpSheet
Sheet object
$_references: in file Parser.php, variable PHPExcel_Writer_Excel5_Parser::$_references
Array of sheet references in the form of REF structures
$_right: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_right
Style of the right border of the cell
$_right_color: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_right_color
Color of the right border of the cell.
$_rotation: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_rotation
Integer specifying the text rotation.
$_selected: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_selected
Number of workbook tabs selected
$_selection: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_selection
Array containing the selected area for the worksheet
$_sheetname: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_sheetname
The default sheetname for all sheets created.
$_sheetnames: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_sheetnames
Array of sheetnames for creating the EXTERNSHEET records
$_shrink_to_fit: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_shrink_to_fit
Shrink to fit
$_size: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_size
Height of font (1/20 of a point)
$_string_sizeinfo_size: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_string_sizeinfo_size
number of bytes for sizeinfo of strings
$_str_table: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_str_table
Reference to the array containing all the unique strings in the workbook
$_str_total: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_str_total
Reference to the total number of strings in the workbook
$_str_unique: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_str_unique
Reference to the number of unique strings in the workbook
$_tempDir: in file Excel5.php, variable PHPExcel_Writer_Excel5::$_tempDir
Temporary storage directory
$_tempFilesCreated: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_tempFilesCreated
List of temporary files created
$_text_h_align: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_text_h_align
The three bits specifying the text horizontal alignment.
$_text_justlast: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_text_justlast
1 bit, apparently not used.
$_text_v_align: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_text_v_align
The three bits specifying the text vertical alignment.
$_text_wrap: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_text_wrap
Bit specifying if the text is wrapped at the right border.
$_tmp_dir: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_tmp_dir
The temporary dir for storing files
$_tmp_dir: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_tmp_dir
The temporary dir for storing the OLE file
$_tmp_format: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_tmp_format
The default XF format.
$_top: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_top
Style of the top border of the cell
$_top_color: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_top_color
Color of the top border of the cell.
$_underline: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_underline
The text underline property
$_url_format: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_url_format
Reference to the (default) Format object for URLs
$_url_format: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_url_format
The default format for URLs.
$_using_tmpfile: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_using_tmpfile
Boolean indicating if we are using a temporary file for storing data
$_worksheets: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_worksheets
Array containing references to all of this workbook's worksheets
$_xf_index: in file Workbook.php, variable PHPExcel_Writer_Excel5_Workbook::$_xf_index
Index for creating adding new formats to the workbook
$_xf_index: in file Format.php, variable PHPExcel_Writer_Excel5_Format::$_xf_index
The index given by the workbook when creating a new format.
$_xls_colmax: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_xls_colmax
Maximum number of columns for an Excel spreadsheet (BIFF5)
$_xls_rowmax: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_xls_rowmax
Maximum number of rows for an Excel spreadsheet (BIFF5)
$_xls_strmax: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$_xls_strmax
Maximum number of characters for a string (LABEL record in BIFF5)
_addColor: in file Excel5.php, method PHPExcel_Writer_Excel5::_addColor()
Add color
_addContinue: in file BIFFwriter.php, method PHPExcel_Writer_Excel5_BIFFwriter::_addContinue()
Excel limits the size of BIFF records. Excel 97 the limit is 8228 bytes. must be split up into CONTINUE blocks.
_advance: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_advance()
Advance to the next valid token.
_allStyles: in file Excel5.php, method PHPExcel_Writer_Excel5::_allStyles()
Get an array of all styles
_append: in file BIFFwriter.php, method PHPExcel_Writer_Excel5_BIFFwriter::_append()
General storage function
_append: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_append()
Store Worksheet data in memory using the parent's class append() or to a temporary file, the default.
_calcSheetOffsets: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_calcSheetOffsets()
Calculate offsets for Worksheet BOF records.
_calculateSharedStringsSizes: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_calculateSharedStringsSizes()
Calculate Handling of the SST continue blocks is complicated by the need to include an additional continuation byte depending on whether the string is split between blocks or whether it starts at the beginning of the block. additional complications that will arise later when/if Rich Strings are supported).
_cellToPackedRowcol: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_cellToPackedRowcol()
pack() row and column into the required 3 or 4 byte format.
_cellToRowcol: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_cellToRowcol()
Convert an Excel cell reference such as A1 or $B2 or C$3 or $D$4 to a zero indexed row and column number. whether the row or column are relative references.
_checkRowCol: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_checkRowCol()
Check row and col before writing to a cell, and update the sheet's
_condition: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_condition()
It parses a condition.
_convert: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_convert()
Convert a token to the proper ptg value.
_convertFunction: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_convertFunction()
Convert a function to a ptgFunc or ptgFuncVarV depending on the number of args that it takes.
_convertNumber: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_convertNumber()
Convert a number token to ptgInt or ptgNum
_convertRange2d: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_convertRange2d()
Convert an Excel range such as A1:D4 to a ptgRefV.
_convertRange3d: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_convertRange3d()
Convert an Excel 3d range such as "Sheet1!A1:D4" or "Sheet1:Sheet2!A1:D4" to a ptgArea3d.
_convertRef2d: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_convertRef2d()
Convert an Excel reference such as A1, $B2, C$3 or $D$4 to a ptgRefV.
_convertRef3d: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_convertRef3d()
Convert an Excel 3d reference such as "Sheet1!A1" or "Sheet1:Sheet2!A1" to a ptgRef3d.
_convertString: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_convertString()
Convert a string token to ptgStr
_createTree: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_createTree()
Creates a tree. as elements.
_expression: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_expression()
It parses a expression.
_fact: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_fact()
It parses a factor.
_func: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_func()
It parses a function call.
_getColor: in file Format.php, method PHPExcel_Writer_Excel5_Format::_getColor()
Used in conjunction with the set_xxx_color methods to convert a color string into a number. to 8.
_getRefIndex: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_getRefIndex()
Look up the REF index that corresponds to an external sheet name (or range). array.
_getSheetIndex: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_getSheetIndex()
Look up the index that corresponds to an external sheet name. sheet names is updated by the addworksheet() method of the PHPExcel_Writer_Excel5_Workbook class.
_initialize: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_initialize()
Open a tmp file to store the majority of the Worksheet data. for example due to write permissions, store the data in memory. slow for large files.
_initializeHashes: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_initializeHashes()
Initialize the ptg and function hashes.
_mapBorderStyle: in file Excel5.php, method PHPExcel_Writer_Excel5::_mapBorderStyle()
Map border style
_mapErrorCode: in file Excel5.php, method PHPExcel_Writer_Excel5::_mapErrorCode()
Map Error code
_mapFillType: in file Excel5.php, method PHPExcel_Writer_Excel5::_mapFillType()
Map fill type
_mapUnderline: in file Excel5.php, method PHPExcel_Writer_Excel5::_mapUnderline()
Map underline
_mapVAlign: in file Excel5.php, method PHPExcel_Writer_Excel5::_mapVAlign()
Map VAlign
_match: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_match()
Checks if it's a valid token.
_packExtRef: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_packExtRef()
Convert the sheet name part of an external reference, for example "Sheet1" or "Sheet1:Sheet2", to a packed structure.
_parenthesizedExpression: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_parenthesizedExpression()
This function just introduces a ptgParen element in the tree, so that Excel doesn't get confused when working with a parenthesized formula afterwards.
_positionImage: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_positionImage()
Calculate the vertices that define the position of the image as required by the OBJ record.
_prepend: in file BIFFwriter.php, method PHPExcel_Writer_Excel5_BIFFwriter::_prepend()
General storage function
_processBitmap: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_processBitmap()
Convert a 24 bit bitmap into the modified internal format used by Windows.
_processBitmapGd: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_processBitmapGd()
Convert a GD-image into the internal format.
_rangeToPackedRange: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_rangeToPackedRange()
pack() row range into the required 3 or 4 byte format.
_setByteOrder: in file BIFFwriter.php, method PHPExcel_Writer_Excel5_BIFFwriter::_setByteOrder()
Determine the byte order and store it as class data to avoid recalculating it for each call to new().
_setPaletteXl97: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_setPaletteXl97()
Sets the colour palette to the Excel 97+ default.
_sizeCol: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_sizeCol()
Convert the width of a cell from user's units to pixels. the relationship is: y = 7x +5. use the default value.
_sizeRow: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_sizeRow()
Convert the height of a cell from user's units to pixels. the relationship is: y = 4/3x. use the default value. possible to hide row yet).
_storeAllFonts: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeAllFonts()
Store the Excel FONT records.
_storeAllNumFormats: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeAllNumFormats()
Store user defined numerical formats i.
_storeAllStyles: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeAllStyles()
Write all STYLE records.
_storeAllXfs: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeAllXfs()
Write all XF records.
_storeBof: in file BIFFwriter.php, method PHPExcel_Writer_Excel5_BIFFwriter::_storeBof()
Writes Excel BOF record to indicate the beginning of a stream or sub-stream in the BIFF file.
_storeBoundsheet: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeBoundsheet()
Writes Excel BIFF BOUNDSHEET record.
_storeBreaks: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeBreaks()
Write the HORIZONTALPAGEBREAKS and VERTICALPAGEBREAKS BIFF records.
_storeCodepage: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeCodepage()
Stores the CODEPAGE biff record.
_storeColinfo: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeColinfo()
Write BIFF record COLINFO to define column widths Note: The SDK says the record length is 0x0B but Excel writes a 0x0C length record.
_storeDataValidity: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeDataValidity()
Store the DVAL and DV records.
_storeDatemode: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeDatemode()
Write DATEMODE record to indicate the date system in use (1904 or 1900).
_storeDefaultRowHeight: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeDefaultRowHeight()
Write BIFF record DEFAULTROWHEIGHT.
_storeDefcol: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeDefcol()
Write BIFF record DEFCOLWIDTH if COLINFO records are in use.
_storeDimensions: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeDimensions()
Writes Excel DIMENSIONS to define the area in which there is data.
_storeEof: in file BIFFwriter.php, method PHPExcel_Writer_Excel5_BIFFwriter::_storeEof()
Writes Excel EOF record to indicate the end of a BIFF stream.
_storeExterncount: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeExterncount()
Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet.
_storeExterncount: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeExterncount()
Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in the workbook.
_storeExterns: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeExterns()
Write the EXTERNCOUNT and EXTERNSHEET records. the NAME records.
_storeExternsheet: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeExternsheet()
Writes the Excel BIFF EXTERNSHEET record. formulas. reference to all of the external worksheets the EXTERNSHEET index is the same as the worksheet index.
_storeExternsheet: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeExternsheet()
Writes the Excel BIFF EXTERNSHEET record. formulas. rows and columns.
_storeFooter: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeFooter()
Store the footer caption BIFF record.
_storeGridset: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeGridset()
Write the GRIDSET BIFF record. PRINTGRIDLINES record.
_storeGuts: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeGuts()
Write the GUTS BIFF record. where Excel outline symbols are displayed. controlled by a flag in WSBOOL.
_storeHcenter: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeHcenter()
Store the horizontal centering HCENTER BIFF record.
_storeHeader: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeHeader()
Store the header caption BIFF record.
_storeMarginBottom: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeMarginBottom()
Store the BOTTOMMARGIN BIFF record.
_storeMarginLeft: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeMarginLeft()
Store the LEFTMARGIN BIFF record.
_storeMarginRight: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeMarginRight()
Store the RIGHTMARGIN BIFF record.
_storeMarginTop: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeMarginTop()
Store the TOPMARGIN BIFF record.
_storeMergedCells: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeMergedCells()
Store the MERGEDCELLS records for all ranges of merged cells
_storeNameLong: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeNameLong()
Store the NAME record in the long format that is used for storing the repeat rows and columns when both are specified. _storeNameShort() but we use a separate method to keep the code clean.
_storeNames: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeNames()
Write the NAME record to define the print area and the repeat rows and cols.
_storeNameShort: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeNameShort()
Store the NAME record in the short format that is used for storing the print area, repeat rows only and repeat columns only.
_storeNumFormat: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeNumFormat()
Writes Excel FORMAT record for non "built-in" numerical formats.
_storeObjPicture: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeObjPicture()
Store the OBJ record that precedes an IMDATA record. to support other Excel objects.
_storeOLEFile: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeOLEFile()
Store the workbook in an OLE container
_storePalette: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storePalette()
Stores the PALETTE biff record.
_storePanes: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storePanes()
Writes the Excel BIFF PANE record.
_storePassword: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storePassword()
Write the worksheet PASSWORD record.
_storePrintGridlines: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storePrintGridlines()
Write the PRINTGRIDLINES BIFF record. GRIDSET record.
_storePrintHeaders: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storePrintHeaders()
Write the PRINTHEADERS BIFF record.
_storeProtect: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeProtect()
Set the Biff PROTECT record to indicate that the worksheet is protected.
_storeRangeProtection: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeRangeProtection()
Write BIFF record RANGEPROTECTION
_storeSelection: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeSelection()
Write BIFF record SELECTION.
_storeSetup: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeSetup()
Store the page setup SETUP BIFF record.
_storeStyle: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeStyle()
Write Excel BIFF STYLE records.
_storeVcenter: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeVcenter()
Store the vertical centering VCENTER BIFF record.
_storeWindow1: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeWindow1()
Write Excel BIFF WINDOW1 record.
_storeWindow2: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeWindow2()
Write BIFF record Window2.
_storeWorkbook: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::_storeWorkbook()
Assemble worksheets into a workbook and send the BIFF data to an OLE storage.
_storeWsbool: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeWsbool()
Write the WSBOOL BIFF record, mainly for fit-to-page. with the SETUP record.
_storeZoom: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_storeZoom()
Store the window zoom factor. simplicity we will store all fractions with a numerator of 100.
_term: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::_term()
It parses a term.
_writeBIFF8CellRangeAddressFixed: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_writeBIFF8CellRangeAddressFixed()
Write a cell range address in BIFF8
_writeUrlExternal: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_writeUrlExternal()
Write links to external directory names such as 'c:\foo. c:\foo.
_writeUrlInternal: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_writeUrlInternal()
Used to write internal reference hyperlinks such as "Sheet1!A1".
_writeUrlRange: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_writeUrlRange()
This is the more general form of writeUrl(). written to a range of cells. to be written. (Sheet1!A1) or external ('c:\temp\foo.
_writeUrlWeb: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_writeUrlWeb()
Used to write http, ftp and mailto hyperlinks.
_XF: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::_XF()
Returns an index to the XF record in the workbook
__construct: in file Excel5.php, method PHPExcel_Writer_Excel5::__construct()
Create a new PHPExcel_Writer_Excel5

s

$selected: in file Worksheet.php, variable PHPExcel_Writer_Excel5_Worksheet::$selected
Bit specifying if the worksheet is selected
save: in file Excel5.php, method PHPExcel_Writer_Excel5::save()
Save PHPExcel to file
select: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::select()
Set this worksheet as a selected worksheet, i.
setAlign: in file Format.php, method PHPExcel_Writer_Excel5_Format::setAlign()
Set cell alignment.
setBgColor: in file Format.php, method PHPExcel_Writer_Excel5_Format::setBgColor()
Sets the cell's background color
setBold: in file Format.php, method PHPExcel_Writer_Excel5_Format::setBold()
Sets the boldness of the text.
setBorder: in file Format.php, method PHPExcel_Writer_Excel5_Format::setBorder()
Set cells borders to the same style
setBorderColor: in file Format.php, method PHPExcel_Writer_Excel5_Format::setBorderColor()
Sets all the cell's borders to the same color
setBottom: in file Format.php, method PHPExcel_Writer_Excel5_Format::setBottom()
Sets the width for the bottom border of the cell
setBottomColor: in file Format.php, method PHPExcel_Writer_Excel5_Format::setBottomColor()
Sets the cell's bottom border color
setColor: in file Format.php, method PHPExcel_Writer_Excel5_Format::setColor()
Sets the cell's color
setColumn: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::setColumn()
Set the width of a single column or a range of columns.
setCountry: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::setCountry()
Set the country identifier for the workbook
setCustomColor: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::setCustomColor()
Change the RGB components of the elements in the colour palette.
setDimensions: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::setDimensions()
Set sheet dimensions
setExtSheet: in file Parser.php, method PHPExcel_Writer_Excel5_Parser::setExtSheet()
This method is used to update the array of sheet names. called by the addWorksheet() method of the PHPExcel_Writer_Excel5_Workbook class.
setFgColor: in file Format.php, method PHPExcel_Writer_Excel5_Format::setFgColor()
Sets the cell's foreground color
setFirstSheet: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::setFirstSheet()
Set this worksheet as the first visible sheet.
setFontFamily: in file Format.php, method PHPExcel_Writer_Excel5_Format::setFontFamily()
Sets the font family name.
setHAlign: in file Format.php, method PHPExcel_Writer_Excel5_Format::setHAlign()
Set cell horizontal alignment.
setHidden: in file Format.php, method PHPExcel_Writer_Excel5_Format::setHidden()
Hide a cell.
setIndent: in file Format.php, method PHPExcel_Writer_Excel5_Format::setIndent()
Sets indent level
setItalic: in file Format.php, method PHPExcel_Writer_Excel5_Format::setItalic()
Sets the font style as italic
setLeft: in file Format.php, method PHPExcel_Writer_Excel5_Format::setLeft()
Sets the width for the left border of the cell
setLeftColor: in file Format.php, method PHPExcel_Writer_Excel5_Format::setLeftColor()
Sets the cell's left border color
setLocked: in file Format.php, method PHPExcel_Writer_Excel5_Format::setLocked()
Locks a cell.
setMerge: in file Format.php, method PHPExcel_Writer_Excel5_Format::setMerge()
This is an alias for the unintuitive setAlign('merge')
setNumFormat: in file Format.php, method PHPExcel_Writer_Excel5_Format::setNumFormat()
Sets the numeric format.
setOutline: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::setOutline()
This method sets the properties for outlining and grouping. correspond to Excel's defaults.
setOutLine: in file Format.php, method PHPExcel_Writer_Excel5_Format::setOutLine()
Sets outlining for a font.
setPattern: in file Format.php, method PHPExcel_Writer_Excel5_Format::setPattern()
Sets the fill pattern attribute of a cell
setRight: in file Format.php, method PHPExcel_Writer_Excel5_Format::setRight()
Sets the width for the right border of the cell
setRightColor: in file Format.php, method PHPExcel_Writer_Excel5_Format::setRightColor()
Sets the cell's right border color
setRow: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::setRow()
This method is used to set the height and format for a row.
setScript: in file Format.php, method PHPExcel_Writer_Excel5_Format::setScript()
Sets the script type of the text
setSelection: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::setSelection()
Set which cell or cells are selected in a worksheet
setShadow: in file Format.php, method PHPExcel_Writer_Excel5_Format::setShadow()
Sets font as shadow.
setShrinkToFit: in file Format.php, method PHPExcel_Writer_Excel5_Format::setShrinkToFit()
Sets Shrink To Fit
setSize: in file Format.php, method PHPExcel_Writer_Excel5_Format::setSize()
Sets the font size
setStrikeOut: in file Format.php, method PHPExcel_Writer_Excel5_Format::setStrikeOut()
Sets font as strikeout.
setTempDir: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::setTempDir()
Sets the temp dir used for storing the OLE file
setTempDir: in file Excel5.php, method PHPExcel_Writer_Excel5::setTempDir()
Set temporary storage directory
setTempDir: in file Worksheet.php, method PHPExcel_Writer_Excel5_Worksheet::setTempDir()
Sets the temp dir used for storing files
setTextRotation: in file Format.php, method PHPExcel_Writer_Excel5_Format::setTextRotation()
Sets the orientation of the text
setTextWrap: in file Format.php, method PHPExcel_Writer_Excel5_Format::setTextWrap()
Sets text wrapping
setTop: in file Format.php, method PHPExcel_Writer_Excel5_Format::setTop()
Sets the width for the top border of the cell
setTopColor: in file Format.php, method PHPExcel_Writer_Excel5_Format::setTopColor()
Sets the cell's top border color
setUnderline: in file Format.php, method PHPExcel_Writer_Excel5_Format::setUnderline()
Sets the underline of the text
setUnhidden: in file Format.php, method PHPExcel_Writer_Excel5_Format::setUnhidden()
Unhide a cell.
setUnLocked: in file Format.php, method PHPExcel_Writer_Excel5_Format::setUnLocked()
Unlocks a cell.
setVAlign: in file Format.php, method PHPExcel_Writer_Excel5_Format::setVAlign()
Set cell vertical alignment.
setVersion: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::setVersion()
Sets the BIFF version.
sheets: in file Workbook.php, method PHPExcel_Writer_Excel5_Workbook::sheets()
An accessor for the _worksheets[] array

Element index for package PHPExcel_Writer_Excel5

_

a

b

c

e

f

g

i

n

p

s

t

w