Class: LXL::Parser

Inherits:

Object

• Object
• LXL::Parser

Defined in:

lib/lxl.rb

Overview

Lexical Types

;  Statement separator
,  Argument separator
=  Formula prefix
(  Tuple open
)  Tuple close
w  Whitespace
o  Operator
s  String
r  Range
p  Percentage
f  Float
i  Integer
u  Unknown

F Function
C Constant

Constant Summary

RUBY_OPERATORS =

['+', '-', '*', '/', '<=', '>=', '==', '!=', '<', '>', '+', '**']

EXCEL_OPERATORS =

['+', '-', '*', '/', '<=', '>=', '=',  '<>', '<', '>', '&', '^' ]

Class Method Summary

• .eval(formula) ⇒ Object

  Evaluate a formula.

• .lexer_class ⇒ Object

  Default lexer class.

• .namespace_class ⇒ Object

  Default namespace class.

• .range_class ⇒ Object

  Default range class.

• .token_class ⇒ Object

  Default token class.

Instance Method Summary

• #eval(string) ⇒ Object

  Evaluate a formula.

• #initialize(options = Hash.new) ⇒ Parser constructor

  Initialize namespace and lexer.

Constructor Details

#initialize(options = Hash.new) ⇒ Parser

Initialize namespace and lexer.

# File 'lib/lxl.rb', line 244

def initialize(options=Hash.new)
  @namespace = options[:namespace] if options.key?(:namespace)
  @namespace ||= self.class.namespace_class.new
  ops = EXCEL_OPERATORS.collect { |v| Regexp.quote(v) }.join('|')
  xlr = LXL::Range::EXCEL_RANGE
  @lexer = self.class.lexer_class.new([
    [/\A;+/, ?;],              # Statement separator
    [/\A,+/, ?,],              # Argument separator
    [/\A`=/, ?=],              # Formula prefix
    [/\A\(/, ?(],              # Tuple open
    [/\A\)/, ?)],              # Tuple close
    [/\A\s+/, ?w],             # Whitespace
    [/\A(#{ops})/, ?o],        # Operator
    [/\A("([^"]|"")*")/m, ?s], # String
    [xlr, ?r],                 # Range
    [/\A\d+(\.\d+)?%/, ?p],    # Percentage
    [/\A\d+\.\d+/, ?f],        # Float
    [/\A\d+/, ?i],             # Integer
    [/\A\w+/, ?u],             # Unknown
  ])
end

Class Method Details

.eval(formula) ⇒ Object

Evaluate a formula.

# File 'lib/lxl.rb', line 214

def self.eval(formula)
  self.new.eval(formula)
end

.lexer_class ⇒ Object

Default lexer class.

# File 'lib/lxl.rb', line 226

def self.lexer_class
  LXL::Lexer
end

.namespace_class ⇒ Object

Default namespace class.

# File 'lib/lxl.rb', line 232

def self.namespace_class
  LXL::Namespace
end

.range_class ⇒ Object

Default range class.

# File 'lib/lxl.rb', line 238

def self.range_class
  LXL::Range
end

.token_class ⇒ Object

Default token class.

# File 'lib/lxl.rb', line 220

def self.token_class
  LXL::Token
end

Instance Method Details

#eval(string) ⇒ Object

Evaluate a formula.

# File 'lib/lxl.rb', line 268

def eval(string)
  formulas = tokenize(string)
  formulas.collect! { |f| f.collect { |t| t.value }.join }
  formulas.collect! { |f| Kernel.eval(f, binding) }
  formulas.size == 1 ? formulas.first : formulas
end