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

Class: Spreadsheet_Excel_Writer_Parser

Source Location: /Spreadsheet_Excel_Writer-0.9.1/Writer/Parser.php

Class Overview

PEAR
   |
   --Spreadsheet_Excel_Writer_Parser

Class for parsing Excel formulas


Author(s):

Methods


Inherited Variables

Inherited Methods


Class Details

[line 106]
Class for parsing Excel formulas


[ Top ]


Method Detail

Spreadsheet_Excel_Writer_Parser (Constructor)   [line 168]

Spreadsheet_Excel_Writer_Parser Spreadsheet_Excel_Writer_Parser( integer $byte_order, mixed $biff_version)

The class constructor

Parameters:

integer   $byte_order     The byte order (Little endian or Big endian) of the architecture

[ Top ]

parse   [line 1282]

mixed parse( string $formula)

The parsing method. It parses a formula.
  • Return: true on success, PEAR_Error on failure
  • Access: public

Parameters:

string   $formula     The formula to parse, without the initial equal sign (=).

[ Top ]

setExtSheet   [line 980]

void setExtSheet( string $name, integer $index)

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.

Parameters:

string   $name     The name of the worksheet being added
integer   $index     The index of the worksheet being added

[ Top ]

toReversePolish   [line 1629]

string toReversePolish( [array $tree = array()])

Builds a string containing the tree in reverse polish notation (What you would use in a HP calculator stack).

The following tree:

+ / \ 2 3

produces: "23+"

The following tree:

+ / \ 3 * / \ 6 A1

produces: "36A1*+"

In fact all operands, functions, references, etc... are written as ptg's

  • Return: The tree in reverse polish notation
  • Access: public

Parameters:

array   $tree     The optional tree to convert.

[ Top ]


Documentation generated on Tue, 26 Sep 2006 14:33:16 -0400 by phpDocumentor 1.2.3. PEAR Logo Copyright © PHP Group 2004.