A1Style(self, row1, column1, row2=0, column2=0, sheetname='~') | scriptforge.SFDocuments.SF_Calc | |
Activate(self, sheetname='') | scriptforge.SFDocuments.SF_Calc | |
Charts(self, sheetname, chartname='') | scriptforge.SFDocuments.SF_Calc | |
ClearAll(self, range, filterformula='', filterscope='') | scriptforge.SFDocuments.SF_Calc | |
ClearFormats(self, range, filterformula='', filterscope='') | scriptforge.SFDocuments.SF_Calc | |
ClearValues(self, range, filterformula='', filterscope='') | scriptforge.SFDocuments.SF_Calc | |
CompactLeft(self, range, wholecolumn=False, filterformula='') | scriptforge.SFDocuments.SF_Calc | |
CompactUp(self, range, wholerow=False, filterformula='') | scriptforge.SFDocuments.SF_Calc | |
CopySheet(self, sheetname, newname, beforesheet=32768) | scriptforge.SFDocuments.SF_Calc | |
CopySheetFromFile(self, filename, sheetname, newname, beforesheet=32768) | scriptforge.SFDocuments.SF_Calc | |
CopyToCell(self, sourcerange, destinationcell) | scriptforge.SFDocuments.SF_Calc | |
CopyToRange(self, sourcerange, destinationrange) | scriptforge.SFDocuments.SF_Calc | |
CreateChart(self, chartname, sheetname, range, columnheader=False, rowheader=False) | scriptforge.SFDocuments.SF_Calc | |
CreatePivotTable(self, pivottablename, sourcerange, targetcell, datafields=ScriptForge.cstSymEmpty, rowfields=ScriptForge.cstSymEmpty, columnfields=ScriptForge.cstSymEmpty, filterbutton=True, rowtotals=True, columntotals=True) | scriptforge.SFDocuments.SF_Calc | |
DAvg(self, range) | scriptforge.SFDocuments.SF_Calc | |
DCount(self, range) | scriptforge.SFDocuments.SF_Calc | |
DMax(self, range) | scriptforge.SFDocuments.SF_Calc | |
DMin(self, range) | scriptforge.SFDocuments.SF_Calc | |
DSum(self, range) | scriptforge.SFDocuments.SF_Calc | |
ExportRangeToFile(self, range, filename, imagetype='pdf', overwrite=False) | scriptforge.SFDocuments.SF_Calc | |
FirstCell(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
FirstColumn(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
FirstRow(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
forceGetProperty | scriptforge.SFDocuments.SF_Calc | static |
Forms(self, sheetname, form='') | scriptforge.SFDocuments.SF_Calc | |
GetColumnName(self, columnnumber) | scriptforge.SFDocuments.SF_Calc | |
GetFormula(self, range) | scriptforge.SFDocuments.SF_Calc | |
GetValue(self, range) | scriptforge.SFDocuments.SF_Calc | |
Height(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
ImportFromCSVFile(self, filename, destinationcell, filteroptions=ScriptForge.cstSymEmpty) | scriptforge.SFDocuments.SF_Calc | |
ImportFromDatabase(self, filename='', registrationname='', destinationcell='', sqlcommand='', directsql=False) | scriptforge.SFDocuments.SF_Calc | |
InsertSheet(self, sheetname, beforesheet=32768) | scriptforge.SFDocuments.SF_Calc | |
LastCell(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
LastColumn(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
LastRow(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
MoveRange(self, source, destination) | scriptforge.SFDocuments.SF_Calc | |
MoveSheet(self, sheetname, beforesheet=32768) | scriptforge.SFDocuments.SF_Calc | |
Offset(self, range, rows=0, columns=0, height=ScriptForge.cstSymEmpty, width=ScriptForge.cstSymEmpty) | scriptforge.SFDocuments.SF_Calc | |
OpenRangeSelector(self, title='', selection='~', singlecell=False, closeafterselect=True) | scriptforge.SFDocuments.SF_Calc | |
Printf(self, inputstr, range, tokencharacter='%') | scriptforge.SFDocuments.SF_Calc | |
PrintOut(self, sheetname='~', pages='', copies=1) | scriptforge.SFDocuments.SF_Calc | |
Range(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
Region(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
RemoveDuplicates(self, range, columns=1, header=False, casesensitive=False, mode='COMPACT') | scriptforge.SFDocuments.SF_Calc | |
RemoveSheet(self, sheetname) | scriptforge.SFDocuments.SF_Calc | |
RenameSheet(self, sheetname, newname) | scriptforge.SFDocuments.SF_Calc | |
ReviewServiceArgs(cls, windowname='') | scriptforge.SFDocuments.SF_Calc | |
serviceimplementation | scriptforge.SFDocuments.SF_Calc | static |
servicename | scriptforge.SFDocuments.SF_Calc | static |
serviceproperties | scriptforge.SFDocuments.SF_Calc | static |
servicesynonyms | scriptforge.SFDocuments.SF_Calc | static |
SetArray(self, targetcell, value) | scriptforge.SFDocuments.SF_Calc | |
SetCellStyle(self, targetrange, style, filterformula='', filterscope='') | scriptforge.SFDocuments.SF_Calc | |
SetFormula(self, targetrange, formula) | scriptforge.SFDocuments.SF_Calc | |
SetValue(self, targetrange, value) | scriptforge.SFDocuments.SF_Calc | |
Sheet(self, sheetname) | scriptforge.SFDocuments.SF_Calc | |
SheetName(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
ShiftDown(self, range, wholerow=False, rows=0) | scriptforge.SFDocuments.SF_Calc | |
ShiftLeft(self, range, wholecolumn=False, columns=0) | scriptforge.SFDocuments.SF_Calc | |
ShiftRight(self, range, wholecolumn=False, columns=0) | scriptforge.SFDocuments.SF_Calc | |
ShiftUp(self, range, wholerow=False, rows=0) | scriptforge.SFDocuments.SF_Calc | |
SortRange(self, range, sortkeys, sortorder='ASC', destinationcell=ScriptForge.cstSymEmpty, containsheader=False, casesensitive=False, sortcolumns=False) | scriptforge.SFDocuments.SF_Calc | |
Width(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
XCellRange(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
XSheetCellCursor(self, rangename) | scriptforge.SFDocuments.SF_Calc | |
XSpreadsheet(self, sheetname) | scriptforge.SFDocuments.SF_Calc | |