Element index for package Spreadsheet_Excel_Writer

[ a ] [ b ] [ c ] [ f ] [ g ] [ h ] [ i ] [ m ] [ n ] [ o ] [ p ] [ r ] [ s ] [ t ] [ v ] [ w ] [ _ ]

_

$_1904: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_1904
Flag for 1904 date system (0 => base date is 1900, 1 => base date is 1904)
$_activesheet: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_activesheet
The active worksheet of the workbook (0 indexed)
$_active_pane: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_active_pane
The active pane for the worksheet
$_bg_color: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_bg_color
The cell's background color.
$_biffsize: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_biffsize
The BIFF file size for the workbook.
$_BIFF_version: in file Parser.php, variable Spreadsheet_Excel_Writer_Parser::$_BIFF_version
The BIFF version for the workbook
$_BIFF_version: in file BIFFwriter.php, variable Spreadsheet_Excel_Writer_BIFFwriter::$_BIFF_version
The BIFF/Excel version (5).
$_blank: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_blank
$_bold: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_bold
Bold style
$_bottom: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_bottom
Style of the bottom border of the cell
$_bottom_color: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_bottom_color
Color of the bottom border of the cell.
$_byte_order: in file Parser.php, variable Spreadsheet_Excel_Writer_Parser::$_byte_order
The byte order. 1 => big endian, 0 => little endian.
$_byte_order: in file BIFFwriter.php, variable Spreadsheet_Excel_Writer_BIFFwriter::$_byte_order
The byte order of this architecture. 0 => little endian, 1 => big endian
$_codepage: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_codepage
The codepage indicates the text encoding used for strings
$_colinfo: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_colinfo
Array containing format information for columns
$_color: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_color
Index to the cell's color
$_country_code: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_country_code
The country code used for localization
$_current_char: in file Parser.php, variable Spreadsheet_Excel_Writer_Parser::$_current_char
The index of the character we are currently looking at
$_current_token: in file Parser.php, variable Spreadsheet_Excel_Writer_Parser::$_current_token
The token we are working on.
$_data: in file BIFFwriter.php, variable Spreadsheet_Excel_Writer_BIFFwriter::$_data
The string containing the data of the BIFF stream
$_datasize: in file BIFFwriter.php, variable Spreadsheet_Excel_Writer_BIFFwriter::$_datasize
The size of the data in bytes. Should be the same as strlen($this->_data)
$_descr_error: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_descr_error
$_descr_prompt: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_descr_prompt
$_dim_colmax: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_dim_colmax
Last column for the DIMENSIONS record
$_dim_colmin: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_dim_colmin
First column for the DIMENSIONS record
$_dim_rowmax: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_dim_rowmax
Last row for the DIMENSIONS record
$_dim_rowmin: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_dim_rowmin
First row for the DIMENSIONS record
$_ext_sheets: in file Parser.php, variable Spreadsheet_Excel_Writer_Parser::$_ext_sheets
Array of external sheets
$_fg_color: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_fg_color
The cell's foreground color.
$_fileclosed: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_fileclosed
Flag for preventing close from being called twice.
$_filehandle: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_filehandle
Filehandle to the temporary file for storing data
$_filename: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_filename
Filename for the Workbook
$_firstsheet: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_firstsheet
1st displayed worksheet in the workbook (0 indexed)
$_fit_height: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_fit_height
Number of pages to fit high
$_fit_page: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_fit_page
Whether to fit to page when printing or not.
$_fit_width: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_fit_width
Number of pages to fit wide
$_fixedList: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_fixedList
$_font_charset: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_font_charset
Byte specifiying the font charset.
$_font_family: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_font_family
Byte specifiying the font family.
$_font_name: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_font_name
The font name (ASCII).
$_font_outline: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_font_outline
Bit specifiying if the font has outline.
$_font_script: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_font_script
2 bytes specifiying the script type for the font.
$_font_shadow: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_font_shadow
Bit specifiying if the font has shadow.
$_font_strikeout: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_font_strikeout
Bit specifiying if the font has strikeout.
$_footer: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_footer
The page footer caption
$_formats: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_formats
Array containing references to all of this workbook's formats
$_formula: in file Parser.php, variable Spreadsheet_Excel_Writer_Parser::$_formula
The formula to parse
$_formula1: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_formula1
$_formula2: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_formula2
$_frozen: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_frozen
Bit specifying if panes are frozen
$_hcenter: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_hcenter
The horizontal centering value for the page
$_header: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_header
The page header caption
$_hidden: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_hidden
Bit specifying if formulas are hidden.
$_incell: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_incell
$_input_encoding: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_input_encoding
Charset encoding currently used when calling writeString()
$_italic: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_italic
Bit specifiying if the font is italic.
$_left: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_left
Style of the left border of the cell
$_left_color: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_left_color
Color of the left border of the cell.
$_limit: in file BIFFwriter.php, variable Spreadsheet_Excel_Writer_BIFFwriter::$_limit
The maximun length for a BIFF record. See _addContinue()
$_locked: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_locked
Bit specifying if the cell is locked.
$_lookahead: in file Parser.php, variable Spreadsheet_Excel_Writer_Parser::$_lookahead
The character ahead of the current char
$_margin_bottom: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_margin_bottom
The bottom margin for the worksheet in inches
$_margin_foot: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_margin_foot
The margin for the footer
$_margin_head: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_margin_head
The margin for the header
$_margin_left: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_margin_left
The left margin for the worksheet in inches
$_margin_right: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_margin_right
The right margin for the worksheet in inches
$_margin_top: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_margin_top
The top margin for the worksheet in inches
$_merged_ranges: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_merged_ranges
Merged cell ranges
$_num_format: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_num_format
An index (2 bytes) to a FORMAT record (number format).
$_operator: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_operator
$_orientation: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_orientation
Bit specifying paper orientation (for printing). 0 => landscape, 1 => portrait
$_outline_below: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_outline_below
Whether to have outline summary below.
$_outline_on: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_outline_on
Whether to use outline.
$_outline_right: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_outline_right
Whether to have outline summary at the right.
$_outline_row_level: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_outline_row_level
Outline row level.
$_outline_style: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_outline_style
Auto outline styles.
$_palette: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_palette
Array containing the colour palette
$_panes: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_panes
Array containing the panes for the worksheet
$_paper_size: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_paper_size
The paper size (for printing) (DOCUMENT!!!)
$_parser: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_parser
Formula parser
$_parser: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_parser
Reference to the parser used for parsing formulas
$_parser: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_parser
The parser from the workbook. Used to parse validation formulas also
$_parse_tree: in file Parser.php, variable Spreadsheet_Excel_Writer_Parser::$_parse_tree
The parse tree to be generated
$_pattern: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_pattern
The cell's background fill pattern.
$_references: in file Parser.php, variable Spreadsheet_Excel_Writer_Parser::$_references
Array of sheet references in the form of REF structures
$_right: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_right
Style of the right border of the cell
$_right_color: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_right_color
Color of the right border of the cell.
$_rotation: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_rotation
The two bits specifying the text rotation.
$_selected: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_selected
Number of workbook tabs selected
$_selection: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_selection
Array containing the selected area for the worksheet
$_sheetname: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_sheetname
The default sheetname for all sheets created.
$_sheetnames: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_sheetnames
Array of sheetnames for creating the EXTERNSHEET records
$_showerror: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_showerror
$_showprompt: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_showprompt
$_size: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_size
Height of font (1/20 of a point)
$_string_sizeinfo_size: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_string_sizeinfo_size
number of bytes for sizeinfo of strings
$_str_table: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_str_table
Reference to the array containing all the unique strings in the workbook
$_str_total: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_str_total
Reference to the total number of strings in the workbook
$_str_unique: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_str_unique
Reference to the number of unique strings in the workbook
$_style: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_style
$_text_h_align: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_text_h_align
The three bits specifying the text horizontal alignment.
$_text_justlast: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_text_justlast
1 bit, apparently not used.
$_text_v_align: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_text_v_align
The three bits specifying the text vertical alignment.
$_text_wrap: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_text_wrap
Bit specifying if the text is wrapped at the right border.
$_title_error: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_title_error
$_title_prompt: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_title_prompt
$_tmp_dir: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_tmp_dir
The temporary dir for storing the OLE file
$_tmp_format: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_tmp_format
The default XF format.
$_top: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_top
Style of the top border of the cell
$_top_color: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_top_color
Color of the top border of the cell.
$_type: in file Validator.php, variable Spreadsheet_Excel_Writer_Validator::$_type
$_underline: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_underline
The text underline property
$_url_format: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_url_format
The default format for URLs.
$_url_format: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_url_format
Reference to the (default) Format object for URLs
$_using_tmpfile: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_using_tmpfile
Boolean indicating if we are using a temporary file for storing data
$_vcenter: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_vcenter
The vertical centering value for the page
$_worksheets: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_worksheets
Array containing references to all of this workbook's worksheets
$_xf_index: in file Workbook.php, variable Spreadsheet_Excel_Writer_Workbook::$_xf_index
Index for creating adding new formats to the workbook
$_xf_index: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$_xf_index
The index given by the workbook when creating a new format.
$_xls_colmax: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_xls_colmax
Maximum number of columns for an Excel spreadsheet (BIFF5)
$_xls_rowmax: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_xls_rowmax
Maximum number of rows for an Excel spreadsheet (BIFF5)
$_xls_strmax: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$_xls_strmax
Maximum number of characters for a string (LABEL record in BIFF5)
_addContinue: in file BIFFwriter.php, method Spreadsheet_Excel_Writer_BIFFwriter::_addContinue()
Excel limits the size of BIFF records. In Excel 5 the limit is 2084 bytes. In Excel 97 the limit is 8228 bytes. Records that are longer than these limits must be split up into CONTINUE blocks.
_advance: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_advance()
Advance to the next valid token.
_append: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_append()
Store Worksheet data in memory using the parent's class append() or to a temporary file, the default.
_append: in file BIFFwriter.php, method Spreadsheet_Excel_Writer_BIFFwriter::_append()
General storage function
_calcSheetOffsets: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_calcSheetOffsets()
Calculate offsets for Worksheet BOF records.
_calculateSharedStringsSizes: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_calculateSharedStringsSizes()
Calculate
_cellToPackedRowcol: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_cellToPackedRowcol()
pack() row and column into the required 3 or 4 byte format.
_cellToRowcol: in file Parser.php, method Spreadsheet_Excel_Writer_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. Also returns two (0,1) values to indicate whether the row or column are relative references.
_cellToRowcol: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_cellToRowcol()
Convert an Excel cell reference in A1 notation to a zero based row and column reference; converts C1 to (0, 2).
_checkRowCol: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_checkRowCol()
Check row and col before writing to a cell, and update the sheet's dimensions accordingly
_condition: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_condition()
It parses a condition. It assumes the following rule: Cond -> Expr [(">" | "<") Expr]
_convert: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_convert()
Convert a token to the proper ptg value.
_convertFunction: in file Parser.php, method Spreadsheet_Excel_Writer_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 Spreadsheet_Excel_Writer_Parser::_convertNumber()
Convert a number token to ptgInt or ptgNum
_convertRange2d: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_convertRange2d()
Convert an Excel range such as A1:D4 to a ptgRefV.
_convertRange3d: in file Parser.php, method Spreadsheet_Excel_Writer_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 Spreadsheet_Excel_Writer_Parser::_convertRef2d()
Convert an Excel reference such as A1, $B2, C$3 or $D$4 to a ptgRefV.
_convertRef3d: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_convertRef3d()
Convert an Excel 3d reference such as "Sheet1!A1" or "Sheet1:Sheet2!A1" to a ptgRef3d.
_convertString: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_convertString()
Convert a string token to ptgStr
_createTree: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_createTree()
Creates a tree. In fact an array which may have one or two arrays (sub-trees) as elements.
_encodePassword: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_encodePassword()
Based on the algorithm provided by Daniel Rentz of OpenOffice.
_expression: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_expression()
It parses a expression. It assumes the following rule:
_fact: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_fact()
It parses a factor. It assumes the following rule:
_func: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_func()
It parses a function call. It assumes the following rule: Func -> ( Expr [,Expr]* )
_getColor: in file Format.php, method Spreadsheet_Excel_Writer_Format::_getColor()
Used in conjunction with the set_xxx_color methods to convert a color string into a number. Color range is 0..63 but we will restrict it to 8..63 to comply with Gnumeric. Colors 0..7 are repeated in 8..15.
_getData: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::_getData()
_getOptions: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::_getOptions()
_getRefIndex: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_getRefIndex()
Look up the REF index that corresponds to an external sheet name (or range). If it doesn't exist yet add it to the workbook's references array. It assumes all sheet names given must exist.
_getSheetIndex: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_getSheetIndex()
Look up the index that corresponds to an external sheet name. The hash of sheet names is updated by the addworksheet() method of the Spreadsheet_Excel_Writer_Workbook class.
_initialize: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_initialize()
Open a tmp file to store the majority of the Worksheet data. If this fails, for example due to write permissions, store the data in memory. This can be slow for large files.
_initializeHashes: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_initializeHashes()
Initialize the ptg and function hashes.
_match: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_match()
Checks if it's a valid token.
_packExtRef: in file Parser.php, method Spreadsheet_Excel_Writer_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 Spreadsheet_Excel_Writer_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 Spreadsheet_Excel_Writer_Worksheet::_positionImage()
Calculate the vertices that define the position of the image as required by the OBJ record.
_prepend: in file BIFFwriter.php, method Spreadsheet_Excel_Writer_BIFFwriter::_prepend()
General storage function
_processBitmap: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_processBitmap()
Convert a 24 bit bitmap into the modified internal format used by Windows.
_rangeToPackedRange: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_rangeToPackedRange()
pack() row range into the required 3 or 4 byte format.
_setByteOrder: in file BIFFwriter.php, method Spreadsheet_Excel_Writer_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 Spreadsheet_Excel_Writer_Workbook::_setPaletteXl97()
Sets the colour palette to the Excel 97+ default.
_sizeCol: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_sizeCol()
Convert the width of a cell from user's units to pixels. By interpolation the relationship is: y = 7x +5. If the width hasn't been set by the user we use the default value. If the col is hidden we use a value of zero.
_sizeRow: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_sizeRow()
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. (Not possible to hide row yet).
_storeAllFonts: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeAllFonts()
Store the Excel FONT records.
_storeAllNumFormats: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeAllNumFormats()
Store user defined numerical formats i.e. FORMAT records
_storeAllStyles: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeAllStyles()
Write all STYLE records.
_storeAllXfs: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeAllXfs()
Write all XF records.
_storeBof: in file BIFFwriter.php, method Spreadsheet_Excel_Writer_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 Spreadsheet_Excel_Writer_Workbook::_storeBoundsheet()
Writes Excel BIFF BOUNDSHEET record.
_storeCodepage: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeCodepage()
Stores the CODEPAGE biff record.
_storeColinfo: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeColinfo()
Write BIFF record COLINFO to define column widths
_storeCountry: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeCountry()
Stores the COUNTRY record for localization
_storeDataValidity: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeDataValidity()
Store the DVAL and DV records.
_storeDatemode: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeDatemode()
Write DATEMODE record to indicate the date system in use (1904 or 1900).
_storeDefcol: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeDefcol()
Write BIFF record DEFCOLWIDTH if COLINFO records are in use.
_storeDimensions: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeDimensions()
Writes Excel DIMENSIONS to define the area in which there is data.
_storeEof: in file BIFFwriter.php, method Spreadsheet_Excel_Writer_BIFFwriter::_storeEof()
Writes Excel EOF record to indicate the end of a BIFF stream.
_storeExterncount: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeExterncount()
Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet.
_storeExterncount: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeExterncount()
Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in the workbook.
_storeExterns: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeExterns()
Write the EXTERNCOUNT and EXTERNSHEET records. These are used as indexes for the NAME records.
_storeExternsheet: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeExternsheet()
Writes the Excel BIFF EXTERNSHEET record. These references are used by formulas. A formula references a sheet name via an index. Since we store a reference to all of the external worksheets the EXTERNSHEET index is the same as the worksheet index.
_storeExternsheet: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeExternsheet()
Writes the Excel BIFF EXTERNSHEET record. These references are used by formulas. NAME record is required to define the print area and the repeat rows and columns.
_storeExternsheetBiff8: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeExternsheetBiff8()
Writes the Excel BIFF EXTERNSHEET record. These references are used by formulas.
_storeFooter: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeFooter()
Store the footer caption BIFF record.
_storeGridset: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeGridset()
Write the GRIDSET BIFF record. Must be used in conjunction with the PRINTGRIDLINES record.
_storeGuts: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeGuts()
Write the GUTS BIFF record. This is used to configure the gutter margins where Excel outline symbols are displayed. The visibility of the gutters is controlled by a flag in WSBOOL.
_storeHbreak: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeHbreak()
Write the HORIZONTALPAGEBREAKS BIFF record.
_storeHcenter: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeHcenter()
Store the horizontal centering HCENTER BIFF record.
_storeHeader: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeHeader()
Store the header caption BIFF record.
_storeMarginBottom: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeMarginBottom()
Store the BOTTOMMARGIN BIFF record.
_storeMarginLeft: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeMarginLeft()
Store the LEFTMARGIN BIFF record.
_storeMarginRight: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeMarginRight()
Store the RIGHTMARGIN BIFF record.
_storeMarginTop: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeMarginTop()
Store the TOPMARGIN BIFF record.
_storeMergedCells: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeMergedCells()
Store the MERGEDCELLS record for all ranges of merged cells
_storeNameLong: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeNameLong()
Store the NAME record in the long format that is used for storing the repeat rows and columns when both are specified. This shares a lot of code with _storeNameShort() but we use a separate method to keep the code clean.
_storeNames: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeNames()
Write the NAME record to define the print area and the repeat rows and cols.
_storeNameShort: in file Workbook.php, method Spreadsheet_Excel_Writer_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 Spreadsheet_Excel_Writer_Workbook::_storeNumFormat()
Writes Excel FORMAT record for non "built-in" numerical formats.
_storeObjPicture: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeObjPicture()
Store the OBJ record that precedes an IMDATA record. This could be generalise to support other Excel objects.
_storeOLEFile: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeOLEFile()
Store the workbook in an OLE container
_storePalette: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storePalette()
Stores the PALETTE biff record.
_storePanes: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storePanes()
Writes the Excel BIFF PANE record.
_storePassword: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storePassword()
Write the worksheet PASSWORD record.
_storePrintGridlines: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storePrintGridlines()
Write the PRINTGRIDLINES BIFF record. Must be used in conjunction with the GRIDSET record.
_storePrintHeaders: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storePrintHeaders()
Write the PRINTHEADERS BIFF record.
_storeProtect: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeProtect()
Set the Biff PROTECT record to indicate that the worksheet is protected.
_storeSelection: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeSelection()
Write BIFF record SELECTION.
_storeSetup: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeSetup()
Store the page setup SETUP BIFF record.
_storeSharedStringsTable: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeSharedStringsTable()
Write all of the workbooks strings into an indexed array.
_storeStyle: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeStyle()
Write Excel BIFF STYLE records.
_storeSupbookInternal: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeSupbookInternal()
Write Internal SUPBOOK record
_storeVbreak: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeVbreak()
Write the VERTICALPAGEBREAKS BIFF record.
_storeVcenter: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeVcenter()
Store the vertical centering VCENTER BIFF record.
_storeWindow1: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeWindow1()
Write Excel BIFF WINDOW1 record.
_storeWindow2: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeWindow2()
Write BIFF record Window2.
_storeWorkbook: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::_storeWorkbook()
Assemble worksheets into a workbook and send the BIFF data to an OLE storage.
_storeWsbool: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeWsbool()
Write the WSBOOL BIFF record, mainly for fit-to-page. Used in conjunction with the SETUP record.
_storeZoom: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_storeZoom()
Store the window zoom factor. This should be a reduced fraction but for simplicity we will store all fractions with a numerator of 100.
_substituteCellref: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_substituteCellref()
Substitute an Excel cell reference in A1 notation for zero based row and column values in an argument list.
_term: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::_term()
It parses a term. It assumes the following rule: Term -> Fact [("*" | "/") Fact]
_writeUrlExternal: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_writeUrlExternal()
Write links to external directory names such as 'c:\foo.xls', c:\foo.xls#Sheet1!A1', '../../foo.xls'. and '../../foo.xls#Sheet1!A1'.
_writeUrlInternal: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_writeUrlInternal()
Used to write internal reference hyperlinks such as "Sheet1!A1".
_writeUrlRange: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_writeUrlRange()
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').
_writeUrlWeb: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_writeUrlWeb()
Used to write http, ftp and mailto hyperlinks.
_XF: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::_XF()
Returns an index to the XF record in the workbook

