VS:SetWSCellFill
Jump to navigation
Jump to search
.VectorScript|VectorScript ..VS:Function Reference|Function Reference ..VS:Function_Reference_Appendix|Appendix
Description
Sets the fill style and color of a cell in the referenced worksheet
SetWSCellFill allows cell fill style and color text to be set for a range of cells. To set fill style and color for a single cell, specify identical values for the top/bottom and left/right range boundaries.
PROCEDURE SetWSCellFill(
worksheet :HANDLE;
topRow :INTEGER;
leftColumn :INTEGER;
bottomRow :INTEGER;
rightColumn :INTEGER;
style :INTEGER;
bgcolor :LONGINT;
fgcolor :LONGINT;
fillpattern :INTEGER);
def vs.SetWSCellFill(worksheet, topRow, leftColumn, bottomRow, rightColumn, style, bgcolor, fgcolor, fillpattern): return None
Parameters
worksheet HANDLE Handle to worksheet topRow INTEGER Top row of cell range leftColumn INTEGER Left column of cell range bottomRow INTEGER Bottom row of cell range rightColumn INTEGER Right column of cell range style INTEGER Cell fill style to be set bgcolor LONGINT Cell background color index value to be set fgcolor LONGINT Cell foreground color index value to be set fillpattern INTEGER Cell pattern index value to be set
Remarks
bgcolor - cell background color (0 if none)
fgcolor - cell foreground color (0 if none) fillpattern - cell fill pattern index (-1 if none)
Fill style constants: no fill = 0 solid fill= 1 pattern fill= 2
Version
Availability: from VectorWorks12.0