[ all elements ]
Packages:
ExcelWriterXML

Index of all elements

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

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()
example.php
procedural page example.php
example2.php
procedural page example2.php
example3_db.php
procedural page example3_db.php
ExcelWriterXML
in file ExcelWriterXML.php, method ExcelWriterXML::ExcelWriterXML()
    Constructor for the ExcelWriterXML class.
ExcelWriterXML
in file ExcelWriterXML.php, class ExcelWriterXML
    Class for generating the initial Excel XML document
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
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

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 Wed, 16 Feb 2011 20:04:33 -0600 by phpDocumentor 1.4.3