top

a

activate: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::activate()
Set this worksheet as the active worksheet, i.e. the worksheet that is displayed when the workbook is opened.
addFormat: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::addFormat()
Add a new format to the Excel workbook.
addValidator: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::addValidator()
Create new validator.
addWorksheet: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::addWorksheet()
Add a new worksheet to the Excel workbook.
allowBlank: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::allowBlank()

top

b

BIFFwriter.php: procedural page BIFFwriter.php

top

c

centerHorizontally: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::centerHorizontally()
Center the page horinzontally.
centerVertically: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::centerVertically()
Center the page vertically.
close: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::close()
Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook.
close: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::close()
Calls finalization methods.

top

f

$font_index: in file Format.php, variable Spreadsheet_Excel_Writer_Format::$font_index
Index to the FONT record.
fitToPages: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::fitToPages()
Set the vertical and horizontal number of pages that will define the maximum area printed.
freezePanes: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::freezePanes()
Set panes and mark them as frozen.
Format.php: procedural page Format.php

top

g

getData: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::getData()
Retrieves data from memory in one chunk, or from disk in $buffer sized chunks.
getFont: in file Format.php, method Spreadsheet_Excel_Writer_Format::getFont()
Generate an Excel BIFF FONT record.
getFontKey: in file Format.php, method Spreadsheet_Excel_Writer_Format::getFontKey()
Returns a unique hash key for a font.
getName: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::getName()
Retrieve the worksheet name.
getXf: in file Format.php, method Spreadsheet_Excel_Writer_Format::getXf()
Generate an Excel BIFF XF record (style or cell).
getXfIndex: in file Format.php, method Spreadsheet_Excel_Writer_Format::getXfIndex()
Returns the index used by Spreadsheet_Excel_Writer_Worksheet::_XF()

