Spreadsheet_Excel_Writer
[ class tree: Spreadsheet_Excel_Writer ] [ index: Spreadsheet_Excel_Writer ] [ all elements ]
Packages:
Spreadsheet_Excel_Writer
apidoc


Classes:
Spreadsheet_Excel_Writer
Spreadsheet_Excel_Writer_BIFFwriter
Spreadsheet_Excel_Writer_Format
Spreadsheet_Excel_Writer_Parser
Spreadsheet_Excel_Writer_Validator
Spreadsheet_Excel_Writer_Workbook
Spreadsheet_Excel_Writer_Worksheet
Files:
BIFFwriter.php
Format.php
Validator.php
Workbook.php
Worksheet.php
Writer.php

Element index for package Spreadsheet_Excel_Writer

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

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
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 Format.php, method Spreadsheet_Excel_Writer_Format::setMerge()
    This is an alias for the unintuitive setAlign('merge')
setMerge
in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setMerge()
    Sets a merged cell range
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.
setRTL
in file Worksheet.php, method Spreadsheet_Excel_Writer_Worksheet::setRTL()
    This method sets the worksheet direction to right-to-left (RTL)
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 BIFFwriter.php, method Spreadsheet_Excel_Writer_BIFFwriter::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, class Spreadsheet_Excel_Writer
    Class for writing Excel Spreadsheets. This class should change COMPLETELY.
Spreadsheet_Excel_Writer
in file Writer.php, method Spreadsheet_Excel_Writer::Spreadsheet_Excel_Writer()
    The constructor. It just creates a Workbook
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_Format
in file Format.php, class Spreadsheet_Excel_Writer_Format
    Class for generating Excel XF records (formats)
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_Validator
in file Validator.php, method Spreadsheet_Excel_Writer_Validator::Spreadsheet_Excel_Writer_Validator()
Spreadsheet_Excel_Writer_Validator
in file Validator.php, class Spreadsheet_Excel_Writer_Validator
    Baseclass for generating Excel DV records (validations)
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
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 Mon, 11 Mar 2019 15:47:13 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.