ExcelWriterXML
[ class tree: ExcelWriterXML ] [ index: ExcelWriterXML ] [ all elements ]
Packages:
ExcelWriterXML


Files:
ExcelWriterXML.php
ExcelWriterXML_Sheet.php
ExcelWriterXML_Style.php
index.php

subpackage examples
example.php
example2.php
example3_db.php

Classes:
ExcelWriterXML
ExcelWriterXML_Sheet
ExcelWriterXML_Style

Element index for package ExcelWriterXML

[ a ] [ b ] [ c ] [ d ] [ e ] [ f ] [ g ] [ i ] [ m ] [ n ] [ o ] [ r ] [ s ] [ w ]

a

addComment
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::addComment()
    Adds a comment to a cell
addError
in file ExcelWriterXML.php, method ExcelWriterXML::addError()
    Adds a format error. When the document is generated if there are any errors they will be listed on a seperate sheet.
addError
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::addError()
    Adds a format error. When the document is generated if there are any errors they will be listed on a seperate sheet.
addSheet
in file ExcelWriterXML.php, method ExcelWriterXML::addSheet()
    Creates a new sheet within the spreadsheet At least one sheet is required.
addStyle
in file ExcelWriterXML.php, method ExcelWriterXML::addStyle()
    Creates a new style within the spreadsheet.
addURL
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::addURL()
    Makes the target cell a link to a URL
alignHorizontal
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::alignHorizontal()
    Changes the horizontal alignment setting for the style
alignRotate
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::alignRotate()
    Changes the rotation setting for the style
alignShrinktofit
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::alignShrinktofit()
    Changes the Shrink To Fit setting for the style ShrinkToFit shrinks the text so that it fits within the cell.
alignVertical
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::alignVertical()
    Changes the vertical alignment setting for the style
alignVerticaltext
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::alignVerticaltext()
    Changes the Vertical Text setting for the style.
alignWraptext
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::alignWraptext()
    Changes the Wrap Text setting for the style.
top

b

bgColor
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::bgColor()
    Sets the background style of a style
bgPattern
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::bgPattern()
    Sets the background pattern of a style.
bgPatternColor
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::bgPatternColor()
    Specifies the secondary fill color of the cell when Pattern does not equal Solid.
border
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::border()
    Sets the border for the named style.
top

c

cellHeight
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::cellHeight()
    Alias for function rowHeight()
cellMerge
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::cellMerge()
    Merges 2 or more cells.
cellWidth
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::cellWidth()
    Alias for function columnWidth()
checkColor
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::checkColor()
    Checks whether a color is valid for the spreadsheet
checkStyleID
in file ExcelWriterXML.php, method ExcelWriterXML::checkStyleID()
    Checks whether a proposed Style ID has already been used
columnWidth
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::columnWidth()
    Sets the width of a cell.
convertMysqlDate
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::convertMysqlDate()
    Converts a MySQL type date field to a value that can be used within Excel If the passed value is not valid then the passed string is sent back.
convertMysqlDatetime
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::convertMysqlDatetime()
    Converts a MySQL type datetime field to a value that can be used within Excel.
convertMysqlTime
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::convertMysqlTime()
    Converts a MySQL type time field to a value that can be used within Excel If the passed value is not valid then the passed string is sent back.
top

d

displayRightToLeft
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::displayRightToLeft()
    Displays the sheet in Right to Left format
docAuthor
in file ExcelWriterXML.php, method ExcelWriterXML::docAuthor()
    Sets the Author of the document
docCompany
in file ExcelWriterXML.php, method ExcelWriterXML::docCompany()
    Sets the Company of the document
docManager
in file ExcelWriterXML.php, method ExcelWriterXML::docManager()
    Sets the Manager of the document
docSubject
in file ExcelWriterXML.php, method ExcelWriterXML::docSubject()
    Sets the Subject of the document
docTitle
in file ExcelWriterXML.php, method ExcelWriterXML::docTitle()
    Sets the Title of the document
top

e

EWXcheckDriverDB
in file ExcelWriterXML.php, function EWXcheckDriverDB()
EWXcreateStylesDB
in file ExcelWriterXML.php, function EWXcreateStylesDB()
EWXmysqlGenerateByQuery
in file ExcelWriterXML.php, function EWXmysqlGenerateByQuery()
ExcelWriterXML
in file ExcelWriterXML.php, class ExcelWriterXML
    Class for generating the initial Excel XML document
