importXLSX Namespace Reference

Classes

class  exprNode
 
class  FormulaTranslator
 

Functions

def getText (nodelist)
 
def handleCells (cellList, actCellSheet, sList)
 
def handleStrings (theStr, sList)
 
def handleWorkBook (theBook, sheetDict, Doc)
 
def handleWorkSheet (theDom, actSheet, strList)
 
def insert (nameXLSX, docname)
 
def open (nameXLSX)
 

Variables

dictionary branchHigher = {'=':None}
 
dictionary branchLower
 
 gui
 
 pythonopen = open
 
dictionary sepToken
 
dictionary tokenDic
 
dictionary treeDict
 

Function Documentation

◆ getText()

def importXLSX.getText (   nodelist)

◆ handleCells()

def importXLSX.handleCells (   cellList,
  actCellSheet,
  sList 
)

References getText().

Referenced by handleWorkSheet().

◆ handleStrings()

def importXLSX.handleStrings (   theStr,
  sList 
)

References getText().

Referenced by insert(), and open().

◆ handleWorkBook()

def importXLSX.handleWorkBook (   theBook,
  sheetDict,
  Doc 
)

References getText().

Referenced by insert(), and open().

◆ handleWorkSheet()

def importXLSX.handleWorkSheet (   theDom,
  actSheet,
  strList 
)

References handleCells().

Referenced by insert(), and open().

◆ insert()

def importXLSX.insert (   nameXLSX,
  docname 
)

◆ open()

def importXLSX.open (   nameXLSX)

Variable Documentation

◆ branchHigher

dictionary importXLSX.branchHigher = {'=':None}

◆ branchLower

dictionary importXLSX.branchLower
Initial value:
1= {
2 '>':None,
3 '=':None
4 }

◆ gui

importXLSX.gui

◆ pythonopen

importXLSX.pythonopen = open

◆ sepToken

dictionary importXLSX.sepToken
Initial value:
1= {
2 '(':None,
3 '=':None,
4 '<':'branchLower',
5 '>':'branchHigher',
6 ')':None,
7# '"':None,
8# ';':None,
9 ' ':None,
10 ',':None, # Separator on lists
11 '!':None, #Connector to cells on other Sheets
12 '+':None,
13 '-':None,
14 '*':None,
15 '/':None,
16 '^':None
17 }

◆ tokenDic

dictionary importXLSX.tokenDic

◆ treeDict

dictionary importXLSX.treeDict
Initial value:
1= {
2 'branchLower':branchLower,
3 'branchHigher':branchHigher
4 }