top

h

hideGridlines: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::hideGridlines()
Set the option to hide gridlines on the printed page.
hideScreenGridlines: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::hideScreenGridlines()
Set the option to hide gridlines on the worksheet (as seen on the screen).

top

i

$index: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$index
Index for the Worksheet
insertBitmap: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::insertBitmap()
Insert a 24bit bitmap image in a worksheet.

top

m

mergeCells: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::mergeCells()
Merges the area given by its arguments.

top

n

$name: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$name
Name of the Worksheet

top

o

onInvalidInfo: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::onInvalidInfo()
onInvalidStop: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::onInvalidStop()
onInvalidWarn: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::onInvalidWarn()
OP_BETWEEN: in file Validator.php, constant OP_BETWEEN
OP_EQUAL: in file Validator.php, constant OP_EQUAL
OP_GT: in file Validator.php, constant OP_GT
OP_GTE: in file Validator.php, constant OP_GTE
OP_LT: in file Validator.php, constant OP_LT
OP_LTE: in file Validator.php, constant OP_LTE
OP_NOTBETWEEN: in file Validator.php, constant OP_NOTBETWEEN
OP_NOTEQUAL: in file Validator.php, constant OP_NOTEQUAL

top

p

$print_colmax: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$print_colmax
Last column of the area to print
$print_colmin: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$print_colmin
First column of the area to print
$print_rowmax: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$print_rowmax
Last row to of the area to print
$print_rowmin: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$print_rowmin
First row of the area to print
Parser.php: procedural page Parser.php
parse: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::parse()
The parsing method. It parses a formula.
printArea: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::printArea()
Set the area of each worksheet that will be printed.
printRowColHeaders: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::printRowColHeaders()
Set the option to print the row and column headers on the printed page.
protect: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::protect()
Set the worksheet protection flag to prevent accidental modification and to hide formulas if the locked and hidden format properties have been set.

