setStyle Method

Sets the style information for a specified cell in the specified sheet area.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var returnValue; // Type: any
returnValue = instance.setStyle(row, column, value, sheetArea);

function setStyle( 
   row : number,
   column : number,
   value : Style,
   sheetArea : SheetArea
) : any;

Parameters

row: The row index.
column: The column index.
value: The cell style.
sheetArea: The sheet area. If this parameter is not provided, it defaults to viewport.

Example

This example uses the setStyle method.

Javascript

var style = new GC.Spread.Sheets.Style();
style.backColor = "lightgreen";
style.backgroundImage = "./css/images/quarter1.png";
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);

Reference

Worksheet type