[Spreadsheet_Excel_Writer] element index

Package indexes

All elements
a b c f g h i m n o p r s t v w _
_
top
Variable $_1904
Flag for 1904 date system (0 => base date is 1900, 1 => base date is 1904)
Variable $_activesheet
The active worksheet of the workbook (0 indexed)
Variable $_active_pane
The active pane for the worksheet
Variable $_bg_color
The cell's background color.
Variable $_biffsize
The BIFF file size for the workbook.
Variable $_BIFF_version
The BIFF/Excel version (5).
Variable $_BIFF_version
The BIFF version for the workbook
Variable $_blank
Variable $_bold
Bold style
Variable $_bottom
Style of the bottom border of the cell
Variable $_bottom_color
Color of the bottom border of the cell.
Variable $_byte_order
The byte order. 1 => big endian, 0 => little endian.
Variable $_byte_order
The byte order of this architecture. 0 => little endian, 1 => big endian
Variable $_codepage
The codepage indicates the text encoding used for strings
Variable $_colinfo
Array containing format information for columns
Variable $_color
Index to the cell's color
Variable $_country_code
The country code used for localization
Variable $_current_char
The index of the character we are currently looking at
Variable $_current_token
The token we are working on.
Variable $_data
The string containing the data of the BIFF stream
Variable $_datasize
The size of the data in bytes. Should be the same as strlen($this->_data)
Variable $_descr_error
Variable $_descr_prompt
Variable $_dim_colmax
Last column for the DIMENSIONS record
Variable $_dim_colmin
First column for the DIMENSIONS record
Variable $_dim_rowmax
Last row for the DIMENSIONS record
Variable $_dim_rowmin
First row for the DIMENSIONS record
Variable $_ext_sheets
Array of external sheets
Variable $_fg_color
The cell's foreground color.
Variable $_fileclosed
Flag for preventing close from being called twice.
Variable $_filehandle
Filehandle to the temporary file for storing data
Variable $_filename
Filename for the Workbook
Variable $_firstsheet
1st displayed worksheet in the workbook (0 indexed)
Variable $_fit_height
Number of pages to fit high
Variable $_fit_page
Whether to fit to page when printing or not.
Variable $_fit_width
Number of pages to fit wide
Variable $_fixedList
Variable $_font_charset
Byte specifiying the font charset.
Variable $_font_family
Byte specifiying the font family.
Variable $_font_name
The font name (ASCII).
Variable $_font_outline
Bit specifiying if the font has outline.
Variable $_font_script
2 bytes specifiying the script type for the font.
Variable $_font_shadow
Bit specifiying if the font has shadow.
Variable $_font_strikeout
Bit specifiying if the font has strikeout.
Variable $_footer
The page footer caption
Variable $_formats
Array containing references to all of this workbook's formats
Variable $_formula
The formula to parse
Variable $_formula1
Variable $_formula2
Variable $_frozen
Bit specifying if panes are frozen
Variable $_hcenter
The horizontal centering value for the page
Variable $_header
The page header caption
Variable $_hidden
Bit specifying if formulas are hidden.
Variable $_incell
Variable $_italic
Bit specifiying if the font is italic.
Variable $_left
Style of the left border of the cell
Variable $_left_color
Color of the left border of the cell.
Variable $_limit
The maximun length for a BIFF record. See _addContinue()
Variable $_locked
Bit specifying if the cell is locked.
Variable $_lookahead
The character ahead of the current char
Variable $_margin_bottom
The bottom margin for the worksheet in inches
Variable $_margin_foot
The margin for the footer
Variable $_margin_head
The margin for the header
Variable $_margin_left
The left margin for the worksheet in inches
Variable $_margin_right
The right margin for the worksheet in inches
Variable $_margin_top
The top margin for the worksheet in inches
Variable $_merged_ranges
Merged cell ranges
Variable $_num_format
An index (2 bytes) to a FORMAT record (number format).
Variable $_operator
Variable $_orientation
Bit specifying paper orientation (for printing). 0 => landscape, 1 => portrait
Variable $_outline_below
Whether to have outline summary below.
Variable $_outline_on
Whether to use outline.
Variable $_outline_right
Whether to have outline summary at the right.
Variable $_outline_row_level
Outline row level.
Variable $_outline_style
Auto outline styles.
Variable $_palette
Array containing the colour palette
Variable $_panes
Array containing the panes for the worksheet
Variable $_paper_size
The paper size (for printing) (DOCUMENT!!!)
Variable $_parser
Formula parser
Variable $_parser
Reference to the parser used for parsing formulas
Variable $_parser
The parser from the workbook. Used to parse validation formulas also
Variable $_parse_tree
The parse tree to be generated
Variable $_pattern
The cell's background fill pattern.
Variable $_references
Array of sheet references in the form of REF structures
Variable $_right
Style of the right border of the cell
Variable $_right_color
Color of the right border of the cell.
Variable $_rotation
The two bits specifying the text rotation.
Variable $_selected
Number of workbook tabs selected
Variable $_selection
Array containing the selected area for the worksheet
Variable $_sheetname
The default sheetname for all sheets created.
Variable $_sheetnames
Array of sheetnames for creating the EXTERNSHEET records
Variable $_showerror
Variable $_showprompt
Variable $_size
Height of font (1/20 of a point)
Variable $_string_sizeinfo_size
number of bytes for sizeinfo of strings
Variable $_str_table
Reference to the array containing all the unique strings in the workbook
Variable $_str_total
Reference to the total number of strings in the workbook
Variable $_str_unique
Reference to the number of unique strings in the workbook
Variable $_style
Variable $_text_h_align
The three bits specifying the text horizontal alignment.
Variable $_text_justlast
1 bit, apparently not used.
Variable $_text_v_align
The three bits specifying the text vertical alignment.
Variable $_text_wrap
Bit specifying if the text is wrapped at the right border.
Variable $_title_error
Variable $_title_prompt
Variable $_tmp_dir
The temporary dir for storing the OLE file
Variable $_tmp_format
The default XF format.
Variable $_top
Style of the top border of the cell
Variable $_top_color
Color of the top border of the cell.
Variable $_type
Variable $_underline
The text underline property
Variable $_url_format
Reference to the (default) Format object for URLs
Variable $_url_format
The default format for URLs.
Variable $_using_tmpfile
Boolean indicating if we are using a temporary file for storing data
Variable $_vcenter
The vertical centering value for the page
Variable $_worksheets
Array containing references to all of this workbook's worksheets
Variable $_xf_index
Index for creating adding new formats to the workbook
Variable $_xf_index
The index given by the workbook when creating a new format.
Variable $_xls_colmax
Maximum number of columns for an Excel spreadsheet (BIFF5)
Variable $_xls_rowmax
Maximum number of rows for an Excel spreadsheet (BIFF5)
Variable $_xls_strmax
Maximum number of characters for a string (LABEL record in BIFF5)
Method _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.
Method _advance
Advance to the next valid token.
Method _append
Store Worksheet data in memory using the parent's class append() or to a temporary file, the default.
Method _append
General storage function
Method _calcSheetOffsets
Calculate offsets for Worksheet BOF records.
Method _calculateSharedStringsSizes
Calculate
Method _cellToPackedRowcol
pack() row and column into the required 3 or 4 byte format.
Method _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.
Method _cellToRowcol
Convert an Excel cell reference in A1 notation to a zero based row and column reference; converts C1 to (0, 2).
Method _checkRowCol
Check row and col before writing to a cell, and update the sheet's dimensions accordingly
Method _condition
It parses a condition. It assumes the following rule: Cond -> Expr [(">" | "<") Expr]
Method _convert
Convert a token to the proper ptg value.
Method _convertFunction
Convert a function to a ptgFunc or ptgFuncVarV depending on the number of args that it takes.
Method _convertNumber
Convert a number token to ptgInt or ptgNum
Method _convertRange2d
Convert an Excel range such as A1:D4 to a ptgRefV.
Method _convertRange3d
Convert an Excel 3d range such as "Sheet1!A1:D4" or "Sheet1:Sheet2!A1:D4" to a ptgArea3d.
Method _convertRef2d
Convert an Excel reference such as A1, $B2, C$3 or $D$4 to a ptgRefV.
Method _convertRef3d
Convert an Excel 3d reference such as "Sheet1!A1" or "Sheet1:Sheet2!A1" to a ptgRef3d.
Method _convertString
Convert a string token to ptgStr
Method _createTree
Creates a tree. In fact an array which may have one or two arrays (sub-trees) as elements.
Method _encodePassword
Based on the algorithm provided by Daniel Rentz of OpenOffice.
Method _expression
It parses a expression. It assumes the following rule:
Method _fact
It parses a factor. It assumes the following rule:
Method _func
It parses a function call. It assumes the following rule: Func -> ( Expr [,Expr]* )
Method _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.
Method _getData
Method _getOptions
Method _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.
Method _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.
Method _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.
Method _initializeHashes
Initialize the ptg and function hashes.
Method _match
Checks if it's a valid token.
Method _packExtRef
Convert the sheet name part of an external reference, for example "Sheet1" or "Sheet1:Sheet2", to a packed structure.
Method _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.
Method _positionImage
Calculate the vertices that define the position of the image as required by the OBJ record.
Method _prepend
General storage function
Method _processBitmap
Convert a 24 bit bitmap into the modified internal format used by Windows.
Method _rangeToPackedRange
pack() row range into the required 3 or 4 byte format.
Method _setByteOrder
Determine the byte order and store it as class data to avoid recalculating it for each call to new().
Method _setPaletteXl97
Sets the colour palette to the Excel 97+ default.
Method _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.
Method _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).
Method _storeAllFonts
Store the Excel FONT records.
Method _storeAllNumFormats
Store user defined numerical formats i.e. FORMAT records
Method _storeAllStyles
Write all STYLE records.
Method _storeAllXfs
Write all XF records.
Method _storeBof
Writes Excel BOF record to indicate the beginning of a stream or sub-stream in the BIFF file.
Method _storeBoundsheet
Writes Excel BIFF BOUNDSHEET record.
Method _storeCodepage
Stores the CODEPAGE biff record.
Method _storeColinfo
Write BIFF record COLINFO to define column widths
Method _storeCountry
Stores the COUNTRY record for localization
Method _storeDataValidity
Store the DVAL and DV records.
Method _storeDatemode
Write DATEMODE record to indicate the date system in use (1904 or 1900).
Method _storeDefcol
Write BIFF record DEFCOLWIDTH if COLINFO records are in use.
Method _storeDimensions
Writes Excel DIMENSIONS to define the area in which there is data.
Method _storeEof
Writes Excel EOF record to indicate the end of a BIFF stream.
Method _storeExterncount
Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet.
Method _storeExterncount
Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in the workbook.
Method _storeExterns
Write the EXTERNCOUNT and EXTERNSHEET records. These are used as indexes for the NAME records.
Method _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.
Method _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.
Method _storeExternsheetBiff8
Writes the Excel BIFF EXTERNSHEET record. These references are used by formulas.
Method _storeFooter
Store the footer caption BIFF record.
Method _storeGridset
Write the GRIDSET BIFF record. Must be used in conjunction with the PRINTGRIDLINES record.
Method _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.
Method _storeHbreak
Write the HORIZONTALPAGEBREAKS BIFF record.
Method _storeHcenter
Store the horizontal centering HCENTER BIFF record.
Method _storeHeader
Store the header caption BIFF record.
Method _storeMarginBottom
Store the BOTTOMMARGIN BIFF record.
Method _storeMarginLeft
Store the LEFTMARGIN BIFF record.
Method _storeMarginRight
Store the RIGHTMARGIN BIFF record.
Method _storeMarginTop
Store the TOPMARGIN BIFF record.
Method _storeMergedCells
Store the MERGEDCELLS record for all ranges of merged cells
Method _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.
Method _storeNames
Write the NAME record to define the print area and the repeat rows and cols.
Method _storeNameShort
Store the NAME record in the short format that is used for storing the print area, repeat rows only and repeat columns only.
Method _storeNumFormat
Writes Excel FORMAT record for non "built-in" numerical formats.
Method _storeObjPicture
Store the OBJ record that precedes an IMDATA record. This could be generalise to support other Excel objects.
Method _storeOLEFile
Store the workbook in an OLE container
Method _storePalette
Stores the PALETTE biff record.
Method _storePanes
Writes the Excel BIFF PANE record.
Method _storePassword
Write the worksheet PASSWORD record.
Method _storePrintGridlines
Write the PRINTGRIDLINES BIFF record. Must be used in conjunction with the GRIDSET record.
Method _storePrintHeaders
Write the PRINTHEADERS BIFF record.
Method _storeProtect
Set the Biff PROTECT record to indicate that the worksheet is protected.
Method _storeSelection
Write BIFF record SELECTION.
Method _storeSetup
Store the page setup SETUP BIFF record.
Method _storeSharedStringsTable
Write all of the workbooks strings into an indexed array.
Method _storeStyle
Write Excel BIFF STYLE records.
Method _storeSupbookInternal
Write Internal SUPBOOK record
Method _storeVbreak
Write the VERTICALPAGEBREAKS BIFF record.
Method _storeVcenter
Store the vertical centering VCENTER BIFF record.
Method _storeWindow1
Write Excel BIFF WINDOW1 record.
Method _storeWindow2
Write BIFF record Window2.
Method _storeWorkbook
Assemble worksheets into a workbook and send the BIFF data to an OLE storage.
Method _storeWsbool
Write the WSBOOL BIFF record, mainly for fit-to-page. Used in conjunction with the SETUP record.
Method _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.
Method _substituteCellref
Substitute an Excel cell reference in A1 notation for zero based row and column values in an argument list.
Method _term
It parses a term. It assumes the following rule: Term -> Fact [("*" | "/") Fact]
Method _writeUrlExternal
Write links to external directory names such as 'c:\foo.xls', c:\foo.xls#Sheet1!A1', '../../foo.xls'. and '../../foo.xls#Sheet1!A1'.
Method _writeUrlInternal
Used to write internal reference hyperlinks such as "Sheet1!A1".
Method _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').
Method _writeUrlWeb
Used to write http, ftp and mailto hyperlinks.
Method _XF
Returns an index to the XF record in the workbook
a
top
Method activate
Set this worksheet as the active worksheet, i.e. the worksheet that is displayed when the workbook is opened.
Method addFormat
Add a new format to the Excel workbook.
Method addValidator
Create new validator.
Method addWorksheet
Add a new worksheet to the Excel workbook.
Method allowBlank
b
top
Page BIFFwriter.php
BIFFwriter.php in BIFFwriter.php
c
top
Method centerHorizontally
Center the page horinzontally.
Method centerVertically
Center the page vertically.
Method close
Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook.
Method close
Calls finalization methods.
f
top
Variable $font_index
Index to the FONT record.
Method fitToPages
Set the vertical and horizontal number of pages that will define the maximum area printed.
Method freezePanes
Set panes and mark them as frozen.
Page Format.php
Format.php in Format.php
g
top
Method getData
Retrieves data from memory in one chunk, or from disk in $buffer sized chunks.
Method getFont
Generate an Excel BIFF FONT record.
Method getFontKey
Returns a unique hash key for a font.
Method getName
Retrieve the worksheet name.
Method getXf
Generate an Excel BIFF XF record (style or cell).
Method getXfIndex
Returns the index used by Spreadsheet_Excel_Writer_Worksheet::_XF()
h
top
Method hideGridlines
Set the option to hide gridlines on the printed page.
Method hideScreenGridlines
Set the option to hide gridlines on the worksheet (as seen on the screen).
i
top
Variable $index
Index for the Worksheet
Method insertBitmap
Insert a 24bit bitmap image in a worksheet.
m
top
Method mergeCells
Merges the area given by its arguments.
n
top
Variable $name
Name of the Worksheet
o
top
Method onInvalidInfo
Method onInvalidStop
Method onInvalidWarn
Constant OP_BETWEEN
OP_BETWEEN in Validator.php
Constant OP_EQUAL
OP_EQUAL in Validator.php
Constant OP_GT
OP_GT in Validator.php
Constant OP_GTE
OP_GTE in Validator.php
Constant OP_LT
OP_LT in Validator.php
Constant OP_LTE
OP_LTE in Validator.php
Constant OP_NOTBETWEEN
OP_NOTBETWEEN in Validator.php
Constant OP_NOTEQUAL
OP_NOTEQUAL in Validator.php
p
top
Variable $print_colmax
Last column of the area to print
Variable $print_colmin
First column of the area to print
Variable $print_rowmax
Last row to of the area to print
Variable $print_rowmin
First row of the area to print
Page Parser.php
Parser.php in Parser.php
Method parse
The parsing method. It parses a formula.
Method printArea
Set the area of each worksheet that will be printed.
Method printRowColHeaders
Set the option to print the row and column headers on the printed page.
Method protect
Set the worksheet protection flag to prevent accidental modification and to hide formulas if the locked and hidden format properties have been set.
r
top
Method repeatColumns
Set the columns to repeat at the left hand side of each printed page.
Method repeatRows
Set the rows to repeat at the top of each printed page.
Method rowcolToCell
Utility function for writing formulas Converts a cell's coordinates to the A1 format.
s
top
Variable $selected
Bit specifying if the worksheet is selected
Method select
Set this worksheet as a selected worksheet, i.e. the worksheet has its tab highlighted.
Method send
Send HTTP headers for the Excel file.
Method setAlign
Set cell alignment.
Method setBgColor
Sets the cell's background color
Method setBold
Sets the boldness of the text.
Method setBorder
Set cells borders to the same style
Method setBorderColor
Sets all the cell's borders to the same color
Method setBottom
Sets the width for the bottom border of the cell
Method setBottomColor
Sets the cell's bottom border color
Method setColor
Sets the cell's color
Method setColumn
Set the width of a single column or a range of columns.
Method setCountry
Set the country identifier for the workbook
Method setCustomColor
Change the RGB components of the elements in the colour palette.
Method setError
Method 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.
Method setFgColor
Sets the cell's foreground color
Method setFirstSheet
Set this worksheet as the first visible sheet.
Method setFontFamily
Sets the font family name.
Method setFooter
Set the page footer caption and optional margin.
Method setFormula1
Method setFormula2
Method setHeader
Set the page header caption and optional margin.
Method setHPagebreaks
Store the horizontal page breaks on a worksheet (for printing).
Method setItalic
Sets the font style as italic
Method setLandscape
Set the page orientation as landscape.
Method setLeft
Sets the width for the left border of the cell
Method setLeftColor
Sets the cell's left border color
Method setLocked
Locks a cell.
Method setMarginBottom
Set the bottom margin in inches.
Method setMarginLeft
Set the left margin in inches.
Method setMarginRight
Set the right margin in inches.
Method setMargins
Set all the page margins to the same value in inches.
Method setMargins_LR
Set the left and right margins to the same value in inches.
Method setMargins_TB
Set the top and bottom margins to the same value in inches.
Method setMarginTop
Set the top margin in inches.
Method setMerge
Sets a merged cell range
Method setMerge
This is an alias for the unintuitive setAlign('merge')
Method setNumFormat
Sets the numeric format.
Method setOutLine
Sets outlining for a font.
Method setOutline
This method sets the properties for outlining and grouping. The defaults correspond to Excel's defaults.
Method setPaper
Set the paper type. Ex. 1 = US Letter, 9 = A4
Method setPattern
Sets the fill pattern attribute of a cell
Method setPortrait
Set the page orientation as portrait.
Method setPrintScale
Set the scale factor for the printed page.
Method setPrompt
Method setRight
Sets the width for the right border of the cell
Method setRightColor
Sets the cell's right border color
Method setRow
This method is used to set the height and format for a row.
Method setScript
Sets the script type of the text
Method setSelection
Set which cell or cells are selected in a worksheet
Method setShadow
Sets font as shadow.
Method setSize
Sets the font size
Method setStrikeOut
Sets font as strikeout.
Method setTempDir
Sets the temp dir used for storing the OLE file
Method setTextRotation
Sets the orientation of the text
Method setTextWrap
Sets text wrapping
Method setTop
Sets the width for the top border of the cell
Method setTopColor
Sets the cell's top border color
Method setUnderline
Sets the underline of the text
Method setUnLocked
Unlocks a cell. Useful for unprotecting particular cells of a protected sheet.
Method setValidation
FIXME: add comments
Method setVersion
Sets the BIFF version.
Method setVPagebreaks
Store the vertical page breaks on a worksheet (for printing).
Method setZoom
Set the worksheet zoom factor.
Method sheets
An accessor for the _worksheets[] array Returns an array of the worksheet objects in a workbook It actually calls to worksheets()
Method Spreadsheet_Excel_Writer
The constructor. It just creates a Workbook
Class Spreadsheet_Excel_Writer
Class for writing Excel Spreadsheets. This class should change COMPLETELY.
Constant SPREADSHEET_EXCEL_WRITER_ADD
Method Spreadsheet_Excel_Writer_BIFFwriter
Constructor
Class Spreadsheet_Excel_Writer_BIFFwriter
Class for writing Excel BIFF records.
Constant SPREADSHEET_EXCEL_WRITER_CLOSE
Constant SPREADSHEET_EXCEL_WRITER_COMA
Constant SPREADSHEET_EXCEL_WRITER_DIV
Constant SPREADSHEET_EXCEL_WRITER_EQ
Class Spreadsheet_Excel_Writer_Format
Class for generating Excel XF records (formats)
Method Spreadsheet_Excel_Writer_Format
Constructor
Constant SPREADSHEET_EXCEL_WRITER_GE
Constant SPREADSHEET_EXCEL_WRITER_GT
Constant SPREADSHEET_EXCEL_WRITER_LE
Constant SPREADSHEET_EXCEL_WRITER_LT
Constant SPREADSHEET_EXCEL_WRITER_MUL
Constant SPREADSHEET_EXCEL_WRITER_NE
Constant SPREADSHEET_EXCEL_WRITER_OPEN
Class Spreadsheet_Excel_Writer_Parser
Class for parsing Excel formulas
Method Spreadsheet_Excel_Writer_Parser
The class constructor
Constant SPREADSHEET_EXCEL_WRITER_SEMICOLON
Constant SPREADSHEET_EXCEL_WRITER_SUB
Class Spreadsheet_Excel_Writer_Validator
Baseclass for generating Excel DV records (validations)
Method Spreadsheet_Excel_Writer_Validator
Class Spreadsheet_Excel_Writer_Workbook
Class for generating Excel Spreadsheets
Method Spreadsheet_Excel_Writer_Workbook
Class constructor
Class Spreadsheet_Excel_Writer_Worksheet
Class for generating Excel Spreadsheets
Method Spreadsheet_Excel_Writer_Worksheet
Constructor
t
top
Variable $title_colmin
First column to reapeat on each printed page
Variable $title_rowmax
Last row to reapeat on each printed page
Variable $title_rowmin
First row to reapeat on each printed page
Method thawPanes
Set panes and mark them as unfrozen.
Method toReversePolish
Builds a string containing the tree in reverse polish notation (What you would use in a HP calculator stack).
v
top
Page Validator.php
Validator.php in Validator.php
w
top
Page Writer.php
Writer.php in Writer.php
Page Workbook.php
Workbook.php in Workbook.php
Page Worksheet.php
Worksheet.php in Worksheet.php
Method worksheets
An accessor for the _worksheets[] array.
Method write
Map to the appropriate write method acording to the token recieved.
Method writeBlank
Write a blank cell to the specified row and column (zero indexed).
Method writeCol
Write an array of values as a column
Method writeFormula
Write a formula to the specified row and column (zero indexed).
Method writeNote
Writes a note associated with the cell given by the row and column.
Method writeNumber
Write a double to the specified row and column (zero indexed).
Method writeRow
Write an array of values as a row
Method writeString
Write a string to the specified row and column (zero indexed).
Method writeStringBIFF8
Method writeUrl
Write a hyperlink.
a b c f g h i m n o p r s t v w _