ExcelWriterXML
in file ExcelWriterXML.php, method ExcelWriterXML::ExcelWriterXML()
    Constructor for the ExcelWriterXML class.
ExcelWriterXML.php
procedural page ExcelWriterXML.php
ExcelWriterXML_Sheet
in file ExcelWriterXML_Sheet.php, class ExcelWriterXML_Sheet
    Class for generating sheets within the Excel document
ExcelWriterXML_Sheet
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::ExcelWriterXML_Sheet()
    Constructor for a new Sheet
ExcelWriterXML_Sheet.php
procedural page ExcelWriterXML_Sheet.php
ExcelWriterXML_Style
in file ExcelWriterXML_Style.php, class ExcelWriterXML_Style
    Style class for generating Excel styles
ExcelWriterXML_Style
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::ExcelWriterXML_Style()
    Constructor for a style
ExcelWriterXML_Style.php
procedural page ExcelWriterXML_Style.php
example.php
procedural page example.php
example2.php
procedural page example2.php
example3_db.php
procedural page example3_db.php
top

f

$formatErrors
in file ExcelWriterXML_Sheet.php, variable ExcelWriterXML_Sheet::$formatErrors
$formatErrors
in file ExcelWriterXML.php, variable ExcelWriterXML::$formatErrors
fontBold
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontBold()
    Makes the font bold for the named style
fontColor
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontColor()
    Changes the color for the font
fontFamily
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontFamily()
    Changes the family for the font
fontItalic
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontItalic()
    Makes the font italic for the named style
fontName
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontName()
    Changes the font for the cell
fontOutline
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontOutline()
    Makes the font outlines for the named style
fontShadow
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontShadow()
    Makes the font shadowed for the named style
fontSize
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontSize()
    Changes the size of the font
fontStrikethrough
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontStrikethrough()
    Makes the font strikethrough for the named style
fontUnderline
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::fontUnderline()
    Makes the font underlined for the named style
top

g

getDefaultStyle
in file ExcelWriterXML.php, method ExcelWriterXML::getDefaultStyle()
    Gets the default style that was created by the contructor.
getErrors
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::getErrors()
    Returns any errors found in the sheet
getErrors
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::getErrors()
    Returns any errors found in the sheet
getID
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::getID()
    Function to get the named value of the Sheet
getID
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::getID()
    Returns the named style for this style
getSheetXML
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::getSheetXML()
    Called by the ExcelWriterXML class to get the XML data for this object
getStyleXML
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::getStyleXML()
    Retrieves the XML string data for a style.
top

i

index.php
procedural page index.php
top

m

mysqlQueryToTable
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::mysqlQueryToTable()
    Outputs a MYSQL table or list of tables to an Excel doc
mysqlTableDump
in file ExcelWriterXML.php, method ExcelWriterXML::mysqlTableDump()
    Outputs a MYSQL table or list of tables to an Excel doc
top

n

name
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::name()
    Changes the name of the named style
numberFormat
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::numberFormat()
    Sets the number format of a style
numberFormatDate
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::numberFormatDate()
    Sets a default date format for a style
numberFormatDatetime
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::numberFormatDatetime()
    Sets a default date and time format for a style
numberFormatTime
in file ExcelWriterXML_Style.php, method ExcelWriterXML_Style::numberFormatTime()
    Sets a default time format for a style
top

o

overwriteFile
in file ExcelWriterXML.php, method ExcelWriterXML::overwriteFile()
    Whether or not to overwrite a file (when writing to disk)
top

r

rowHeight
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::rowHeight()
    Sets the height of a cell.
top

s

sendHeaders
in file ExcelWriterXML.php, method ExcelWriterXML::sendHeaders()
    Sends the HTML headers to the client.
showErrorSheet
in file ExcelWriterXML.php, method ExcelWriterXML::showErrorSheet()
    Whether or not to show the sheet containing the Formatting Errors
top

w

writeData
in file ExcelWriterXML.php, method ExcelWriterXML::writeData()
    Writes the XML data
writeDateTime
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::writeDateTime()
    Writes a Date/Time to a cell.
writeFormula
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::writeFormula()
    Writes a formula to a cell
writeNumber
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::writeNumber()
    Writes a number to a cell.
writeString
in file ExcelWriterXML_Sheet.php, method ExcelWriterXML_Sheet::writeString()
    Writes a string to a cell
top
Documentation generated on Thu, 25 Feb 2010 16:36:53 -0600 by phpDocumentor 1.4.1