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.3/Spreadsheet/Excel/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 110]
Class for parsing Excel formulas


[ Top ]


Method Detail

Spreadsheet_Excel_Writer_Parser (Constructor)   [line 172]

Spreadsheet_Excel_Writer_Parser Spreadsheet_Excel_Writer_Parser( integer $byte_order, $biff_version)

The class constructor

Parameters:

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

[ Top ]

parse   [line 1289]

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 984]

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 1643]

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 Mon, 11 Mar 2019 15:47:14 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.