SetCellHeaderStyle method: PSSpreadsheet class

Syntax

SetCellHeaderStyle(rownum, colnum, redvalue, greenvalue, bluevalue, boldweight, color, fontheight, fontname)

Description

Use the SetCellHeaderStyle method to set the format for the specified cell in the active spreadsheet.

Parameters

Parameter Description

rownum

Specifies the row number for the cell.

colnum

Specifies the column number for the cell.

redvalue

Specifies the red color value (from 0 to 256) for the specified cell.

greenvalue

Specifies the green color value (from 0 to 256) for the specified cell.

bluevalue

Specifies the blue color value (from 0 to 256) for the specified cell.

boldweight

Specifies the bold weight for the specified cell.

color

Specifies the color value for the specified cell.

fontheight

Specifies the font height for the specified cell.

fontname

Specifies the name of the font for the specified cell.

Returns

(Optional) A Boolean value: True if the method completes successfully, False otherwise.

Example

The following example sets the format for the specified cell within the spreadsheet.

&rownum = 2;
&colnum = 2;
&red = 100;
&green = 100;
&blue = 100;
&boldweight = 10;
&color = 100;
&fontheight = 10;
&fontname = "Helvetica";
&ssObject.SetCellHeaderStyle(&rownum, &colnum, &red, &green, &blue, &boldweight, &color, &fontheight, &fontname);