|
|
|
|
|
|
|
|
|
|
|
|
|
|
getSheetNumberFromName(self,
shtName='Sheet1')
get workbook sheet number from name |
source code
|
|
|
|
getChartSheetNumberUsingSheetData(self,
datashtName='Sheet1')
get chart sheet number which uses data from sheet name |
source code
|
|
|
|
|
|
|
| getRangeValueFromRowCol(self,
ULrow=1,
ULcol=1,
LRrow=9,
LRcol=9) |
source code
|
|
|
|
getRangeValue(self,
ULcell='$A$1',
LRcell='$D$5') |
source code
|
|
|
|
|
|
|
| getRowColCellValue(self,
NColumn=1,
NRow=1) |
source code
|
|
|
|
|
|
|
|
|
|
| addNewSeries(self,
NChart=1,
NSheet=1,
xColumn=1,
yColumn=2) |
source code
|
|
|
|
| addNewSeriesToCurrentSheetChart(self,
xColumn=1,
yColumn=2) |
source code
|
|
|
|
| changeSeriesOnChart(self,
NChart=1,
NSeries=1,
NSheet=1,
xColumn=1,
yColumn=2) |
source code
|
|
|
|
| changeSeriesXValuesColumn(self,
NColumn=2,
NSeries=1) |
source code
|
|
|
|
| setAllXValueColumns(self,
NColumn=1,
ZeroBased=0) |
source code
|
|
|
|
| changePlottedColumn(self,
NColumn=2,
NSeries=1) |
source code
|
|
|
|
|
|
|
makeNewChartOfPlottedColumns(self,
cols=(2),
ZeroBased=0,
chartName='')
use cols tuple to set all plotted columns if Number of Columns is
wrong, correct |
source code
|
|
|
|
setAllPlottedColumns(self,
cols=(2),
ZeroBased=0,
chartName='')
use cols tuple to set all plotted columns if Number of Columns is
wrong, correct |
source code
|
|
|
|
focusSheet(self,
N)
use 1-based index to Sheets |
source code
|
|
|
|
|
|
|
focusChart(self,
N)
use 1-based index to Charts |
source code
|
|
|
|
labelPrimaryYAxis(self,
yLabel='Vertical Axis') |
source code
|
|
|
|
|
|
|
|
|
|
changePlotTitle(self,
title='Data from Python Script') |
source code
|
|
|
|
| setPlotTitleSize(self,
pointSize=20,
bold=0) |
source code
|
|
|
|
putSeriesOnSecondary(self,
J,
y2Label='')
use 1-based index to Sheets |
source code
|
|
|
|
putSeriesOnPrimary(self,
J)
use 1-based index to Sheets |
source code
|
|
|
|
|
|
|
|
|
|
|
|
|
| setLineThickness(self,
NSeries=1,
thickness=1) |
source code
|
|
|
|
|
|
|
| setSeriesColorIndex(self,
NSeries=1,
colorIndex=1) |
source code
|
|
|
|
| setSeriesColor(self,
NSeries=1,
red=255,
green=0,
blue=0) |
source code
|
|
|
|
|
|
|
|
|
|
| turnMarkerOnOff(self,
NSeries=1,
showPoints=0) |
source code
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| setYrangeOnSecondary(self,
ymin=1.0,
ymax=10.0) |
source code
|
|
|
|
addTextBox(self,
text='comment',
left=100,
top=100,
width=50,
height=50,
border=3,
auto=1,
transparency=0.3,
isBold=0,
fontSize=0) |
source code
|
|
|
|
|
|
|
makeChart(self,
rs,
title='Data From Python',
nCurves=1,
sheetName='',
chartName='',
showPoints=1,
showLegend=1,
yLabel='Vertical Axis',
xLabel='Horizontal Axis')
make Excel Chart from rs rs is a tuple of tuples, or a list of lists
Top row of titles, then rows of data |
source code
|
|
|
|
makeDataSheet(self,
rs,
sheetName='DataSheet',
autoFit=1,
rowFormatL=None,
textFont='',
textFontSize=None)
make Excel Data Sheet from rs rs is a tuple of tuples, or a list of
lists Top row of titles, then rows of data |
source code
|
|
|
|
setRangeOfDataSheet(self,
rs,
sheetName='DataSheet',
upperLeft='$A$1')
add to Excel Data Sheet from rs rs is a tuple of tuples, or a list of
lists Top row of titles, then rows of data |
source code
|
|
|
|
setRangeOnCurrentSheet(self,
rs,
upperLeft='$A$1')
add to Excel Data Sheet from rs rs is a tuple of tuples, or a list of
lists Top row of titles, then rows of data |
source code
|
|
|
|
pageSetupForSheet(self,
landscape=0,
fitWidth=0,
fitHeight=0,
marginInches=0.0)
use active sheet |
source code
|
|