top

r

repeatColumns: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::repeatColumns()
Set the columns to repeat at the left hand side of each printed page.
repeatRows: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::repeatRows()
Set the rows to repeat at the top of each printed page.
rowcolToCell: in file Writer.php, method Spreadsheet_Excel_Writer::rowcolToCell()
Utility function for writing formulas Converts a cell's coordinates to the A1 format.

top

s

$selected: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$selected
Bit specifying if the worksheet is selected
select: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::select()
Set this worksheet as a selected worksheet, i.e. the worksheet has its tab highlighted.
send: in file Writer.php, method Spreadsheet_Excel_Writer::send()
Send HTTP headers for the Excel file.
setAlign: in file Format.php, method Spreadsheet_Excel_Writer_Format::setAlign()
Set cell alignment.
setBgColor: in file Format.php, method Spreadsheet_Excel_Writer_Format::setBgColor()
Sets the cell's background color
setBold: in file Format.php, method Spreadsheet_Excel_Writer_Format::setBold()
Sets the boldness of the text.
setBorder: in file Format.php, method Spreadsheet_Excel_Writer_Format::setBorder()
Set cells borders to the same style
setBorderColor: in file Format.php, method Spreadsheet_Excel_Writer_Format::setBorderColor()
Sets all the cell's borders to the same color
setBottom: in file Format.php, method Spreadsheet_Excel_Writer_Format::setBottom()
Sets the width for the bottom border of the cell
setBottomColor: in file Format.php, method Spreadsheet_Excel_Writer_Format::setBottomColor()
Sets the cell's bottom border color
setColor: in file Format.php, method Spreadsheet_Excel_Writer_Format::setColor()
Sets the cell's color
setColumn: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setColumn()
Set the width of a single column or a range of columns.
setCountry: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::setCountry()
Set the country identifier for the workbook
setCustomColor: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::setCustomColor()
Change the RGB components of the elements in the colour palette.
setError: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::setError()
setExtSheet: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::setExtSheet()
This method is used to update the array of sheet names. It is called by the addWorksheet() method of the Spreadsheet_Excel_Writer_Workbook class.
setFgColor: in file Format.php, method Spreadsheet_Excel_Writer_Format::setFgColor()
Sets the cell's foreground color
setFirstSheet: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setFirstSheet()
Set this worksheet as the first visible sheet.
setFontFamily: in file Format.php, method Spreadsheet_Excel_Writer_Format::setFontFamily()
Sets the font family name.
setFooter: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setFooter()
Set the page footer caption and optional margin.
setFormula1: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::setFormula1()
setFormula2: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::setFormula2()
setHAlign: in file Format.php, method Spreadsheet_Excel_Writer_Format::setHAlign()
Set cell horizontal alignment.
setHeader: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setHeader()
Set the page header caption and optional margin.
setHPagebreaks: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setHPagebreaks()
Store the horizontal page breaks on a worksheet (for printing).
setInputEncoding: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setInputEncoding()
Sets Input Encoding for writing strings
setItalic: in file Format.php, method Spreadsheet_Excel_Writer_Format::setItalic()
Sets the font style as italic
setLandscape: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setLandscape()
Set the page orientation as landscape.
setLeft: in file Format.php, method Spreadsheet_Excel_Writer_Format::setLeft()
Sets the width for the left border of the cell
setLeftColor: in file Format.php, method Spreadsheet_Excel_Writer_Format::setLeftColor()
Sets the cell's left border color
setLocked: in file Format.php, method Spreadsheet_Excel_Writer_Format::setLocked()
Locks a cell.
setMarginBottom: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setMarginBottom()
Set the bottom margin in inches.
setMarginLeft: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setMarginLeft()
Set the left margin in inches.
setMarginRight: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setMarginRight()
Set the right margin in inches.
setMargins: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setMargins()
Set all the page margins to the same value in inches.
setMargins_LR: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setMargins_LR()
Set the left and right margins to the same value in inches.
setMargins_TB: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setMargins_TB()
Set the top and bottom margins to the same value in inches.
setMarginTop: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setMarginTop()
Set the top margin in inches.
setMerge: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setMerge()
Sets a merged cell range
setMerge: in file Format.php, method Spreadsheet_Excel_Writer_Format::setMerge()
This is an alias for the unintuitive setAlign('merge')
setNumFormat: in file Format.php, method Spreadsheet_Excel_Writer_Format::setNumFormat()
Sets the numeric format.
setOutline: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setOutline()
This method sets the properties for outlining and grouping. The defaults correspond to Excel's defaults.
setOutLine: in file Format.php, method Spreadsheet_Excel_Writer_Format::setOutLine()
Sets outlining for a font.
setPaper: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setPaper()
Set the paper type. Ex. 1 = US Letter, 9 = A4
setPattern: in file Format.php, method Spreadsheet_Excel_Writer_Format::setPattern()
Sets the fill pattern attribute of a cell
setPortrait: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setPortrait()
Set the page orientation as portrait.
setPrintScale: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setPrintScale()
Set the scale factor for the printed page.
setPrompt: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::setPrompt()
setRight: in file Format.php, method Spreadsheet_Excel_Writer_Format::setRight()
Sets the width for the right border of the cell
setRightColor: in file Format.php, method Spreadsheet_Excel_Writer_Format::setRightColor()
Sets the cell's right border color
setRow: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setRow()
This method is used to set the height and format for a row.
setScript: in file Format.php, method Spreadsheet_Excel_Writer_Format::setScript()
Sets the script type of the text
setSelection: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setSelection()
Set which cell or cells are selected in a worksheet
setShadow: in file Format.php, method Spreadsheet_Excel_Writer_Format::setShadow()
Sets font as shadow.
setSize: in file Format.php, method Spreadsheet_Excel_Writer_Format::setSize()
Sets the font size
setStrikeOut: in file Format.php, method Spreadsheet_Excel_Writer_Format::setStrikeOut()
Sets font as strikeout.
setTempDir: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::setTempDir()
Sets the temp dir used for storing the OLE file
setTextRotation: in file Format.php, method Spreadsheet_Excel_Writer_Format::setTextRotation()
Sets the orientation of the text
setTextWrap: in file Format.php, method Spreadsheet_Excel_Writer_Format::setTextWrap()
Sets text wrapping
setTop: in file Format.php, method Spreadsheet_Excel_Writer_Format::setTop()
Sets the width for the top border of the cell
setTopColor: in file Format.php, method Spreadsheet_Excel_Writer_Format::setTopColor()
Sets the cell's top border color
setUnderline: in file Format.php, method Spreadsheet_Excel_Writer_Format::setUnderline()
Sets the underline of the text
setUnLocked: in file Format.php, method Spreadsheet_Excel_Writer_Format::setUnLocked()
Unlocks a cell. Useful for unprotecting particular cells of a protected sheet.
setValidation: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setValidation()
FIXME: add comments
setVAlign: in file Format.php, method Spreadsheet_Excel_Writer_Format::setVAlign()
Set cell vertical alignment.
setVersion: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::setVersion()
Sets the BIFF version.
setVPagebreaks: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setVPagebreaks()
Store the vertical page breaks on a worksheet (for printing).
setZoom: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setZoom()
Set the worksheet zoom factor.
sheets: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::sheets()
An accessor for the _worksheets[] array Returns an array of the worksheet objects in a workbook It actually calls to worksheets()
Spreadsheet_Excel_Writer: in file Writer.php, method Spreadsheet_Excel_Writer::Spreadsheet_Excel_Writer()
The constructor. It just creates a Workbook
Spreadsheet_Excel_Writer: in file Writer.php, class Spreadsheet_Excel_Writer
Class for writing Excel Spreadsheets. This class should change COMPLETELY.
SPREADSHEET_EXCEL_WRITER_ADD: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_ADD
Spreadsheet_Excel_Writer_BIFFwriter: in file BIFFwriter.php, method Spreadsheet_Excel_Writer_BIFFwriter::Spreadsheet_Excel_Writer_BIFFwriter()
Constructor
Spreadsheet_Excel_Writer_BIFFwriter: in file BIFFwriter.php, class Spreadsheet_Excel_Writer_BIFFwriter
Class for writing Excel BIFF records.
SPREADSHEET_EXCEL_WRITER_CLOSE: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_CLOSE
SPREADSHEET_EXCEL_WRITER_COMA: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_COMA
SPREADSHEET_EXCEL_WRITER_DIV: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_DIV
SPREADSHEET_EXCEL_WRITER_EQ: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_EQ
Spreadsheet_Excel_Writer_Format: in file Format.php, class Spreadsheet_Excel_Writer_Format
Class for generating Excel XF records (formats)
Spreadsheet_Excel_Writer_Format: in file Format.php, method Spreadsheet_Excel_Writer_Format::Spreadsheet_Excel_Writer_Format()
Constructor
SPREADSHEET_EXCEL_WRITER_GE: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_GE
SPREADSHEET_EXCEL_WRITER_GT: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_GT
SPREADSHEET_EXCEL_WRITER_LE: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_LE
SPREADSHEET_EXCEL_WRITER_LT: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_LT
SPREADSHEET_EXCEL_WRITER_MUL: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_MUL
SPREADSHEET_EXCEL_WRITER_NE: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_NE
SPREADSHEET_EXCEL_WRITER_OPEN: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_OPEN
Spreadsheet_Excel_Writer_Parser: in file Parser.php, class Spreadsheet_Excel_Writer_Parser
Class for parsing Excel formulas
Spreadsheet_Excel_Writer_Parser: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::Spreadsheet_Excel_Writer_Parser()
The class constructor
SPREADSHEET_EXCEL_WRITER_SEMICOLON: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_SEMICOLON
SPREADSHEET_EXCEL_WRITER_SUB: in file Parser.php, constant SPREADSHEET_EXCEL_WRITER_SUB
Spreadsheet_Excel_Writer_Validator: in file Validator.php, class Spreadsheet_Excel_Writer_Validator
Baseclass for generating Excel DV records (validations)
Spreadsheet_Excel_Writer_Validator: in file Validator.php, method Spreadsheet_Excel_Writer_Validator::Spreadsheet_Excel_Writer_Validator()
Spreadsheet_Excel_Writer_Workbook: in file Workbook.php, class Spreadsheet_Excel_Writer_Workbook
Class for generating Excel Spreadsheets
Spreadsheet_Excel_Writer_Workbook: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::Spreadsheet_Excel_Writer_Workbook()
Class constructor
Spreadsheet_Excel_Writer_Worksheet: in file Worksheet.php, class Spreadsheet_Excel_Writer_Worksheet
Class for generating Excel Spreadsheets
Spreadsheet_Excel_Writer_Worksheet: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::Spreadsheet_Excel_Writer_Worksheet()
Constructor

