setSheetCount Method

Sets the number of sheets.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Workbook(host);
var value; // Type: any
value = instance.setSheetCount(count);

function setSheetCount( 
   count : number
) : any;

Parameters

count: The number of sheets.

Example

This example puts three sheets in a spreadsheet, specifies the first sheet to display, and sets the tab color for the sheets.

Javascript

spread.setSheetCount(3);
spread.startSheetIndex(0);
spread.getSheet(0).options.sheetTabColor = "red";
spread.getSheet(1).options.sheetTabColor = "#FFFF00";
spread.getSheet(2).options.sheetTabColor = "Accent 4";

This example sets the spreadsheet to have five sheets.

Javascript

spread.setSheetCount(5);

Reference

Workbook type