Package parasol :: Module xlChFormula :: Class xlChFormula
[hide private]
[frames] | no frames]

Class xlChFormula

source code

excel spreadsheet chart formulas for XY Series

Instance Methods [hide private]
 
setLabel(self, col=1, row=1, Sheet='') source code
 
setXColumn(self, col=1, topRow=2, botRow=100, Sheet='') source code
 
setValueColumn(self, col=1, topRow=2, botRow=100, Sheet='') source code
 
splitIntoParts(self)
from self.formula, split into individual parts
source code
 
excelColLetter(self, NColumn=1)
return the letter representation of excel columns
source code
 
makeColLocation(self, NColumn=1, NRow=1) source code
 
makeColRange(self, NColumn=1, fromRow=1, toRow=10) source code
 
makeRange(self, fromColumn=1, fromRow=1, toColumn=2, toRow=10) source code
 
getFormula(self) source code
 
setFormula(self, strForm='=SERIES(Sheet1!$C$1,Sheet1!$A$2:$A$102,Sheet1!$C$2:$C$102,1)') source code
 
__init__(self, strForm='=SERIES(Sheet1!$C$1,Sheet1!$A$2:$A$102,Sheet1!$C$2:$C$102,1)') source code