top

t

$title_colmin: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$title_colmin
First column to reapeat on each printed page
$title_rowmax: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$title_rowmax
Last row to reapeat on each printed page
$title_rowmin: in file Worksheet.php, variable Spreadsheet_Excel_Writer_Worksheet::$title_rowmin
First row to reapeat on each printed page
thawPanes: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::thawPanes()
Set panes and mark them as unfrozen.
toReversePolish: in file Parser.php, method Spreadsheet_Excel_Writer_Parser::toReversePolish()
Builds a string containing the tree in reverse polish notation (What you would use in a HP calculator stack).

top

v

Validator.php: procedural page Validator.php

top

w

Workbook.php: procedural page Workbook.php
Worksheet.php: procedural page Worksheet.php
Writer.php: procedural page Writer.php
worksheets: in file Workbook.php, method Spreadsheet_Excel_Writer_Workbook::worksheets()
An accessor for the _worksheets[] array.
write: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::write()
Map to the appropriate write method acording to the token recieved.
writeBlank: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::writeBlank()
Write a blank cell to the specified row and column (zero indexed).
writeCol: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::writeCol()
Write an array of values as a column
writeFormula: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::writeFormula()
Write a formula to the specified row and column (zero indexed).
writeNote: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::writeNote()
Writes a note associated with the cell given by the row and column.
writeNumber: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::writeNumber()
Write a double to the specified row and column (zero indexed).
writeRow: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::writeRow()
Write an array of values as a row
writeString: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::writeString()
Write a string to the specified row and column (zero indexed).
writeStringBIFF8: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::writeStringBIFF8()
Write a string to the specified row and column (zero indexed).
writeUrl: in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::writeUrl()
Write a hyperlink.

top

Documentation generated on Thu, 12 Jun 2008 12:53:00 -0500 by phpDocumentor 1.4.1