def SetCellColor(x, y, color): """Sets the background of the cell at (x,y) (zero-based column and row indices, for example (2,3) == C4) on the first sheet and returns the contents of the cell as a string. """ #get the doc from the scripting context which is made available to all scripts desktop = XSCRIPTCONTEXT.getDesktop() model = desktop.getCurrentComponent() #check whether there's already an opened document if not hasattr(model, "Sheets"): return "" sheet = model.Sheets.Sheet1 cell = sheet.getCellByPosition(x, y) cell.CellBackColor = color return cell.String
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
pythonSamples | Folder | 0755 |
|
|
Capitalise.py | File | 3.3 KB | 0644 |
|
HelloWorld.py | File | 1.55 KB | 0644 |
|
InsertText.py | File | 2.35 KB | 0644 |
|
NamedRanges.py | File | 2.04 KB | 0644 |
|
SetCellColor.py | File | 634 B | 0644 |
|